Fun with Formulas
Dysfunctional
Calculating with
Style
FoRmAtS
Potpourri
100
An expression that returns a value.
What is a formula?
100
Built-in formula.
What is a function?
100
Color inside a cell.
What is Fill Color?
100
Dialog to display cells as currency.
What is Format Cells?
100
Navigate to the upper left corner of a sheet.
What is Ctrl + Home?
200
Multiply before add
What is operator precedence?
200
A function to add a range of cells.
What is SUM()?
200
Page Layout -> Page Setup -> Background
What is Set Background Image?
200
Copy cell color or border or font with a single click.
What is Format Painter?
200
A1:B4
What is a cell range?
300
Pointer to a cell that includes a "$"
What is an absolute cell reference?
300
Join several text strings into one text string.
What is Concatenation Function?
300
Includes sortable columns.
What is Format as Table?
300
Set cell background depending on rules about value.
What is Conditional Formatting?
300
Enter a line break into the text of a cell.
What is Alt + Enter?
400
Type of cell reference used when autofilling a formula.
What is relative cell reference?
400
Logical function that includes a test, a true value, and a false value.
What is the IF() Function?
400
Multiple adjacent cells shown as one cell.
What are Merged Cells?
400
Width of color background indicates relative value of cell.
What are Data Bars?
400
Visual representation of data inside a circle.
What is a Pie Chart?
500
Operator that can change precedence.
What is parenthesis?
500
Function to calculate loan payments.
What is PMT()?
500
Method (not using a single button) to copy cell format.
What is Paste Special?
500
Set Arabic format date.
What is Format Cells -> Date -> Locale?
500
Includes a series name and series values.
What is a data series for a chart?
M
e
n
u