Excel Skills for Business Essentials

 Coursera week 5 Quiz

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

Enter answer here

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.

Enter answer here

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.

Enter answer here

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

 

Important link: