Coursera | Excel Skills For Business: Essential

Printing: Test your skills

Printing: Test your skills >> Excel Skills For Business: Essential

1. The attached workbook is needed to answer all the questions associated with this quiz. Open the attached workbook and investigate what this document will look like when printed (do not actually print). How many pages will print?
W05-Assessment.xlsx

3

2. What Margin setting has been selected?

  • Wide
  • Normal
  • Narrow
  • No Margin

3. Which Orientation has been selected?

  • A4
  • Landscape
  • Portrait
  • Letter

4. A Custom Scale has been applied.

  • True
  • False

5. How many page breaks have been added?
For Mac users, switch to the Page Layout view, then back to Normal to see the page breaks. Manual page breaks will still be dotted lines.
You can also use the Print Preview to find out the number of pages. The number of added page breaks is 1 fewer than the number of pages.

2

6. If we wanted to insert another page break between rows 20 and 21 we would need to click on which cell first? (We only want to add a horizontal page break). For your answer, enter a cell reference e.g. B5.

A21

7. For the printed version of the page, based on the existing setup, which of the following is true? (One or more answers may be correct)

  • A page number has been added to the header
  • Total Number of pages has been added to the header
  • A page number has been added to the footer
  • Total Number of pages has been added to the footer

8. For the printed version of the page, based on the existing setup, the first four rows repeat on every page. To stop this we would:

  • Untick Headings (on Page Layout Tab)
  • Adjust settings in Print Titles
  • Adjust settings in Custom Margins
  • Remove Page Breaks

9. If we insert a column between C and D which of the following happens? (One or more answer may be correct)

  • We now have 6 pages to print
  • We get another page break
  • Nothing changes
  • The custom scaling changes

10. Before we can manually change the custom scaling, we must:

  • Set Orientation to Landscape
  • Set Page Width to Automatic
  • Reset Page Breaks
  • Remove Print Titles

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *