-
Normal
Page Layout
Page Setup
Review
SUM and AVERAGE
MAX and AVERAGE
LABEL and AVERAGE
MIN and BLANK
B1
$B$1
$B1
AB1
It includes column and row references.
It adjusts to its location on the worksheet.
It refers to an existing cell on the worksheet.
It resets to its original value.
Custom
Date
Special
Text
It adds the values in cells D7:D14 if the value is greater than 1.
It adds all the negative values in cells D7:D14.
If the value in a cell is greater than 1, it is added to the other values in column D.
If the value in a cell is greater than 1, the range D7:D14 is placed on a summary sheet.
FV
PV
Nper
Rate
3.45
3.46
3.457
3.4567
1, 3, 5, 7
7, 5, 3, 1
Tom, John, Adam
May 1, 2007; April 1, 2007; March 1, 2007
Financial
Database
Lookup and Reference
Logical
They are easier to remember than cell addresses.
They can be used for navigation.
They automatically substitute the relevant cell addresses.
They make formulas easier to understand.
Solver scenario
Visual Basic scenario
Visual Basic routine
Solver routine
They allow you to add dynamic data.
They allow you to rearrange row and column data.
They allow you to generate e-mail enabled reports.
They allow you to print the reports with various settings.
Wait!
Here's an interesting quiz for you.