+1(251)732-3555 Support@essayfy.com
Select Page

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

Hello, Welcome to our WhatsApp support. Reply to this message to start a chat.