Day 31 (Adv Apps)

THE PURSUIT OF HAPPYNESS

THIRD QUARTER EVALUATION–PLEASE COMPLETE THIS HONESTLY–IT MEANS A LOT TO ME.

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

FINISH THIS TODAY.

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

BEGIN THIS TODAY.

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

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.

MODULE 3 QUIZ Get the handout from your teacher. Complete Jobs 1-2. Print answers & formulas FINISH: MODULE 3 QUIZ Get the handout from your teacher. Complete Jobs 1-2. Print answers & formulas