BIS 155 WEEK 2 QUIZ EXCEL S ADVANCED FORMULAS &
FUNCTIONS
To Download tutorial
Copy and Paste below Link into your Browser
BIS 155 Week 2 Quiz
Excel s Advanced Formulas & Functions
Week 2 : Excel’s
Advanced Formulas & Functions – Quiz
Quiz
|
1. (TCO 2) An absolute cell reference: (Points : 2)
|
causes a potential error.
indicates a cell’s specific location and the reference does not change when
you copy the formula.
occurs when a formula directly or indirectly refers to the cell containing
the formula.
contains both an absolute and a relative cell reference.
|
|
2. (TCO 2) Which of the following best describes a
circular reference? (Points : 2)
|
Is a predefined formula that performs a calculation.
Is a rule that governs the structure and components for functions.
Occurs when a formula directly or indirectly refers to the cell containing
the formula.
Is an input such as a cell reference or a value needed to complete a
function.
|
|
3. (TCO 2) =$E2-G$4 contains examples of _____ cell
references. (Points : 2)
|
absolute
mixed
relative
constant
|
|
4. (TCO 2) In Excel, an Argument would be best described
by which of the following statements? (Points : 2)
|
Calculates the total of values contained in two or more
cells.
Displays a list of functions and defined names as you enter a function.
Is an input, such as a cell reference or a value needed to complete a
function.
Is a small pop-up description that displays the results of the cell.
|
|
5. (TCO 2) The MEDIAN function would identify the ____.
(Points : 2)
|
lowest value in a range.
midpoint value in a range.
highest value in a range.
total number of cells in a range.
|
|
6. (TCO 2) The MAX function identifies the _____. (Points
: 2)
|
highest value in a range.
number of blank cells in a range.
lowest value in a range.
midpoint value in a range.
|
|
7. (TCO 2) The NOW function would perform which of the
following? (Points : 2)
|
Contains another function embedded inside one or more of
its arguments.
Evaluates a condition and returns one value if the condition is true and a
different value if the condition is false.
Evaluates true or false.
Displays the current date and time.
|
|
8. (TCO 2) The _____ number is the number of the
column in the lookup table that contains the return values. (Points : 2)
|
lookup value
column index
lookup table
random
|
|
9. (TCO 2) Arithmetic operations, cell references,
and _____ can be used in Excel formulas. (Points : 2)
|
constants
macros
programs
procedures
|
|
10. (TCO 2) To simplify entering ranges in formulas, you
can use _____. (Points : 2)
|
range names
a cell’s relative location
both an absolute and a relative cell reference
a cell’s specific location
|
|
11. (TCO 2) When calculating a PMT function, the PV is
best described by which of the following? (Points : 2)
|
It is a set of range names.
It is a word or a string of characters that represent one or more cells.
It is the present value of the loan.
It is why you do not have to make the cell reference absolute in the
formula.
|
|
12. (TCO 7) A _____ helps to ensure consistency
and standardization for similar workbooks, such as detailed income
statements for all 12 months in a year. (Points : 2)
|
template
macro
web query
function
|
|
13. (TCO 7) Before protecting a worksheet, you
should _____ the cells that you want users to be able to edit.
(Points : 2)
|
format
hide
lock
unlock
|
|
14. (TCO 7) Which of the following file formats can store
macros? (Points : 2)
|
xlsm
csv
xml
xlsx
|
|
15. (TCO 7) By default, Excel automatically _____
macros and displays a security warning when a file containing macros is
opened. (Points : 2)
|
saves
deletes
runs
disables
|
|
Comments
Post a Comment