Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

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: 

Show more
  • @
  • 177 orders completed
ANSWER

Tutor has posted answer for $13.00. See answer's preview

$13.00

******** 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 ***** ***** ************** ***** **************

*********

Click here to download attached files: devry bis155 week 2 quiz 2 latest.docx
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question