CES Workbook & Worksheet Management Flashcards
6 cards from real CES practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 CES Workbook & Worksheet Management flashcards as text
What is the difference between hiding a sheet and protecting a workbook structure in Excel?
Answer: Hiding removes the tab visually; protecting the structure prevents sheets from being unhidden, moved, or deleted
Right-click hiding simply removes the tab from view, while Protect Workbook Structure requires a password to prevent users from revealing, moving, or deleting sheets.
Which built-in Excel view shows page breaks and lets you drag them to adjust print layout?
Answer: Page Break Preview
Page Break Preview displays blue dashed and solid lines representing page breaks and allows you to drag them to reposition where pages split.
To consolidate data from identical cell ranges across multiple worksheets into one summary sheet, which tool is most appropriate?
Answer: Data > Consolidate
Data > Consolidate aggregates data from multiple ranges (including across sheets) using functions like Sum, Average, or Count.
What file format should you choose to save a workbook with macros so they are retained?
Answer: .xlsm
.xlsm is the macro-enabled workbook format; saving as .xlsx strips all VBA code from the file.
Which Excel feature allows multiple users to edit a workbook simultaneously when stored on a shared network location (legacy method)?
Answer: Shared Workbook
The legacy Shared Workbook feature (Review > Share Workbook) allowed multiple users to edit simultaneously, though Microsoft now recommends co-authoring via OneDrive.
Which keyboard shortcut moves you to the next worksheet to the right in Excel?
Answer: Ctrl+Page Down
Ctrl+Page Down navigates to the next sheet to the right, while Ctrl+Page Up moves to the sheet to the left.