EXCEL Objectives - - Revised 2009-11-03

 

Students should be able to :

Open EXCEL
Enter LABELS, VALUES, and FORMULAS
ADD, SUBTRACT and MULTIPLY cells together using simple calculations (+ - * /)
Use FORMULAS including AVERAGE, SUM, MIN and MAX


Print the spreadsheet 

using CONTROL TILDA
using LANDSCAPE
using GRIDLINES


Save the spreadsheet to various locations ( including external drives)
Change the color of the font
Change the color of the background
Widen the column width
Highlight an entire column or row
Create a pie chart
Adjust the size of the font

Create borders around cells

Use all features of PAGE SETUP

Sorting ( one column and multiple )

Copy an EXCEL spreadsheet into WORD and POWERPOINT.

Utilize SHEET 1 and SHEET 2 – copy and paste between the two.

Use Data / Data validation in a cell.