facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Printing Basics Excel Test

Excel 2010 Training - Printing
Free Online Microsoft Excel Test

* Print Preview
* Set Paper Size and Layout
* Repeat a Heading Row
* Page Break Preview

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Printing Basics Excel Test

Question 1 - Printing Basics Excel Test
1) Above is a screenshot of the Print Preview area.  Which of the following methods will allow you to access this view?
a) Pressing Ctrl+Shift+P on your keyboard will take you directly to the Print Preview area.
b) Clicking on the View tab on the Ribbon and selecting Print Preview in the Worksheets Views group will launch this view.
c) Clicking on the File tab on the Ribbon and selecting Print from the list will take you directly to the Print Preview area.
d) All of the above are methods for accessing the Print Preview area.


2) Which of the following options is not a valid paper size setting in Excel?
a) Landscape
b) A3
c) Letter
d) Tabloid


Question 3 - Printing Basics Excel Test
3) Study the screenshot above.  Which worksheet view appears to be activated?
a) Print Preview showing the number of pages the worksheet will print over.
b) Page Break Preview showing the number of pages the worksheet will print over.
c) Print Break Preview showing the number of pages the worksheet will print over.
d) Page Layout showing the number of pages the worksheet will print over.

4) Where will you find the Page Break Preview view function?
a) By pressing Ctrl+P on your keyboard.
b) By clicking on the File button to access the Backstage view and selecting Print from the list.
c) By clicking on the View tab on the Ribbon and selecting Page Break Preview in the Workbook Views group.
d) All of the options listed above are correct.

Question 5 - Printing Basics Excel Test
5) Study the worksheet above.  How would you go about repeating the rows at the top that contain the title as well as the column headings (circled in yellow above)? 
a) Select the rows and press Copy, open Page Break Preview and then Paste the rows at the top of each page.
b) Select the rows and under the Page Layout tab on the Ribbon, tick the box next to Repeat as Header Row.
c) Under the Page Layout tab on the Ribbon, click on Print Titles.  Insert the row references into the Rows to Repeat at top box and press OK.
d) All of the above options are correct.

6) How do you exit the Print Preview area of the Backstage View if you do not wish to go ahead with printing your document?
a) Press the Escape key.
b) Press on the Home tab.
c) Press on the Page Layout tab.
d) All of the above options are correct.
Question 7 - Printing Basics Excel Test
7) Study the worksheet above.  Which of the following will ensure the worksheet prints on one page only?
a) Change the Page Layout to Portrait Orientation and move the vertical page break between pages 1 and 2 to the end of the sheet.
b) Move the vertical page break between pages 1 and 2 to the end of the sheet.
c) The worksheet is small already and will print on one page only.
d) Change the margins of worksheet to Wide to ensure it prints on one page only.


8) Which of the following is not a pre-set page Margin option?
a) Wide – enlarges the printable area of the page.
b) Wide – enlarges the margin area of the page.
c) Narrow – enlarges the printable area of the page.
d) Normal – balance between margin area and printable area of a page.



9) Where will you find the function to repeat the header row of a worksheet on every printed page?
a) Under the Insert tab, go to the Text group, click on the Text Box button.
b) Under the Page Layout tab, go to the Sheet Options group and tick the box for Print Header Row.
c) Under the Page Layout tab, go to the Page Setup group and click on the Print Titles button.
d) In the Print Preview view, click on the Print Area button and select Print Headings at Top.

10) How do you scroll through all the pages in your worksheet in the Print Preview area?
a) In the Print Preview Area, click on the Next Page and Previous Page arrows located to the left and right of the number of pages box.
b) You have to access each section of your worksheet individually by selecting the area and then going to Print Preview.
c) Click on the Page Setup box in the center panel of the Print Preview Area and select All Pages from the menu list.
d) All of the above options are correct.