Worksheet Functions
To add numbers
The SUM function
To create a new workbook
Ctrl+N
Assume cell A1, lock the column reference for horizontal copy
$A1
Return largest value
The MAX function
To undo an action
Ctrl+Z
$A$1 is what type of cell reference
Absolute cell reference
Conditionally total values
SUMIF function
Go to a specific cell
F5
A1 is what type of cell reference
Relative cell reference
Counts cells with numbers only
COUNT function
Move to beginning of worksheet
Ctrl+Home
A$1 is what type of cell reference
Mixed cell reference with absolute row
Counts cells containing any type of information
COUNTA function
Edit a cell
F2
$A1 is what type of cell reference
Mixed cell reference with absolutecolumn