BIS 155 Week 2 Excel s Advanced Formulas & Functions - Quiz

profileAdvised
 (Not rated)
 (Not rated)
Chat

Week 2 Quiz

  1. (TCO 2) An absolute cell reference: (Points : 2)
  2. (TCO 2) Which of the following best describes a circular reference? (Points: 2)
  3. (TCO 2) =$E2-G$4 contains examples of _____ cell references. (Points: 2)
  4. (TCO 2) In Excel, an Argument would be best described by which of the following statements? (Points: 2)
  5. (TCO 2) The MEDIAN function would identify the ____. (Points: 2)
  6. (TCO 2) The MAX function identifies the _____. (Points: 2)
  7. (TCO 2) The NOW function would perform which of the following? (Points:2)
  8. (TCO 2) The _____ number is the number of the column in the lookup table that contains the return values. (Points : 2)
  9. (TCO 2) Arithmetic operations, cell references, and ____can be used in Excel formulas. (Points : 2)
  10. (TCO 2) To simplify entering ranges in formulas, you can use _____. (Points : 2)
  11. (TCO 7) A _____ helps to ensure consistency and standardization for similar workbooks, such as detailed income statements for all 12 months in a year. (Points : 2)
  12. (TCO 2) When calculating a PMT function, the PV is best described by which of the following? (Points : 2)
  13. (TCO 7) Before protecting a worksheet, you should __ the cells that you want users to be able to edit. (Points : 2)
    • 9 years ago
    BIS 155 Week 2 Excel s Advanced Formulas & Functions - Quiz
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      bis_155_week_2_excel_s_advanced_formulas__functions_-_quiz.docx