Topics for the final exam

The final exam will cover the following topics: Words, Excel and Powerpoint.

Here are the detailed list of items:

Word

1. Create a new file, open, save. Page setup. Printing.
2. Basic edition: cut, copy, paste, paste special (unformatted text).
3. Find (including advanced find: match case, etc). Wildcards (only * and ?). Replace.
4. Layouts: normal, web, view, outline. Toolbars (showing and hiding them, how to add buttons to a toolbar).
5. Header and footer. Inserting page number, page count, today date, etc.
6. Breaks: page breaks, section breaks, column breaks.
7. Autotext. What it is, how to use it.
8. Drawing arrows, squares, lines.
9. Formatting text: fonts, paragraph formatting.
10. Bullets, numbering. Different levels of bullets.
11. Columns, tabs (different types of tabs, how they are used). Indentation.
12. Spellchecking, tracking changes.
13. Mail merge: creating a data source, inserting fields from the data source, creating letters and envelopes.
14. Macros: how to record and run a macro.
15. Tables: creating a table, formatting tables, splitting cells, text orientation in cells, borders, colors.
16. Microsoft equation editor. Creating and editting an equation.


Excel

1. Creating, opening and saving a spreadsheet. Page setup, printing.
2. Find and replace (including all wildcards).
3. Grouping and ungrouping worksheets. Copying a worksheet, inserting a blank worksheet.
4. Absolute, relative and mixed cell references. What they are, how to use them.
5. Editing a worksheet: inserting, moving, deleting cells, rows and columns. Formatting (colors, borders, orientation, row height, column width, etc).
6. Formatting text, numbers, etc. Custom formats. Conditional formatting.
7. Summations, formulas. Naming columns and rows and using those names in formulas. Autofill.
8. Charts. Creating, formatting a chart, adding new data, removing data. Editing a chart.
9. Autofilters. Custom filters.
10. Macros.
11. Sorting. Subtotals. Pivot tables.

Powerpoint

1. Opening, creating and saving a presentation. Pack and go (how does it work?)
2. Slide layout, slide design, slide backgrounds.
3. Slide masters, how they are used, adding logos, etcetera.
4. Inserting objects. Clip art. Audio, video, pictures, from files and from the clip art. Importing to the clip art. Inserting charts and tables. Organizational charts.
5. Transitions, different types, how to set up an automatic and manual transition.
6. Animation, different types. Custom animations. Animating different parts of the slide.

Study hard!