VOCAB
Section of spreadsheet where you enter data and formulas
Formula Bar
What is the operator symbol (mathematical function) for in this formula? =E5*A2
Multiplying or Multiplication
An absolute reference is designated in the formula by using what symbol?
$
Place where you can rename each worksheet. Located at the bottom of the worksheet window.
Sheet Tab or just TAB
When you Double-click between two columns it will ____________ the column.
resize
A group of selected cells is called a
Range
All formulas in a spreadsheet must start with this:
=
Which of the following formulas includes an absolute cell reference?
CHOICE 1 =B1/$B$25
CHOICE 2 =B1/B25
CHOICE 3 =B1*#B#25
CHOICE 4=AVERAGE(B1:B25)
Choice 1
Putting cells in order based on their contents is called..
Sorting
If you want to subtract data in cell C1 from cell B1 how would the formula be written?
=B1-C1
(must include = and be in correct order)
Each box on a spreadsheet is called a ...
cell
What is the correct function to calculate a total budget listed in several cells?
CHOICE 1 =AVERAGE(B3:B6)
CHOICE 2 =SUM(B3:B6)
CHOICE 3 =SUM(B3-B6)
CHOICE 4=TOTAL(B3:B6)
CHOICE 2
The formula that ALWAYS multiplies the contents of cell B4 by what ever is in Row 4
Choice 1 C4*B4
Choice 2 =A4*$B$4
Choice 3 =J4*$B4
Choice 4=F4*B4
CHOICE 2
$b$17 is what type of reference?
Absolute
Which of these formulas uses relative cell references?
CHOICE 1 =5*10+20
CHOICE 2 =$A$10/100
CHOICE 3=F18+F19/2
CHOICE 4= A10/$A5
CHOICE 3
_________ references do not change when copied or filled.
ABSOLUTE REFERENCES
Choose the correct formula for adding up a list of numbers in the same column.
CHOICE 1 =Sum(E2:E7)
CHOICE 2 =Sum(C2:E7)
CHOICE 3 =Sum(E2:C7)
CHOICE 4 =Sum(De Dum De Dum)
CHOICE 1
By default, all cell references are _______ references
Relative
This operator symbol is for what type of operation? /
Division
Which of the following has a cell reference?
CHOICE 1 =5%
CHOICE 2 =4*3.7
CHOICE 3=G4/E3
CHOICE 4=SUM
CHOICE 3
Select ___________________ from the functions menu to find the smallest value in a group.
MIN
a drop down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to the data in your worksheet.
Function
When copying cell formulas using the ____ ______ the formula will be copied to the selected cells with an absolute or relative reference, and the values will be calculated in each cell.
fill handle
Select ______________ from the functions drop-down menu to determine how many cells are filled with data.
COUNT
a feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
Auto fill