Excel Lessons
3 and 4
Excel Lessons
3 and 4
Excel Lessons
3 and 4
Excel Lessons
3 and 4
Excel Lessons
3 and 4
100
After you key a formula, you can _____ it down and across to other cells.
What is Fill?
100
A series of instructions that perform a calculation and displays an answer
What is Formula?
100
The symbol for exponentiation (raise to a power)
What is ^?
100
Copies data to adjacent cells; is especially good for copying formulas.
What is Fill?
100
In a formula where you want the cell reference to stay the same when it is copied or filled down and/or across, you should put a _____ in front of either the row number and/or column letter.
What is $?
200
The result given by the formula =12-3/3
What is 11?
200
Function that adds columns and rows
What is SUM?
200
To be able to see two parts of the spreadsheet at the ame time.
What is Split Screen?
200
The correct formula to add the rows 3, 4 and 5 of column C
What is =SUM(C3:C5)?
200
A mixed cell reference
What is $B4?
300
button used to enter a SUM formula
What is AUTOSUM?
300
Result given by the formula =15-3*4
What is 3?
300
Keeping the labels in the column headings to remain at the top as you scroll down the spreadsheet.
What is Freeze Titles?
300
An example of an absolute cell reference
What is $B$4?
300
Suppose you want to add the contents of columns A and B and then divide by the contents of cell B18. You want the rows to adjust for columns A and B as the formula is copied down. However, you want all the formulas to divide by B18.
What is =(A2 + B2)/$B$18?
400
The correct formula to add the cells C6, B4 and D18 is _______________.
What is =C6+B4+D18?
400
The answer to the following equation: =(12+4)/2
What is 8?
400
The mathematical operation given last priority in the order of precedence
What is Subtraction?
400
type of reference does not change when it is moved or copied
What is Absolute Reference?
400
An option that keeps certain rows at the top and certain columns at the left on the screen as the user scrolls down the spreadsheet and to the right
What is Freeze Titles?
500
The symbols, +, -, *, /, are examples of _____.
What is Operators?
500
The order in which the operators will be performed
What is PEMDAS?
500
To move data from one cell to another you can not do
What is Delete Cell?
500
Type of cell reference only changes the row or column when it is moved or copied to the new cell
What is Mixed Reference?
500
Symbols like *, +, -, and / that are used in formulas
What is Operators?
M
e
n
u