Making Excel View Types Work Excel Test

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Making Excel View Types Work for You Excel Test

1) Under which tab and within which group on the Ribbon will you find Excel view types?

a) Under the Page Layout tab in the Workbook Views group.
b) Under the View tab in the Workbook Views group.
c) Under the View tab in the Worksheet Views group.
d) Under the Display tab in the Excel Views group.

4) James added automatic page numbers to his Excel worksheet footer, but it is displaying as: &[Page] of &[Pages] (see screenshot above). What is the problem?

a) James mistyped the page numbers or his keyboard is broken.
b) James tried to use a formula as a page number.
c) James is still in the footer and needs to click away from it for the page number to display.
d) James changed view types whilst editing the footer. He needs to return to the Page Layout view.

5) Which view type could you use to automatically set the worksheet display to: zoom 150% and hide Gridlines?

6) Which of the following content can you add to the Header or Footer of a worksheet page?

a) Date and time.
b) Page numbers and total pages.
c) Company logo or images.
d) All the items listed above.

7) Study the screenshot above. What is the purpose of the two areas outlined in orange and numbered 1 and 2?

a) These are the horizontal and vertical rulers in the Page Layout view.
b) These are the row and column labels in the Page Layout view.
c) These are the row and column labels in the Normal view.
d) These are the Page Break Preview lines.

8) Dave is trying to create a custom view in Excel, however, the Custom View tab is greyed out (see screenshot above) and he cannot click it. What is the problem?

a) He is in the Normal view, which makes the Custom View option unavailable.
b) His worksheet contains tables, which makes the Custom View option unavailable.
c) He already has a custom view applied and cannot use another one, therefore the Custom View option is unavailable.
d) He does not own a full version of Microsoft Excel 2016.

9) Study the screenshot above. What is the purpose of the blue lines numbered 1 and 2?

a) These are column and row markers that can be moved to resize columns or rows.
b) These are page break markers that can be dragged to set where a page breaks off when printed.
c) These are page layout or paragraph borders. You can change their color to make your worksheet look nice.
d) All of the options listed above are correct.

10) What steps do you need to take to reapply a customized view that you created?

a) Under the View tab on the Ribbon in the Workbook Views group, select Custom Views and select the name of your view from the list.
b) Right-click your worksheet and select the name of your Custom Views format from the menu.
c) Select the worksheet and type the name of the Custom View you created into the Formula bar at the top of the document.
d) All the options listed above are correct.