OFFICE 2003 - OPERATE A SPREADSHEET APPLICATION

This course covers the following chapters: Excel 2003 orientation; a simple workbook; selecting ranges; formulas; working with functions; editing data; copying and filling; absolute referencing; formatting cells; adjusting a worksheet; working with workbooks; sorting; printing; printing techniques; and charting.

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 2003 - 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. 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 applicable folder. Do not change the file name, so that you can locate the correct file when your workbook instructs you to open it.

PRACTICE FILES
0001	0013	0025	0037	0049	0061	0073	0085
0002	0014	0026	0038	0050	0062	0074	0086
0003	0015	0027	0039	0051	0063	0075	0087
0004	0016	0028	0040	0052	0064	0076	0088
0005	0017	0029	0041	0053	0065	0077	0089
0006	0018	0030	0042	0054	0066	0078	0090
0007	0019	0031	0043	0055	0067	0079	0091
0008	0020	0032	0044	0056	0068	0080
0009	0021	0033	0045	0057	0069	0081
0010	0022	0034	0046	0058	0070	0082
0011	0023	0035	0047	0059	0071	0083
0012	0024	0036	0048	0060	0072	0084

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. OSSA03-01) and save the Test to your personal computer.

Chapter Title	Test Bank
Chapter 1 - Excel Orientation	OSSA03-01
Chapter 2 - A Simple Workbook	OSSA03-02
Chapter 3 - Selecting Ranges	OSSA03-03
Chapter 4 - Formulas	OSSA03-04
Chapter 5 - Working With Functions	OSSA03-05
Chapter 6 - Editing Data	OSSA03-06
Chapter 7 - Copying And Filling	OSSA03-07
Chapter 8 - Absolute Referencing	OSSA03-08
Chapter 9 - Formatting Cells	OSSA03-09
Chapter 10 - Adjusting A Worksheet	OSSA03-10
Chapter 11 - Working With Workbooks	OSSA03-11
Chapter 12 - Sorting	OSSA03-12
Chapter 13 - Printing	OSSA03-13
Chapter 14 - Printing Techniques	OSSA03-14
Chapter 15 - Charting	OSSA03-15

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 2003 - Operate a Spreadsheet Application - Test OSSA03-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.