DEVRY BIS155 WEEK 2 QUIZ 2 LATEST

DEVRY BIS155 WEEK 2 QUIZ 2 LATEST

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.”

---

We are ready to write this paper for you from scratch.
Place an order for this assignment or any other paper with us. We guarantee that the paper will be delivered within the specified deadline. We also have a personalized customer support and you will be able to communicate with your writer throughout the order preparation process. Thank you for choosing us.