Test 3 Review – Excel

20 tasks – NOTE when tasks say hit enter, click the check mark in the formula bar instead

AutoSum

Bold

Border

Center

Center text across

Change page orientation

Change shading

Change text color

Change width of column

Create a chart

Delete rows

Delete worksheet

Enter formula

Format cells

Hide column

Indent cell contents

Put text on multiple lines

Rotate cell contents

30 multiple choice and true false

Absolute & relative cell addressing

AutoFill

Chart types & their uses

Conditional formatting

Date

Definition of a spreadsheet, cell, range

Embedded charts

Exploded pie

Fill handles

Formulas

Function & function arguments

IF function

Legends

Move to cell A1

Number formats

Print titles

Serif/san serif fonts

Why use charts