Exam (elaborations)
CISM Excel 5 Exam With Complete Solutions Latest Update
- Course
- Institution
CISM Excel 5 Exam With Complete Solutions Latest Update...
[Show more]
Content preview
CISM Excel 5 Exam With Complete SolutionsLatest Update
Which of the following is the term for referring to data in another workbook? ANSWER
Linking workbooks
Which of the following statements is true? ANSWER Consolidation by category can be
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 adds a file property of Read-only? -ANSWER Mark as Final
Which of the following is the first step to create a screenshot clipping in a worksheet?
-ANSWER Click the sheet tab where the screenshot will be embedded
When a screenshot graphic object has been selected, which of the following
context-sensitive tabs appear? -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 screenshot? - 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 shortcut 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 is NOT a true statement about using the SmartArt Tools tabs? -
ANSWER You cannot change to a different image
Which of the following appears after the file name in the title bar after worksheets have
been grouped? - ANSWER [Group]
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
You are creating a consolidation worksheet. How do you treat the range of cells to be
consolidated? - ANSWER delete the contents
Which of the following is NOT one of the functions in the Consolidate dialog box? -
ANSWER PMT
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Chrisyuis. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now