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
Which Excel feature lets you save a set of print settings, column widths, and filters for a worksheet?
Answer: Custom View
Custom Views save the current display and print settings so you can switch between different configurations quickly.
What is the purpose of grouping worksheets in Excel?
Answer: To apply the same edits to multiple sheets simultaneously
When sheets are grouped, any typing, formatting, or data entry performed on one sheet is replicated to all sheets in the group.
How do you create a 3D reference that sums cell B5 across Sheet1 through Sheet3?
Answer: =SUM(Sheet1:Sheet3!B5)
The syntax Sheet1:Sheet3!B5 creates a 3D reference that spans all sheets from Sheet1 to Sheet3 at the same cell address.
What does 'Mark as Final' do when applied to an Excel workbook?
Answer: Sets the workbook to read-only and disables editing by default
Mark as Final sets the document status to Final, makes it read-only, and disables typing, editing commands, and proofing marks.
Which option in Page Setup controls what Excel prints when a worksheet spans multiple pages?
Answer: Print Titles
Print Titles lets you specify rows to repeat at the top and/or columns to repeat at the left on every printed page.
Where do you go to change a workbook's default font and font size for new workbooks?
Answer: File > Options > General
File > Options > General contains the 'When creating new workbooks' section where you set the default font, size, and number of sheets.