BIS 155 WEEK 2 QUIZ

BIS 155 WEEK 2 
Week 2 Quiz

Question 10.
Question :
(TCO 2) One benefit of using range names in formulas is that _____ .

Question 9.
Question :
(TCO 2) Which of the following best describes the HLOOKUP function?

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

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

Question 6.
Question :
(TCO 2) Which of the following best describes the COUNT function?

Question 4.
Question :
(TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function.

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

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

 1.
Question :
(TCO 2) In Excel, a relative cell reference:

Question 11.
Question :
(TCO 2) When calculating a PMT function, the PV is best described 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) Which of the following file formats can store macros?

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