CISM Excel 5 Practice Questions and Answers (100% Pass)

CISM Excel 5 Practice Questions and Answers (100% Pass) Which of the following is the process of referring to data in another workbook? - Answer️️ -Linking workbooks Which of the following statements is true? - Answer️️ -Consolidation by category can be either static or dynamic Which of the following should you use when data on source worksheets might be edited after you have created the consolidation worksheet? - Answer️️ -Dynamic Consolidation Which of the following commands sets a read-only file property? - Answer️️ - Mark as Final Which of the following is the first step to insert a screenshot clipping in a worksheet? - Answer️️ -Click the sheet tab where the screenshot will be inserted When a screenshot graphic object is selected, which of the following context- sensitive tabs display? - Answer️️ -Picture Tools, Format tab Which of the following describes a SmartArt graphic bounding frame? - Answer️️ -The bounding frame is a rectangle that surrounds the graphic ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM 2 Which of the following is used to select nonadjacent sheets? - Answer️️ -Ctrl When creating a cell hyperlink, which of the following is not true when selecting a Place in this Document option? - Answer️️ -The cell reference and defined names group cannot be expanded Which of the following makes it easier to take screenshots? - Answer️️ - arranging open windows side by side Which of the following is an example of an external reference with all of its identifiers? - Answer️️ -='[WorkbookName]WorksheetName'!CellRange Which of the following keyboard shortcuts switches to the next open workbook? - Answer️️ -Ctrl+F6 Which of the following moves the pointer to another workbook or web page? - Answer️️ -Hyperlink Which of the following statements is not true about using the SmartArt Tools tabs? - Answer️️ -You cannot change to a different image Which of the following displays after the file name in the title bar when worksheets are grouped? - Answer️️ -[Group] ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM 3 Which of the following statements about SmartArt graphics is not true? - Answer️️ -A SmartArt graphic is linked to worksheet data. Which of the following is the keyboard shortcut for inserting a hyperlink? - Answer️️ -Ctrl+K When creating a consolidation worksheet, what must you do to