facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Making Excel View Types Work for You Excel Test
Excel 2016 Training - Getting Started in Excel 2016
Free Online Microsoft Excel Test

* Excel Normal View
* Excel Page Break Preview
* Excel Page Layout View
* Excel Custom Views

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.


Question 2 - Making Excel View types work for you - Excel 2016 Test - Learn Excel Basics
2) Study the screenshot above.  Which view type is this?
a) The Page Break Preview.
b) The Page Layout view.
c) The Normal View.
d) The Margin View.


3) In which Excel view type can you edit the headers and footers of a page in a worksheet?
a) The Page Break Preview.
b) The Normal View.
c) The Page Layout View.
d) None of the views listed above.




Question 4 - Making Excel View types work for you - Excel 2016 Test - Learn Excel Basics
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?
a) The Page Layout view.
b) The Custom Views.
c) The Normal view.
d) Page Break Preview.


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.


Question 7 - Making Excel View types work for you - Excel 2016 Test - Learn Excel Basics

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.



Question 8 - Making Excel View types work for you - Excel 2016 Test - Learn Excel Basics
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.



Question 9 - Making Excel View types work for you - Excel 2016 Test - Learn Excel Basics
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.