Show:
Odds and Ends
Functions
Cell References
100
A collection of rows and columns that can be used in calculations.
What is a spreadsheet?
100
All functions and formulas begin with this character.
What is the Equal sign?
100
The default cell reference for excel.
What is a Relative Cell Reference?
200
Predefined formatting for cells
What is a Cell Style?
200
This function is used to find the total of a range of numbers.
What is the SUM function?
200
This cell reference has one dollar sign.
What is a Mixed Cell Reference?
300
This keyboard shortcut splits text across multiple lines in one cell.
What is Alt + Enter?
300
This function is used to find the lowest number in a range of numbers.
What is the MIN function?
300
This key (on the keyboard) toggles between the different cell references.
What is the F4 key?
400
This button allows you to select non-adjacent columns.
What is Ctrl?
400
This function sets a value based on a condition.
What is the IF function?
400
The ________ will change in this cell reference $G7.
What is the Row?
500
This feature allows excel to change the format of a range based on a specific criteria.
What is Conditional Formatting?
500
This function is good for calculating the monthly payment of a loan.
What is the PMT function?
500
The formula $A10 * B$10 will say this if it is copied into the next column
What is $A10 * C$10?