New Clait 2006 Unit 2 Creating Spreadsheets and Graphs Using Excel XPThis self teach guide has been designed to gradually steer you in a step by step manner around the software features needed to pass New CLAIT 2006 Unit 2 assessment. As you work through this book you are introduced to, and taught how to use, Microsoft Excel. Data files are supplied on CD and have been designed to be used in conjunction with the exercises as you work through the book. Titles of a similar nature are also available for the other New CLAIT 2006 units. Endorsed by OCR. |
Contents
FUNDAMENTALS | 8 |
1 SPREADSHEET PRINCIPLES | 9 |
2STARTING THE PROGRAM | 10 |
3THE LAYOUT OF THE EXCEL SCREEN | 11 |
4 THE MENU BAR | 12 |
5TOOLBARS | 14 |
6 THE WORKSHEET WINDOW | 16 |
7CLOSING EXCEL | 17 |
20SAVING A NEW WORKBOOK | 31 |
21 REVISION | 32 |
23 REVISION | 33 |
FORMULAS | 34 |
24INTRODUCING FORMULAS | 35 |
25MATHEMATICAL OPERATORS | 36 |
26 BRACKETS | 37 |
27SELECTING CELLS WITH THE MOUSE | 38 |
OPEN SAVE AND CLOSE WORKBOOKS | 18 |
9 OPENING A WORKBOOK | 19 |
10MOVING AROUND USING THE KEYBOARD | 20 |
11 CLOSING A WORKBOOK | 21 |
12SAVING A NAMED WORKBOOK | 22 |
13 REVISION | 24 |
CREATING A WORKSHEET | 25 |
15 SPREADSHEET STRUCTURE | 26 |
16 CREATING A SPREADSHEET | 27 |
17 STARTING A NEW WORKBOOK | 28 |
18ENTERING LABELS | 29 |
19 ENTERING NUMBERS | 30 |
28 AUTOSUM | 39 |
29 AVERAGE FUNCTION | 40 |
30USING THE FILL HANDLE TO COPY | 41 |
COPYING FORMULAS | 42 |
32 RELATIVE ADDRESSING | 44 |
33REVISION | 45 |
EDITING CELLS | 46 |
35OVERTYPING | 47 |
36DELETING CELL CONTENTS | 48 |
37IN CELL EDITING | 49 |
39 REVISION | 50 |
Other editions - View all
New Clait 2006 Unit 2 Creating Spreadsheets and Graphs Using Excel 2003 CIA Training Ltd Limited preview - 2005 |
Common terms and phrases
Actions active cell adjust cursor Alignment Answer Section Arial Audiences automatically AutoSum axis Border calculations Category cell A1 cell B7 cell contents Cell Reference changes Chart title Chart type Charts Guidelines Click and drag Click OK Click on cell Close the workbook Column Chart column width continued over Exercise Data Labels Data Window Help decimal places default Delete dialog box Double click Edit View Insert embedded chart Fill Handle Format Cells Format Number Format Tools Data Formula Bar Fred Bloggs Highlight Leave the workbook Legend line graph Manchester Menu Bar Microsoft Excel mouse pointer Move Note Number Sold OK Cancel Open the workbook Overtype Pie Chart press Enter Print Preview Rainfall Renault 9 resized Revision Save the workbook Select cell Select File select Format Setup sheet tab Smart Tag spreadsheet Step toolbar Tools Data Window ToolTip Total Value View Insert Format Widgets workbook open workbook without saving worksheet