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

      highest value in a range.
      number of blank cells in a
range.
      lowest value in a range.
      midpoint value in a
range.

Never use plagiarized sources. Get Your Original Essay on
Question: Question 6.6. (TCO 2) The MAX function identifies the _____. (Points : 2)    &n…
Hire Professionals Just from $11/Page
Order Now Click here
Question
7.
7. (TCO 2) The NOW function
would perform which of the following? (Points : 2)

      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.

Question
8.
8. (TCO 2) The _____ number
is the number of the column in the lookup table that contains the
return values. (Points : 2)

      lookup value
      column index
      lookup table
      random

Question
9.
9. (TCO 2) To copy a
formula, you may use the _____, which is found in the bottom
right-hand corner of an active cell. (Points : 2)

      sizing handle
      pointer
      fill handle
      insertion point

Question
10.
10. (TCO 2) To simplify
entering ranges in formulas, you can use _____. (Points : 2)

      range names
      a cell’s relative
location
      both an absolute and a relative
cell reference
      a cell’s specific
location

Question
11.
11. (TCO 2) The PMT
function is best described by which of the following? (Points :
2)

      It is the periodic interest
rate, such as a monthly interest rate.
      It is the total number of
payment periods.
      It is the present value of a
loan.
      It calculates the periodic
payment for a loan with a fixed interest rate and a fixed
term.

Question
12.
12. (TCO 7) A _____ is a
partially completed workbook that you can use to create other
workbooks that have the same structure and purpose. (Points :
2)

      theme
      style
      template
      macro

Question
13.
13. (TCO 7) Before
protecting a worksheet, you should _____ the cells that you want
users to be able to edit. (Points : 2)

      format
      hide
      lock
      unlock

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

      begin
      stop
      copy
      paste

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

      Enable
      Disable
      Run
      Delete

Open chat
Lets chat on via WhatsApp
Hello, Welcome to our WhatsApp support. Reply to this message to start a chat.