Devry bis155/bis 155 week 2 quiz 2 New (ALL CORRECT)

Question 1. Question :

 (TCO 2) An absolute cell reference:

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.

: Textbook Chapter 2

Comments:

Question 2. Question :

(TCO 2) Which of the following best describes a mixed cell reference?

Occurs when a formula directly or indirectly refers to the cell containing the formula.

Causes a potential error.

Contains absolute or relative cell references, but not both.

Contains both an absolute and a relative cell reference.

: Textbook Chapter 2

Comments:

Question 3. Question :

(TCO 2) The rules for constructing a function can be referred to as the function's _____.

synthesis

synergy

synchronization

syntax

: Textbook Chapter 2

Comments:

Question 4. Question :

(TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function.

PRESENT

TODAY

CURRENT

SET

: Textbook Chapter 2

Comments:

Question 5. Question :

(TCO 2) The _____ function returns a result based on a condition.

MAX

TODAY

FIND

IF

: Textbook Chapter 2

Comments:

Question 6. Question :

(TCO 2) The MAX function identifies the _____.

highest value in a range.

number of blank cells in a range.

lowest value in a range.

midpoint value in a range.

: Textbook Chapter 2

Comments:

Question 7. Question :

(TCO 2) The NOW function would perform which of the following?

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.

: Textbook Chapter 2

Comments:

Question 8. Question :

(TCO 2) The _____ number is the number of the column in the lookup table that contains the return values.

lookup value

column index

lookup table

random

: Textbook Chapter 2

Comments:

Question 9. Question :

(TCO 2) To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell.

sizing handle

pointer

fill handle

insertion point

: Textbook Chapter 2

Comments:

Question 10. Question :

(TCO 2) To simplify entering ranges in formulas, you can use _____.

range names

a cell's relative location

both an absolute and a relative cell reference

a cell's specific location

: Textbook Chapter 2

Comments:

Question 11. Question :

(TCO 2) When calculating a PMT function, the RATE would be described best 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 a word or a string of characters that represent one or more cells.

It is the present value of the loan.

: Textbook Chapter 2

Comments:

Question 12. Question :

(TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.

theme

style

template

macro

: Textbook Chapter 11

Comments:

Question 13. Question :

(TCO 7) The process of protecting a worksheet requires you to enter a(n) _____.

user name

e-mail address

IN user key

password

: Textbook Chapter 11

Points Received: 0 of 2

Comments:

Question 14. Question :

(TCO 7) You must _____ the recording of the macro when you have completed the tasks it was designed to do.

begin

stop

copy

paste

: Textbook Chapter 11

Comments:

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

: see p. 608 in textbook, first point under "Creating Macro Buttons."

Comments: