MS Office Training Test

Computer Training Perth

Send 7 of mail merged letters to managers of paint outlets in each state; reporting all states sales figures.

This is an open book test.  You can also use the F1 key for MS Office help. Common formulas:

Addition=sum(first cell coordinate:last cell coordinate)
Multiplication*
Division/
Equals=
  1. Open your Excel file you created in previous lessons
  2. Right click any tab at the bottom left of the page  >  Insert  >  New Sheet.
  3. Rename the new sheet "Test" and colour the tab light green.
  4. Add the following data to the new sheet.
  5.  200020012002200320042005
    WA223315384448
    NSW181825324832
    Vic171821222224
    QLD161613151717
    SA15151561516
  6. The numbers below each year represent litres of paint sold.  Assume @ $2 / litre
  7. Show totals in column "H" with an Australian total in H8.
  8. On the "Test" Sheet create a bar chart for Western Australian sales ONLY for 5 years.  Extra marks for labelling.
  9. On the "Test" Sheet create a simple (non fragmented) pie chart for All states year 2000 only sales.
  10. Save Excel file in Prac folder with your name.
  11. Bonus marks for those who can save another chart on the Test sheet, showing paint sales of all state over all 5 years.  Tip: Start by selecting all of what is shown in part 4 above.
  12. Report to the managers, using MS Word, as much as you can in the best way you know how including:
    1. Sales by litres table (like in point 4 above but with totals)
    2. Sales by dollars table (like in point 4 above but with totals)
    3. Litre sales chart
    4. Dollar sales chart
  13. Use the addresses you invented in previous lessons to mail merge your reports to.
    Tip:  You need to copy (Ctrl+C) tables and a chart to the NEW original mail merge document file named and saved as "mail merge source.doc"  Use the letter mail merge wizard to merge to another Word document I want you to save to the file name "mail merge test.doc"
  14. A unique first paragraph scores bonus marks.
  15. Once you have completed the basics of this Excel info into mail merge report, you can go back to your Excel table and work on formatting (working on it's appearance) and then work on the formatting of the test Word doc.

 

Next Week:

Removing a series from a chart. Eg WA

Hypertext links to www resources (eg web pages) in Word and Excel

and

Creation of PDFs from Word and Excel

Enrolment

INTERNET TRAINING:

html

Photoshop

Uploading

Web Marketing

Beginners Net

XMl Java IT Architecture

MultiMedia

How to Start an Ezine

BUSINESS SOFTWARE TRAINING

Excel Training

MS Word for word processing

Windows and file management

Quicken and QuickBooks

Video Training

 MYOB

Database

OutLook

PowerPoint

Photoshop

Digital Video Production

Professional Development

Adobe Training Index

Adobe Acrobat PDF Writer training PerthAcrobat PDF Converter

Perth Computer Training Certificate

 


Perth Links

Perth Map

Public Holidays

Perth Training Forum

Business Coaching

Training Enrolment

Training Venue

4 Web Marketing

Email
 

School Holidays


Principal
Computer Training / Internet Training Perth
194 The Esplanade
Scarborough
Western Australia Australia 6922

EMAIL Perth Computer Training Instructors



Top Computer Training Perth