BIS 155 WEEK 2 QUIZ EXCEL S ADVANCED FORMULAS & FUNCTIONS

BIS 155 WEEK 2 QUIZ EXCEL S ADVANCED FORMULAS & FUNCTIONS

To Download tutorial Copy and Paste below Link into your Browser

for any inquiry email us at  ( essayblue@gmail.com )

BIS 155 Week 2 Quiz Excel s Advanced Formulas & Functions

Week 2 : Excel’s Advanced Formulas & Functions – Quiz

Time Remaining:

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

Popular posts from this blog

BIO 365S HOMEWORK 3 RESPIRATORY

ASSIGNMENT 3: POWERPOINT PRESENTATION

ASSIGNMENT 3: LEADERSHIP OF RICHARD BRANSON