facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

The Views in Excel Test

Free Online Microsoft Excel Tests
Excel 2010 - Getting Started

* Normal View 
* Page Layout View  
* Page Break Preview 
* Zoom Options

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

The Views in Excel Test

1) Study the image of a sample worksheet below this question.  Which view type does this represent?
a) The Normal View
b) The Page Layout
c) The Page Break View
d) The Zoom View
Question 1 - Microsoft Excel Test

2) Study the image above.  What will happen if I move the blue line located between columns D and E to the right, between columns G and H?
a) This will resize the print area and my worksheet will print on one page only.
b) This will resize the print area.
c) My worksheet will change to landscape orientation and print on one page only.
d) None of the above options are correct.

3) Study the image below taking note of the vertical and horizontal dotted lines across the center of the worksheet.  What is the purpose of these lines?
a) These are table border lines and help make the data easier to read.
b) These are printing guidelines as to where the center of each page is situated.
c) These represent section breaks denoting the different sections that will be printed.
d) These represent page breaks denoting where the edges of each page will be when printed.
Question 3 - Microsoft Excel Test

4) Which of the following view types can you use to insert headers, footers and page numbers into your worksheet?
a) The Page Layout View.
b) The Normal View.
c) The Page Break View.
d) All of the above.


5) Study the area circled in orange in the image below.  This is a page number that was inserted using the page number buttons in the Design tab in the Page Layout View.  Which of the following represents what this text will look like when printed?
a) &[Page] of &[Pages]
b) Page 1
c) 1 of 2
d) Page 1 of 2 Pages
Question 5 - Microsoft Excel Test

6) Your boss asks you to insert the company logo into your worksheet so that it will automatically display at the top of every printed page.  How will you go about doing this?
a) Display the worksheet in the Page Layout View and manually insert the company logo into the top of each individual page.
b) Add the company logo to the header or footer of the first page in the Page Layout View.
c) Insert the company logo into the top of the worksheet in Normal View.  It will automatically repeat.
d) It is not possible to insert logos into Excel.  Instead print the worksheets on company headed paper that contains the logo.

7) Which of the following is NOT a Zoom option/setting?
a) Zoom to Selection
b) 103%
c) Zoom to page
d) Fit Selection

8) Study the image below this question.  Myrtle's hand slipped whilst she was working on a spreadsheet and her data is now so small she is unable to read it.  Which of the following actions will solve her problem?
a) If she holds down the control key on her keyboard and scrolls her mouse wheel forwards, the magnification will be corrected.
b) If she clicks on the button that is labelled 100% in the Zoom group under the View tab, the magnification will be corrected.
c) If she clicks on the button that is labelled Zoom in the Zoom group under the View tab and type 120% into the custom box, the magnification will be corrected.
d) All of the above actions will solve her problem.

Question 8 - Microsoft Excel Test

9) Study the image below this question.  Which of the following statements are true about the header "January 2015 Price List"?
a) The header will appear on all the pages that are printed.
b) The header will appear only on the first page.
c) The header together with the text "My Candy Shop Sales" will appear on all printed pages.
d) The header will only display in the Page Layout view.  It will not print.
Question 9 - Microsoft Excel Test

10) Study the image below.  Which of the following statements is true with regard to this worksheet?
a) When printing, only the data within the blue borders will print.  The data with a grey background will not print.
b) The worksheet looks the way it does because it is viewed in the Page Layout view.  All the data will print including the data with a grey background.
c) The first page of the worksheet is selected.  If you click on the area with the grey background, the display will move to the second page.
d) The area within the blue borders represents the header that will be repeated on each page.
Question 10 - Microsoft Excel Test