CES CES Workbook & Worksheet Management 2 — Questions and Answers
Question 1: Which Excel feature lets you save a set of print settings, column widths, and filters for a worksheet?
- Custom View (Correct answer)
- Named Range
- Page Layout
- Print Area
Correct answer: Custom View
Custom Views save the current display and print settings so you can switch between different configurations quickly.
Question 2: What is the purpose of grouping worksheets in Excel?
- To merge their data into one sheet
- To apply the same edits to multiple sheets simultaneously (Correct answer)
- To hide sheets from other users
- To link sheets with 3D references
Correct 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.
Question 3: How do you create a 3D reference that sums cell B5 across Sheet1 through Sheet3?
- =SUM(Sheet1:Sheet3!B5) (Correct answer)
- =SUM(Sheet1!B5,Sheet3!B5)
- =3DSUM(Sheet1,Sheet3,B5)
- =SUM(Sheet1-Sheet3!B5)
Correct 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.
Question 4: What does 'Mark as Final' do when applied to an Excel workbook?
- Permanently deletes edit history
- Sets the workbook to read-only and disables editing by default (Correct answer)
- Encrypts the file with a password
- Removes all comments and track changes
Correct 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.
Question 5: Which option in Page Setup controls what Excel prints when a worksheet spans multiple pages?
- Print Titles (Correct answer)
- Print Area
- Scale to Fit
- Sheet Options
Correct 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.
Question 6: Where do you go to change a workbook's default font and font size for new workbooks?
- Home > Font group
- File > Options > General (Correct answer)
- Review > Track Changes
- View > Workbook Views
Correct 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.
CES CES Workbook & Worksheet Management 2
Which Excel feature lets you save a set of print settings, column widths, and filters for a worksheet?