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 )