facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Printing Large Excel Worksheets Test

Excel 2010 Training - Printing
Free Online Microsoft Excel Tutorial

* Scaling a Page for Printing
* Insert Page Breaks
* Move Page Breaks in Page Break Preview Window
* Set Print Area

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Printing Large Excel Worksheets Test

Question 1 Printing Large Excel Worksheets Test
1) Study the screenshot above.  Over how many pages will this worksheet print?
a) It will print over only one page.
b) It will Print over eight pages.
c) It will print over two pages.
d) It is impossible to tell over how many pages it will print.


2) If a worksheet has multiple columns that need to fit on the same page, which of the following options would be a useful setting towards achieving this?
a) Setting the page layout to Landscape Orientation.
b) Changing the page margin size to Narrow.
c) Using the Fit All Columns on One Page Scaling option.
d) All of the above options can be used in conjunction with one another to ensure the columns fit the page.

3) To print a worksheet so that the columns will not exceed the width of one page and the rows will not exceed ten pages, which setting entered into the Page Setup box under Scaling will achieve this?
a) Fit to 1 page(s) wide by 10 tall.
b) Fit to 10 page(s) wide by 1 tall.
c) Adjust to 100 % wide and 10 % tall.
d) None of the above options are correct.
Question 4 Printing Large Excel Worksheets Test
4) Study the screenshot above.  If you wished to insert a page break after the row highlighted in yellow (Row 22), how would you do this?
a) Select Row 23 and press Ctrl+Enter on your keyboard.
b) Select Row 23, click on Breaks on the Ribbon and select Insert Page Break.
c) Select Row 22, click on Breaks on the Ribbon and select Insert Page Break.
d) Select Row 23, right-click and select Insert from the menu list.


Question 5 Printing Large Excel Worksheets Test
5) Study the screenshot above.  Which view type is this and how do you access it?
a) This is the Normal View.  Click on the File tab and select Normal from the list.
b) This is the Print Preview view.  Click on the File tab and select Print from the list.
c) This is the Page Break Preview view.  Click on Page Break Preview under the View tab on the Ribbon.
d) This is the Page Layout view.  Click on Page Layout View under the View tab on the Ribbon.


6) Don received a worksheet from a colleague.  Every time he tries to print the sheet, only the first three columns print.  Which of the following options will solve this problem?
a) He needs to select the whole worksheet by pressing Ctrl+A before pressing Print.
b) He needs to select Print Active Sheets from the Print Area options.
c) He needs to clear any Print Areas by clicking on Clear Print Area  under the Print Area button in the Page Setup Group.
d) He needs to clear any Page Breaks by clicking on the Breaks button and selecting Clear All Breaks.

7) To access specific Page Setup options such as Scaling, Orientation and Paper Size, where can you go to launch the Page Setup dialogue box?
a) Click on the Page Layout tab and click on the dialogue box launcher in the Page Setup group.
b) Click on the Page Setup link in the second pane of the Print Preview area.
c) Select Custom Scaling Options from the list that appears when you click on the Scaling button in the Print Preview area.
d) All of the above options are correct.


8) Under which tab on the Ribbon will you find the Print Area setting button, the insert Breaks function and the Page Orientation options?
a) Under the Page layout tab in the Page Setup group.
b) Under the Home tab in the Page Setup group.
c) Under the File tab in the Print Preview area.
d) Under the Insert tab in the Insert Page Elements group.


9) To ensure a worksheet, which does not contain that many rows and columns, fit on one page instead of slightly flowing over into two pages wide and two pages tall, which option should you select?
a) In the Print Area of the Backstage View, select Fit All Data on One Page from the Page Orientation button.
b) In the Print Area of the Backstage View, select Fit All Columns on One Page from the Scaling options button.
c) In the Print Area of the Backstage View, select Fit All Columns and Rows on One Page from the Scaling options button.
d) In the Print Area of the Backstage View, select Fit Sheet on One Page from the Scaling options button.

10) Is it possible to enlarge a worksheet so that it automatically increases the font size when printing?
a) If you select the Fit Sheet on One Page option from the Scaling options button, the content will automatically expand to fit the page.
b) If you enter a value in the Adjust to box that is more than 100%, the font will increase in size when printing the worksheet.
c) If you use the Zoom button in the Print Preview area to enlarge the Print Preview Pane view of your worksheet, it will print this size.
d) All of the options listed above are correct.