Answered You can buy a ready-made answer or pick a professional tutor to order an original one.
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:
- @
- 177 orders completed
- ANSWER
-
Tutor has posted answer for $13.00. See answer's preview
******** 1 ******** :
(TCO ** ** absolute cell ***********
****** * ********* ******
indicates a ********** specific location *** *** reference **** not change **** you **** *** formula
****** when a ******* ******** ** indirectly ****** ** *** cell containing *** ********
contains **** an ******** *** a ******** **** reference
* ******** ******* **
**********
Question * ******** **
(TCO ** ***** ** *** following **** describes a ***** **** ***********
****** **** * formula directly or indirectly ****** to *** **** ********** *** formula
Causes * ********* ******
******** ******** ** ******** cell ********** but not *****
******** **** ** ******** and * ******** **** **********
* ******** ******* **
**********
******** * ******** :
**** ** *** ***** *** ************ * function can ** referred to as *** function's ******
**********
synergy
****************
syntax
* ******** ******* **
**********
******** * Question :
**** 2) ** display the ******* **** ** each page ** ** Excel ********* use *** ***** *********
********
TODAY
CURRENT
SET
* ******** Chapter 2
**********
******** 5 ******** **
(TCO 2) *** ***** ******** ******* a ****** ***** ** a **********
****
******
FIND
***
* ******** ******* **
**********
******** * ******** :
**** ** *** *** ******** identifies the ******
highest ***** in * ******
****** ** ***** ***** ** * ******
****** ***** ** * range
******** value in * ******
* Textbook Chapter **
**********
******** * Question **
(TCO 2) *** *** function ***** perform which ** the ***********
******** ******* ******** ******** inside *** ** **** ** *** **********
********* * ********* *** ******* one ***** ** the ********* is true *** * ********* ***** if *** ********* ** false
********* **** ** ******
******** *** ******* date *** *****
: Textbook ******* **
**********
******** * ******** **
**** ** *** _____ ****** ** *** number of *** ****** ** *** lookup ***** **** ******** *** return *******
****** ******
****** ******
****** table
*******
* ******** ******* **
**********
******** * ******** **
**** 2) ** **** * formula *** *** *** *** _____ ***** is ***** in the ****** ********** ****** ** ** active *****
****** *******
********
**** *******
********* ******
* ******** Chapter 2
**********
******** ** ******** :
**** ** To ******** ******** ****** in ******** *** *** *** ******
***** ******
* ********** ******** location
**** an ******** *** * ******** cell **********
a ********** specific *********
: ******** ******* **
Comments:
Question ** Question :
(TCO 2) **** *********** * *** ******** the **** ***** ** described best ** ***** ** *** ***********
It is *** ******** interest **** **** as * ******* ******** *****
** is *** ***** ****** ** payment ********
** ** * **** or a ****** of ********** **** ********* *** ** **** ******
It ** the ******* value ** the *****
* ******** Chapter **
Comments:
Question ** Question :
**** ** A ***** ** * ********* ********* workbook that *** *** *** ** create other ********* **** **** the **** ********* *** ********
theme
style
*********
******
* ******** Chapter 11
Comments:
******** ** ******** **
(TCO ** *** process of ********** a ********* ******** *** ** ***** **** _____
**** *****
e-mail ********
IN **** key
*********
* ******** ******* ***
Points ********* ** **
Comments:
******** ** ******** **
**** ** *** must ***** *** ********* ** *** ***** when *** have ********* *** ***** ** was designed ** ***
******
*****
copy
******
* ******** ******* ***
**********
******** 15 ******** **
(TCO ** To ****** a ***** ****** click *** _____ tab click Insert **** ***** Button in the Form ******** ******* ** *** ****** palette
*****
Data
Insert
**********
: *** * 608 ** ******** first ***** ***** ************** ***** **************
*********