CES CES Workbook & Worksheet Management 2

Question 1

Which Excel feature lets you save a set of print settings, column widths, and filters for a worksheet?

Accepted Answer

Custom View

Answer

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?

Accepted Answer

To apply the same edits to multiple sheets simultaneously

Answer

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?

Accepted Answer

=SUM(Sheet1:Sheet3!B5)

Answer

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?

Accepted Answer

Sets the workbook to read-only and disables editing by default

Answer

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?

Accepted Answer

Print Titles

Answer

Print Titles lets you specify rows to repeat at the top and/or columns to repeat at the left on every printed page.

CES - Certified Excel Specialists Practice Test