Excel Review Skills for Final Test

NOTE: You are NOT required to create macros on the final test.

Formulas

         Know how to use the basic operators: + - * / ^.

         Know the precedence rules for evaluating a formula.

         Know how to use absolute ($) and relative cell references.

         Know how to use the fill handle to copy formulas.

         Know how to use 3D formulas to reference cells on other worksheets.

Formatting

         Know how to use all of the formatting options listed below:

Charts (Insert tab)

         Be able to create and modify line charts, pie charts, bar charts, and column charts. Be sure you can create a line chart that has numbers on the x-axis.

Database Skills (Data tab)

         Know how sort (on more than one column), auto-filter, and advanced filter. Know how to create a pivot table or pivot chart (Insert tab).

Functions (Formulas tab)

Basic arithmetic

         Sum

         Min

         Max

         Average

         Count

 

Financial

         FV

         PMT

         PV

Logical

         IF

         And

         Or

         VLookup

Date/Time

         Today

         Now

         Year

         Month

         Day

         Date

         Weekday

         DateDif

Database

         DSum

         DMin

         DMax

         DAverage

         DCount

         DCountA

Page Layout

         Be able to set column widths and row heights.

         Set margins

         Set page orientation

         Scale printout

         Turn gridlines on/off

         Add headers and footers with dates and page numbers