Heinemann Learning to Pass Advanced ECDL AM4 Spreadsheets Using Office 2003Covers the information students need to pass the Advanced ECDL AM4 Spreadsheets qualification using Microsoft Office 2003. |
Contents
Display Tasks | 48 |
DATA HANDLING | 83 |
3 | 101 |
Linking Tasks | 119 |
Templates Tasks | 145 |
ANALYSIS | 258 |
3 | 264 |
Auditing Tasks | 274 |
Macros Tasks | 286 |
Common terms and phrases
accompanying CD-ROM AutoFormat Axis calculation cell A1 cell C4 cell reference Click cell Click OK close the workbook contains contents of cell create Custom Lists Data Form data in cells data labels data marker data series data table decimal places default Delete display Edit Enter the following Enter the label EXERCISE Method Font Format Cells formula bar Function Arguments function in cell function syntax Function Wizard Highlight cells Hyperlink Info Method Insert Function window keyboard located macro Microsoft Excel Microsoft Office Excel mouse name box named range nested function number formats OK Cancel Figure OK to apply OK to close Open the workbook option button password pie chart pivot table PivotTable pop-up menu Right click Save and close Save and review Save the workbook Scenario Select cell Sheet spreadsheet subtotal SUM function template text box text file toolbar button VLOOKUP word processing worksheet