# Devry bis155/bis 155 week 2 quiz 2 New (A++++++ ANSWER) - 92209

Solution Posted by

## anjis_devis

Rating : (20)B
Solution Detail
Price: \$12.00
• From: Computer Science, PHP
• Posted on: Wed 08 Jul, 2015
• Request id: None
• Purchased: 0 time(s)
• Average Rating: No rating
Request Description
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:
Solution Description

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

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

Question 3. Question :

(TCO 2) The rules for

Attachments