Day 28 (Adv Apps)

FINISH TODAY

You will begin your Module 1-3 Quiz next class.

Excel Module 3–Performing Calculations with Formulas and Functions

At the end of this module you will know about how to:

  1. Document formulas and data values
  2. Explore function syntax
  3. Insert functions from the Formula Library
  4. Perform a what-if analysis
  5. AutoFill series and formulas
  6. Use relative and absolute cell references
  7. Use the Quick Analysis tool
  8. Work with dates and Date functions
  9. Find value with Lookup functions
  10. Work the Logical functions

RIGHT NOW:

  1. Review Assignment pages EX181 to EX182: Print as instructed–remember to always print showing formulas also
  2. Case Problem 1 pages EX182 to EX183: Print as instructed–remember to always print showing formulas also
  3. Case Problem 2 pages EX183 to EX184: Print as instructed–remember to always print showing formulas also
  4. EXTRA CREDIT–Case Problems 3 & 4 pages EX184 to EX186: Print as instructed–remember to always print showing formulas also

QUIZ:

  1. True/False: AutoFill copies content but formulas from a cell or range into an adjacent cell or range.
  2. True/False: The small black square in the lower-right corner of a selected cell or range is called the AutoFill button.
  3. Use the ________________ symbol to make a cell reference absolute.
  4. True/False: A relative reference is a cell reference that changes when it is copied and pasted in a new location.
  5. True/False: CTRL-A displays the menu of Quick Analysis tools.
  6. True/False: The right scroll arrow shows additional Quick Analysis tools.
  7. True/False: The TODAY function doesn’t have any arguments.
  8. True/False: The values returned by the TODAY and NOW functions are updated automatically whenever you reopen the workbook or enter a new calculation.
  9. To retrieve the return value from a vertical lookup table, you use the ______ function.
  10. If the VLOOKUP function cannnot find the lookup value, the ________ error value is displayed in the cell.
  11. What symbol appears at the beginning of a function?
  12. A(n) __________________ is a symbol that indicates the relationship between two values.