#### Words of Wisdom:

"Repent! and all shall be forgivien. Jesus is real and you better start beliving and u will be saved. Become a Christian." - BIGWAVE01

# Bis 155 Week 2 Excel’s Advanced Formulas & Functions – Quiz

• Date Submitted: 10/10/2015 01:22 AM
• Flesch-Kincaid Score: 74.2
• Words: 280
• Report this Essay
BIS 155 Week 2 Excel’s Advanced Formulas & Functions – 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)
14. (TCO 7) Which of the following file formats can store macros? (Points : 2)
15. (TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened. (Points : 2)
\$20.00 – Purchase