Day 23 (Adv Apps)

QUIZ:

  1. True/False: Every workbook should be accessible to its intended users.
  2. True/False: You should never use jargon or unusual terms in a workbook.
  3. True/False: Functions are organized in the Function Library group.
  4. True/False: To add a collection of numbers, use the COUNT function.
  5. To let Excel know you want to enter a formula, after clicking in a cell press the _______________ key.
  6. True/False: Like the COUNT function, many of Excel’s statistical functions ignore cells that are blank or contain text.
  7. True/False: If you leave a cell blank, the COUNTA function will include it.
  8. A(n) __________ lets you explore the impact that changing input values has on the calculated values in the workbook.
  9. _____________ automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal.
  10. True/False: An error indicator appears in the upper-left corner of the cell with the error value.
  11. True/False: The #NUM! error value means that a cell reference used in a formula or function is no longer valid.

BEGIN THIS TODAY. YOU WILL FINISH IT 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. Autofilling Formulas & Data: Read and do pages EX156 to EX161 and watch this video to help
  2. Exploring Cell References: Read and do pages EX161 to EX167 and watch this video to help
  3. Summarizing Data with the Quick Analysis Tool: Read and do pages EX167 to EX169 and watch this video to help
  4. Working with Dates and Date Functions: Read and do pages EX169 to EX170 and watch this video to help
  5. Using Lookup Functions: Read and do pages EX171 to EX174 and watch this video to help
  6. Working with Logical Functions: Read and do pages EX174 to EX179 and watch this video to help
  7. RAISE YOUR HAND TO SHOW ME YOU ARE DONE