©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
Exam 1 CISM Questions and Answers (100% Pass)
Which of the following is true about table styles?
- It is possible to remove a style once you've applied it
- You must save you Ecvel file before you apply a table style
- you cannot apply a table style until you've used the quick analysis tool
-by default, table styles only apply red, green, and blue shading - Answer✔️✔️-It is
possible to remove a style once you've applied it
The cell address $G4 is a relative cell address - Answer✔️✔️-False
Which of the following keystroke combination completes a formula?
- Ctrl + Enter
- Ctrl + Esc
- Alt + Enter
- Alt + Esc - Answer✔️✔️-Ctrl + Enter
Each group of data points or values used in a graph is a data series?
- true
- false - Answer✔️✔️-true
1
,©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
Which of the following is a task you can perform using the Table Style Options
group of commands?
- Show or hide various parts of a table
- hide the header row or display a total row
- hide the AutoFilter arrows
- all of the above - Answer✔️✔️-All of the above
Which of the following is a document that includes basic data, no formatting, and
commas or other characters to separate the data into fields?
- text file
- field
- Text Import Wizard
- delimiter - Answer✔️✔️-text file
Which of the following shapes can be used to highlight an important area of a
graph?
- Circle
- Highlight
- Arrow
2
, ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
- All of the above - Answer✔️✔️-Circle
The IF function calculates loan payment amounts
- true
- false - Answer✔️✔️-True
You can easily create a default chart object by selecting the appropriate data and
pressing F1.
- true
- false - Answer✔️✔️-False, its alt F4
A legend is the chart element that explains the symbols, textures, or colors used to
differentiate data series.
- True
- False - Answer✔️✔️-True
Which of the following statements is true about Highlight Cells Rules?
- Highlight Cells Rules formatting uses relational operators,
- Highlight Cells Rules formatting uses comparison operators
- You can create your own rule using other operators or a formula
3
Exam 1 CISM Questions and Answers (100% Pass)
Which of the following is true about table styles?
- It is possible to remove a style once you've applied it
- You must save you Ecvel file before you apply a table style
- you cannot apply a table style until you've used the quick analysis tool
-by default, table styles only apply red, green, and blue shading - Answer✔️✔️-It is
possible to remove a style once you've applied it
The cell address $G4 is a relative cell address - Answer✔️✔️-False
Which of the following keystroke combination completes a formula?
- Ctrl + Enter
- Ctrl + Esc
- Alt + Enter
- Alt + Esc - Answer✔️✔️-Ctrl + Enter
Each group of data points or values used in a graph is a data series?
- true
- false - Answer✔️✔️-true
1
,©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
Which of the following is a task you can perform using the Table Style Options
group of commands?
- Show or hide various parts of a table
- hide the header row or display a total row
- hide the AutoFilter arrows
- all of the above - Answer✔️✔️-All of the above
Which of the following is a document that includes basic data, no formatting, and
commas or other characters to separate the data into fields?
- text file
- field
- Text Import Wizard
- delimiter - Answer✔️✔️-text file
Which of the following shapes can be used to highlight an important area of a
graph?
- Circle
- Highlight
- Arrow
2
, ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
- All of the above - Answer✔️✔️-Circle
The IF function calculates loan payment amounts
- true
- false - Answer✔️✔️-True
You can easily create a default chart object by selecting the appropriate data and
pressing F1.
- true
- false - Answer✔️✔️-False, its alt F4
A legend is the chart element that explains the symbols, textures, or colors used to
differentiate data series.
- True
- False - Answer✔️✔️-True
Which of the following statements is true about Highlight Cells Rules?
- Highlight Cells Rules formatting uses relational operators,
- Highlight Cells Rules formatting uses comparison operators
- You can create your own rule using other operators or a formula
3
