TCO 2) In Excel, a relative cell reference:
indicates a cell’s specific location and the
reference does not change when you copy the formula.
contains both an absolute and a relative cell
reference.
indicates a cell’s relative location from the
cell containing the formula; the reference changes when you copy the formula.
occurs when a formula directly or indirectly
refers to the cell containing the formula.
:
Question 2. Question
:
(TCO 2) In Excel, a function can be defined as a _____.
predefined formula that performs a calculation
cell reference or a value
list of values and defined names as you enter
data into a spreadsheet
set of rules that govern the structure and
components for a formula
Question 3. Question
:
(TCO 2) The rules for constructing a function can be
referred to as the function’s _____.
synthesis
synergy
synchronization
syntax
Question 4. Question
:
(TCO 2) Which of the following describes the SUM function?
Identifies the midpoint value in a set of
values.
Calculates the total of values contained in
two or more cells.
Calculates the arithmetic mean or average of
values in a range.
Displays the lowest value in a range.
Question 5. Question
:
(TCO 2) The _____ function returns a result based on a
condition.
Student Answer: MAX
TODAY
FIND
IF
Question 6. Question
:
(TCO 2) Which of the following best describes the COUNT
function?
Tallies the number of cells in a range that
are not empty.
Tallies the number of blank cells in a range.
Displays the current date.
Tallies the number of cells in a range that
contain values.
Question 7. Question
:
(TCO 2) In the arguments to an IF function, the condition
that is evaluated to determine if it is true or false is also sometimes called
a _____.
logical test
lookup value
breakpoint
table array action
Question 8. Question
:
(TCO 2) If you enter an = and the first few letters of a
function in the formula bar, Excel will display a drop-down list of functions
beginning with those letters. This feature is called _____.
Syntax Helper
Formula AutoComplete
Formula Wizard
:
Question 9. Question
:
(TCO 2) Which of the following best describes the HLOOKUP
function?
The periodic interest rate, such as a monthly
interest rate.
Calculates the periodic payment for a loan
with a fixed interest rate and fixed term.
Looks up a value in a lookup table where the
first column contains the values to compare with the lookup value.
Looks up a value in a lookup table in which
the first row contains the values to compare with the lookup value.
Question 10. Question
:
(TCO 2) One benefit of using range names in formulas is that
_____ .
it directly or indirectly refers to the cell
containing the formula
it contains both an absolute and a relative
cell reference
it identifies the present value of the loan
if you copy the formula, you do not have to
make the cell reference absolute
Question 11. Question
:
(TCO 2) The PMT function is best described by which of the
following?
It is the periodic interest rate, such as a
monthly interest rate.
It is the total number of payment periods.
It is the present value of a loan.
It calculates the periodic payment for a loan
with a fixed interest rate and a fixed term.
:
Question 12. Question
:
(TCO 7) Which of the following is NOT an Excel tool used to
improve productivity in developing consistently formatted workbooks?
Macros
Templates
Themes
INCORRECT Background
Question 13. Question
:
(TCO 7) Before protecting a worksheet, you should _____ the
cells that you want users to be able to edit.
format
hide
lock
unlock
:
Question 14. Question
:
(TCO 7) Which of the following file formats can store
macros?
xlsm
csv
xml
xlsx
Question 15. Question
:
(TCO 7) To create a macro button, click the _____ tab, click
Insert, then click Button in the Form Controls section of the Insert palette.
View
Data
Insert
Developer
