Modified 28 January 2007
Syllabus ExcelTests will assess 60% of the Advanced features. Exams will assess 40% of the Advanced features
| Basic | Advanced |
| Page setup: margins, portrait/landscape, paper size, fit to page(s)/adjust to x% of normal size, page order | Data validation |
| File manipulation: Create, open, save, save as, close, export, import, rename, backup, delete, insert | Importing and Exporting data |
| Printing: Set print area | Consolidating multisheet data |
| Editing: copy, cut, paste, paste special, fill, clear, delete, delete sheets, find and replace | Pivot tables: Building/Creating, Deleting/adding fields, Formatting |
| Formatting Cells: Numbers, text, currency, date, time, percentage. etc. | Embedding objects (copy and paste) |
| Formatting Cells: Alignment (i.e. horizontal, vertical, text wrap, shrink to fit, merge cells) | Exchanging data with window applications and integration with word processing and databases. |
| Formatting text (fonts, size, bold, underline, italics, super and subscript) | Importing and exporting data |
| Borders and patterns | Styles |
| Protection of cells, worksheets and workbooks | Templates (Creating, modifying and using) |
| Formatting rows and columns: Insert/delete, with/height, freeze panes, hide/unhide | |
| Worksheets: Formatting, Add/delete, Multiple worksheets, Linking worksheets | |
| Conditional formatting | |
| Cell references: relative and absolute | |
| Ranges: Naming, selection, use in formulae | |
| Sorting data | |
| Formulae: Arithmetic, comparison, copy and move | |
| Mathematical Functions: Abs, Int, Floor, Ceiling, Mod, Sum | Lookup Functions: Vlookup and Hlookup |
| Statistical Functions: Average, Count, Frequency, Max, Min, Mode | Text manipulation: Left, Mid, Right, Concatenate |
| Logical Functions: And, Or, Not, If (with one variable only) True, False | Nested if’s |
| Charts: Different types | |
| Formatting charts: gridlines, axes, data markers, plot area and background, legends | |
| Headers and footers | |
| Automatic page numbers | |
| Comments | |
Return to Computer Applications Technology or Computer Studies lesson plan index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.