Functions
The result of this function
=A1 + B1
What is the sum of A1 and B1?
Used to summarize and analyze large data sets.
What is a pivot table?
Wrapping text has this effect.
What is prevents text from going outside of a cell?
The functionality of =SUM().
What is adds together a range of cells?
The items that you click and drag into the zones of Rows, Columns, and Values.
What are fields?
The keyboard shortcut to group cells:
A) Shift + F2
B) Ctrl + F2
C) Alt + F4
What is A) Shift + F2?
The function I should use to find the largest number in a data set.
What is the MAX() function?
The zones used for the fields that you want to calculate.
What is a value?
Pressing Alt ⇢ W ⇢ F ⇢ R does this.
What is freezes the top row?
The difference between the Average() function and the Count() function.
What is the Average() function calculates mean and the Count() function counts the number of cells that contain numbers?
The field of Sum of Written Exposures and Total Sums.
What is a column?
To “transpose” means this.
What is flipping the columns and rows?