Exam 1 CISM Questions and Answers (100% Pass)

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 ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM 2 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 ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM 3 - 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 ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM 4 - all of the above - Answer️️ -All of the above When pasting data from a word document into Excel, you can keep the Word formatting intact or choose the current worksheet format. - true - false - Answer️️ -True Which of the following encompasses all of the other items? - shape style - shape fill - shape outline - shape effects - Answer️️ -Shape Style Which of the following use ranking or averages to format c