CISM Test 2 Practice Questions and Answers (100% Pass)

CISM Test 2 Practice Questions and Answers (100% Pass) Which of the following statements about SmartArt graphics is not true? - Answer️️ -SmartArt graphic is linked to worksheet data Which of the following tab and group options format a hyperlink? - Answer️️ - Insert tab, hyperlink If values are edited in source worksheets used in a static consolidation, which of the following commands will update the results? - Answer️️ -consolidate command Which of the following is not true when typing text in a shape? - Answer️️ - Selecting one shape selects all shapes in the SmartArt graphic. When creating a consolidation worksheet, what must you do to the range of cells to be consolidated? - Answer️️ -delete the contents Which of the following is the keyboard shortcut for inserting a hyperlink? - Answer️️ -Ctrl+K ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM 2 Which consolidation method is used when data in multiple worksheets is arranged differently but has the same row and column labels? - Answer️️ -Consolidation by category Which of the following ungroups all sheets in a workbook? - Answer️️ -Right- click any sheet tab and choose Ungroup Sheets Which of the following is a separate summary sheet in a workbook? - Answer️️ - Consolidation worksheet Which of the following statements is not true about using the S