Devry BIS155 Week 2 QUIZ Latest 2015 November 1. Question : (TCO 2) An absolute cell reference: Question 2. Question : (TCO 2) Which of the following best describes a mixed cell reference? Question 3. Question : (TCO 2) =$E2-G$4 contains examples of _____ cell references. Question 4. Question : (TCO 2) In Excel an Argument would be best described by which of the following statements? Question 5. Question : (TCO 2) The _____ function returns a result based on a condition. Question 6. Question : (TCO 2) The MAX function identifies the _____. Question 7. Question : (TCO 2) The _____ function can be used to find an answer located in a vertical table. Question 8. Question : (TCO 2) If you enter an = and the first few letters of a function in the formula bar Excel will display a drop-down list of functions beginning with those letters. This feature is called _____. Question 9. Question : (TCO 2) Arithmetic operations cell references and _____ can be used in Excel formulas. Question 10. Question : (TCO 2) _____ is a word or string of characters that represent one or more cells. Question 11. Question : (TCO 2) When calculating a PMT function the RATE would be described best 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) You must _____ the recording of the macro when you have completed the tasks it was designed to do. Question 15. Question : (TCO 7) Users must click _____ Content to use the workbook and run the macros in the workbook.
