Day 9 (Adv Apps)

GOAL: BEGIN WORKING ON THE END OF MODULE MATERIALS/ASSIGNMENTS AT THE BOTTOM OF THIS PAGE

EXCEL SESSION 1.2

When you are done with this session you will be able to:

  1. Enter formulas and the SUM and COUNT functions
  2. Copy and paste formulas
  3. Move or copy cells and ranges
  4. Insert and delete rows, columns, and ranges
  5. Create patterned text with Flash Fill
  6. Add cell borders and change font size
  7. Change worksheet views
  8. Prepare a workbook for printing
  9. Save a workbook with a new filename

RIGHT NOW:

  1. End of Module Material
    1. Review AssignmentRead and do pages 58 to 59, #1-21
      1. #19 & 20–PRINT with your name in the header–PRINT TWO COPIES–1 SHOWING THE ANSWERS & 1 SHOWING THE FORMULAS–NAME IN THE HEADER
    2. Case Problem 1: Read and do pages 59 to 60–PRINT TWO COPIES–1 SHOWING THE ANSWERS & 1 SHOWING THE FORMULAS–NAME IN THE HEADER
    3. Case Problem 2: Read and do pages 60 to 61–DO NOT PRINT–SHOW ME
    4. Case Problem 3 & 4: EXTRA CREDIT