BIS 155 Endless Education /uophelp.com BIS 155 Endless Education /uophelp.com | Page 53

1. ============================================== BIS 155 Week 2 Quiz( Excel s Advanced Formulas &

Functions)

For more course tutorials visit www. uophelp. com

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)