OFFICE 2007 - OPERATE A SPREADSHEET APPLICATION

This course teaches you how to Operate a Spreadsheet Application, using Microsoft Excel from the Microsoft Office 2007 suite. You will work through the following chapters: Getting to Know Excel; Creating a New Workbook; Selecting Ranges; Formulas and Functions; Editing in a Workbook; Copying Excel Data; Formula Referencing; Font Formatting; Cell Alignment; Number Formatting; Working With a Worksheet; Saving Workbooks; Sorting Data; Printing; Page Setup; Creating Charts; and Common Chart Types.

Please do not hesitate to call us if you have any difficulties throughout this course. We will be more than happy to assist you.

---

This course requires Microsoft Office 2007 - Excel.

WHEN YOU ARE READY TO BEGIN

Step 1: Ensure your Practice Files are installed on your personal computer. We recommend that you make a new Folder on your Desktop and name it Spreadsheets. Then click on the link to each File in the following table. When the file opens, select the 'Save As' option and save it to your Spreadsheets folder. Do not change the file name, so that you can locate the correct file when your workbook instructs you to open it.

File 1	File 11	File 21	File 31	File 41	File 51	File 61	File 71
File 2	File 12	File 22	File 32	File 42	File 52	File 62	File 72
File 3	File 13	File 23	File 33	File 43	File 53	File 63	File 73
File 4	File 14	File 24	File 34	File 44	File 54	File 64
File 5	File 15	File 25	File 35	File 45	File 55	File 65
File 6	File 16	File 26	File 36	File 46	File 56	File 66
File 7	File 17	File 27	File 37	File 47	File 57	File 67
File 8	File 18	File 28	File 38	File 48	File 58	File 68
File 9	File 19	File 29	File 39	File 49	File 59	File 69
File 10	File 20	File 30	File 40	File 50	File 60	File 70

Step 2: Ensure you have your hard copy Student Notes for the applicable Chapter.

Step 3: Work through the Chapter and when you have completed the lesson and exercises, come back to this page.

Step 4: Access the Test for the applicable Chapter via the link below (Eg. OSSAT01) and save the Test to your personal computer.

Chapter Title	Test Banks
Chapter 1 - Getting to Know Excel	OSSAT01
Chapter 2 - Creating a New Workbook	OSSAT02
Chapter 3 - Selecting Ranges	OSSAT03
Chapter 4 - Formulas and Functions	OSSAT04
Chapter 5 - Editing in a Workbook	OSSAT05
Chapter 6 - Copying Excel Data	OSSAT06
Chapter 7 - Formula Referencing	OSSAT07
Chapter 8 - Font Formatting	OSSAT08
Chapter 9 - Cell Alignment	OSSAT09
Chapter 10 - Number Formatting	OSSAT10
Chapter 11 - Working With a Spreadsheet	OSSAT11
Chapter 12 - Saving Workbooks	OSSAT12
Chapter 13 - Sorting Data	OSSAT13
Chapter 14 - Printing	OSSAT14
Chapter 15 - Page Setup	OSSAT15
Chapter 16 - Creating Charts	OSSAT16
Chapter 17 - Common Chart Types	OSSAT17

Step 5: Open the Test on your personal computer and enter your name in the box provided. Complete your answers and save the document.

Step 6: Click on this email link mvcc@mvcc.org.au to forward your Test Answer Sheet as an attachment - don't forget to attach your saved file! Please ensure that you enter a subject heading in the email (Eg. Office 2007 - Operate a Spreadsheet Application Test 01). We will provide you with feedback upon receipt of each Test and will mail the Student Notes for the next Chapter to you.

On completion: We constantly strive to ensure that our training is of the highest possible standard. As such, we need your help. Please complete our online Student Evaluation, which will take approximately 3 minutes. Thank you. Your feedback is greatly appreciated.