CISM Excel 5 Exam Questions with Correct Answers

CISM Excel 5 Exam Questions with Correct Answers 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 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