Functions
Autosum
The function to calculate the total
What is the today() function?
Returns the system date
Merge & Center
Heading centered the rows to form ONE block
Average
What function calculates Mean?
Now() function
What function returns the system date and time?
Freeze columns
Headings are always visible when you scroll through many rows
Max
What function returns the largest value?
The PMT function
Returns the installment given the interest, rate and loan amount
What is absolute cell referencing?
Formulae contains dollar signs between rows and columns
Countif
What function counts the number of entries based on a criteria
If function
Returns one of two values depending on a criteria
Fill handle
What is an easy way of copying a formula
What function searches the first column in a table and returns another value in a table?
Rank function
Returns the position of an number according to where a numerical value stands in relation to other values
Displaying multiple sets of data using bars
What is a bar chart used for?