# DEVRY BIS155 week 2 quiz

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