Test 1 Review

Study the following concepts:

PowerPoint
Title slide, slide layout, Normal View, Outline
View, Slide Sorter View, Notes pane, designing slides, 7×7 guideline, insert
picture, insert clip art, insert media clip, themes, backgrounds, templates,
transitions, tables, animations, header/footer, printing presentations, shapes,
SmartArt, hyperlinks, embedding, linking.

Excel Chapter 1
Worksheet, workbook, Name Box, Formula Bar, Sheet
tab, cell, cell address, active cell, formula, order of precedence, auto fill,
fill handle, displaying cell formulas, renaming worksheets, changing worksheet
tab color, inserting or deleting cells-rows-columns, column width, row height,
hide/unhide columns and rows, range, copy/paste, paste special, alignment, merge
and center, indenting, wrap text, borders, fill color, number formats, decimal
places, Page Setup commands, selecting ranges.

Excel Chapter 2
Semi-selection, relative cell reference, absolute
cell reference, mixed cell reference, circular reference, function, syntax,
argument, SUM function, AVERAGE function, MEDIAN function, MIN function, MAX
function, COUNT function, TODAY function, NOW function, IF function, VLOOKUP
function, PMT function, range name.Test 1 ReviewStudy the following concepts:PowerPointTitle slide, slide layout, Normal View, Outline
View, Slide Sorter View, Notes pane, designing slides, 7×7 guideline, insert
picture, insert clip art, insert media clip, themes, backgrounds, templates,
transitions, tables, animations, header/footer, printing presentations, shapes,
SmartArt, hyperlinks, embedding, linking.Excel Chapter 1Worksheet, workbook, Name Box, Formula Bar, Sheet
tab, cell, cell address, active cell, formula, order of precedence, auto fill,
fill handle, displaying cell formulas, renaming worksheets, changing worksheet
tab color, inserting or deleting cells-rows-columns, column width, row height,
hide/unhide columns and rows, range, copy/paste, paste special, alignment, merge
and center, indenting, wrap text, borders, fill color, number formats, decimal
places, Page Setup commands, selecting ranges.Excel Chapter 2Semi-selection, relative cell reference, absolute
cell reference, mixed cell reference, circular reference, function, syntax,
argument, SUM function, AVERAGE function, MEDIAN function, MIN function, MAX
function, COUNT function, TODAY function, NOW function, IF function, VLOOKUP
function, PMT function, range name.