Exercise: 2007 Printing - MP expenses

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

The answer to the exercise will be included and explained if you attend the Wise Owl course listed below!

Category ==> Excel 2010  (83 exercises)
Topic ==> Printing  (5 exercises)
Level ==> Average difficulty
Course ==>
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Open the workbook called:    MPs formatted for printing       from the folder shown above.

In print preview, make the following changes to the print settings:

  • Change the margins to:
    Top:  8cm
    Left:  1cm
    Right: 1cm
    Bottom: 3cm
    (These settings should squeeze it onto one page - if not, reduce more!)
  • Centre the workbook on the page horizontally
  • Add a standard footer giving the current and total number of pages
  • Add a custom header with the following details:
    Left:  Current time is:      then the time is automatically printed
    Centre:  Creative Accounting          (in a fancy font)
    Right:  Confidential             (in a huge font!)

Check your new settings on the print preview screen and then print it out (if possible!).

Your workbook should look something like this in print preview:

Excel 2010 exercise - Printing (image 1)

Something like this is great!

Save the workbook with the new name:     MPs with print settings

This page has 0 threads Add post