Basics
An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
What is a spreadsheet?
Used to add identifying information to a spreadsheet, including page number, title of company, date, etc.
What are headers and footers?
This is the symbol that instructs the spreadsheet software to perform a calculation
What is an equal sign?
This is a shortcut for a formula
What is a function?
This symbol is keyed before a number to indicate that it is a label, not a value
What is an apostrophe?
A file that contains one or more spreadsheets
What is a workbook?
These are the three main types of justification
What are left, right, and center?
This classification is used for numbers that may be used in calculations
What are values?
This function adds a range of cells
What is SUM?
This formatting feature is used to combine two or more cells
An individual location in a spreadsheet- the intersection of a column and row
What is a cell?
This is the default justification for labels
What is left?
What is a colon?
When ##### appears in a cell, it indicates this error
What is too small of a column width?
How we identity a cell, by the column letter and row number
What is a cell reference, or cell address?
This is the default justification for values
What is right?
Calculations are performed according to what?
What is the order of operations, or PEMDAS?
These are used to clarify the order of operations when there are multiple calculations in a numerator or denominator of a formula
What are parentheses?
Write the following function- Add A1 to the highest value in the cell range B1:B10.
=A1+MAX(B1:B10)
A cell that is ready to receive information
What is an active cell?
This feature is used to align multi-line text within a cell
What is wrap-text?
What is a fill series?
Write the following formula- Multiply A6 by the sum of the range of cells B1:B10, then divide by C6.
What is =(A6*SUM(B1:B10))/C6
Write the following formula- Subtract B2 from the minimum value of the cell range A2:A12, then divide by C2
What is =(MIN(A2:A12)-B2)/C2