Performs a calcualtion that results in a single value
What is a function?
100
The vertical and horizontal parts of the worksheet grid lines
What are columns and rows?
100
If the formula =SUM(C3:C22) is entered into cell C24, and then a row is inserted directly above row 20, this must be done to include the new cell in the sum
What is change "C22" to "C23"?
100
The formula calculates the maximum value stored in the range of cells D4 through Y5
What is "=MAX(D4:Y5)"?
100
It is important to check the range placed in the SUM function when using Formulas, AutoSum for this reason
What is because Excel guesses the range?
200
This function is used to add the cells B4, B5, B6, and B7 together
What is the "+" or addition?
200
The absolute cell reference doesn't change when it's copied, but this does
What is a relative cell reference?
200
If the formula =SUM(C3:C22) is entered into cell C24, and then a row is inserted above row 24, then this must be done to include the new cell in the sum
What is enter "=SUM(C3:C22, C24)"?
200
This formula calculates the minimum value stored in the range of cells C1 through C9
What is "=MIN(C1:C9)"?
200
These are two common error values
What is #DIV/0!, and #####?
300
These are two advantages to using the Insert Function dialog box to insert the name of a function in a formula instead of typing the formula
What are to find the functions quicker, and to avoid typing mistakes?
300
Go to Home, Insert and Insert Sheet Rows or Insert Sheet Columns to do this
What is insert rows or columns?
300
If the formula =SUM(C3:C22) is entered into cell C24, and then row 20 is deleted, then this is done so the deleted cell is no longer in the range
What is enter "=SUM(C3:C21)"?
300
This is a formula in that multiplies the value in cell F5 with the value of B1 so that when the formula is copied, the cell reference to B1 remains constant
What is "=$B$1*F5"?
300
These are two common formula errors
What are "Formula Omits Adjacent Cells" and "Inconsistant Formula in Region"?
400
This is required by a function to perform a calculation
What is an equal sign?
400
The formatting of new, inserted rows or columns is this to the cells above or to the left of them
What is the same?
400
This formula calculates the average of the values stored in the column of cells D7 through D35
What is "=AVERAGE(D7:D35)"?
400
Mrs. Cross has this many kids
What is four?
400
This is the way to remove the green triangle from a cell that displays a result and the formula does not contain an error
What is click Error Checking and Ignore Error?
500
This formula calculates the sum of the values stored in cells B4, C4, D4 and E4
What is "=SUM(B4, C4, D4, E4)"?
500
When Home, Delete, Delete Sheet Rows is selected, after clicking row 8, this happens
What is row 8 is deleted?
500
This formula calculates the average of the values stored in the row of cells F3 through J3
What is "=AVERAGE(F3:J3)"?
500
Mrs. Cross likes these students best
Who are Justin, Nicole and Laura?
500
Mrs. Cross enjoys taking these away from students.