Devry BIS155 Week 2 QUIZ Latest 2015 November

QUESTION

Devry BIS155 Week 2 QUIZ Latest 2015 November

1. Question : (TCO 2) An absolute cell reference:

Question 2. Question
: (TCO 2) Which of the following
best describes a mixed cell reference?

Question 3. Question
: (TCO 2) =$E2-G$4 contains
examples of _____ cell references.

Question 4. Question
: (TCO 2) In Excel, an Argument
would be best described by which of the following statements?

Question 5. Question
: (TCO 2) The _____ function
returns a result based on a condition.

Question 6. Question
: (TCO 2) The MAX function
identifies the _____.

Question 7. Question
: (TCO 2) The _____ function can
be used to find an answer located in a vertical table.

Question 8. Question
: (TCO 2) If you enter an = and
the first few letters of a function in the formula bar, Excel will display a
drop-down list of functions beginning with those letters. This feature is
called _____.

Question 9. Question
: (TCO 2) Arithmetic operations,
cell references, and _____ can be used in Excel formulas.

Question 10. Question
: (TCO 2) _____ is a word or
string of characters that represent one or more cells.

Question 11. Question
: (TCO 2) When calculating a PMT
function, the RATE would be described best by which of the following?

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.

Question 13. Question
: (TCO 7) To unlock cells, click
the _____ tab, then click Format in the Cells group and select Lock Cell.

Question 14. Question
: (TCO 7) You must _____ the
recording of the macro when you have completed the tasks it was designed to do.

Question 15. Question
: (TCO 7) Users must click _____
Content to use the workbook and run the macros in the workbook.

ANSWER:

REQUEST HELP FROM A TUTOR