Setup
Modify and Formulas
Formulas
Terms
Finding Values
100
Click Home > Insert > Insert Sheet Column
How do you insert a column?
100
Home > Delete > Delete Sheet Rows
What is the steps to delete a row?
100
=(A1+B1)
What is the way to add the values in cell A1 and B1?
100
Performs a calculation that results in a single value
What is a function?
100
=sum(B4:B7)
What is the sum of the values stored in cells B4, B5, B6, and B7?
200
Same as the cell above and to the left of them
What is the format in a newly inserted row?
200
Go to the formula bar and change the information in a cell
What is the way to alter data in the selected cell?
200
=A1+((($B$1)))
How is a cell referenced in a formula so when it is copied the value always remains the same?
200
data is needed for this
What is required for a function to perform a calculation?
200
=sum(B4:E4)
What is the sum of the values stored in cells B4, C4,D6, and E7?
300
Same as the cell above and to the left of them
What is the format in a newly inserted column?
300
#DIV/0 and #REF
What is two common error Values?
300
=(A1-B1)
What is the way to subtract the value in B1 from the value in A1?
300
An absolute cell reference can not be change and a relative cell reference can be changed
What is the difference between a relative cell reference and an absolute cell reference?
300
=Average(D7:D35)
What is the average of the values stored in cells D7 through D35?
400
Click Home > Insert > Insert Sheet Row
What is the way to insert a new row
400
=ROUND(AVERAGE(A1:B3),1)
What is used to round the average if the cells to one decimal place?
400
A formula referencing itself, and trying to divide by zero
What is two common formula errors?
400
Helps stop any typos from occurring when typing a formula
What is reason to use the Insert Function dialog box instead of typing it in yourself?
400
=Average(F3:J3)
What is the average of the values stored in cells F3 through J3?
500
In the formula =SUM(C3:C22) a row is inserted about row 20, this is done in order to include the new cells value to the sum
What is nothing?
500
Home > Paint > Select cell
What is the way to copy a format in one cell to another?
500
=ROUND(SUM(C5:C9),1)
What is rounding the sum to one decimal place?
500
Done to insure the correct data is being used when finding sum
What is the checking of the range in Formula > AutoSum?
500
=MAX(D4:Y5)
what is the maximum value stored int he range of cells D4 through Y5?
M
e
n
u