Office Applications II Unit 2 Quiz 3
=
Formulas begin with the ___ symbol. & ! = @
order of operations
Formulas should follow the __________________________________________________________________________. signs order of operations last cell used call of operations
False
In a formula, addition is calculated before multiplication. True False
relative
In the formula =C5*$B$3, C5 is what type of cell reference? relative absolute mixed obscure
cell references
Instead of using numbers in formulas, use _______________________________________________________. cell references cell connections formula bars characters
TRUE FALSE
Select all that apply. What two values do comparison operators return? TRUE EQUAL LESS THAN FALSE
.07
The actual value of 7 percent is _____. .007 .07 .7 7
Ctrl+`
The keyboard shortcut to display formulas in worksheets is ____________. Ctrl+" Ctrl+` Ctrl+˜ Ctrl+F
Show Formulas
To display formulas in a worksheet, use the ______________________________________________ tool. Display Formulas Show Formulas Formulas On Name Formulas
Define Name
To name a range, right-click on selected cells and choose __________________________________________________________________. Define Name Make Name Name Range Create Name
Name Box
Use the __________________________ to navigate to a named range. Name Box status bar Formula Bar title bar
16
What is the answer to the formula 8+6/2+5? 16 13 12 2
TRUE
What is the correct answer to the formula 10<>12? TRUE NOT EQUAL LESS THAN FALSE
FALSE
What is the correct answer to the formula 10=12? TRUE EQUAL LESS THAN FALSE
F4
What is the shortcut key to make a cell reference in a formula absolute? F1 F2 F4 Ctrl-F4
/
What symbol is used in Excel formulas to calculate division? + - * /
^
What symbol is used in Excel formulas to calculate exponentiation? ^ @ * /
*
What symbol is used in Excel formulas to calculate multiplication? + - * /
changed
When formulas are copied, the relative cell references are automatically _______________________. relocated moved changed recalculated
recalculated
When numbers are changed in cells that are involved in formulas, the formulas are automatically _________________________________. removed changed recalculated highlighted
Formula Bar
Where do you look on the Excel screen to see the formula in a cell? Name Box Formula Bar status bar title bar
$C1
Which one of the following is a mixed cell reference? $C$1 $C1 C1 $D12$
Formulas
___________________ are used in the Excel application to create calculations. Equations Calculations Formulas Additions
Relative
______________________ cell references change when copied using the fill handle. Relative Absolute Mixed Obscure
Absolute
______________________ cell references do not change when copied. Relative Absolute Mixed Obscure
range
a group of cells that are next to each other (adjacent) and form a rectangular shape
mixed cell reference
cell references in a formula where either just the column letter is absolute or just the row number is absolute
relative cell references
cell references that are relative to the location of the cell where the formula is entered and that change when copied
absolute cell references
cell references that contain the dollar sign symbol ($)in formulas and do not change when copied
Show Formulas
command used to display all of the formulas directly in a worksheet
Name Manager
notes that can be attached to cells to add additional information that is not printed on the worksheet
order of operations
order in which calculations are performed in a formula
operators
symbols used in formulas to indicate the types of calculations to be performed
formulas
used in the Excel application to create calculations and usually contain cell addresses
comparison operators
used to compare two values and return (display) the value of either TRUE or FALSE
named range
used to give a range of cells a name
arithmetic operators
used to perform mathematical calculations
