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.
Comments: