Day 10 (Adv Apps)

GOAL: FINISH WORKING ON THE END OF MODULE MATERIALS/ASSIGNMENTS

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–TWO COPIES–1 SHOWING THE ANSWERS & 1 SHOWING THE FORMULAS
  2. Case Problem 1: Read and do pages 59 to 60–PRINT as instructed with your name in the header–TWO COPIES–1 SHOWING THE ANSWERS & 1 SHOWING THE FORMULAS
  3. Case Problem 2: Read and do pages 60 to 61–DO NOT PRINT–SHOW ME
  4. Case Problem 3 & 4: EXTRA CREDIT

MODULE 2.1

Microsoft Excel 2016

Module 2: Formatting Workbook Text and Data

Module Objectives

  • Change fonts, font style, and font color
  • Add fill colors and a background image
  • Create formulas to calculate sales data

Formatting Cell Text

  1. WATCH AND DO THIS VIDEO OVER PAGES EX65 to EX72–Show me before moving on to the next video

Working with Fill Colors and Backgrounds

  1. WATCH AND DO THIS VIDEO OVER PAGES EX72 to EX75–Show me before moving on to the next video

Using Functions and Formulas to Calculate Sales Data

  1. WATCH AND DO THIS VIDEO OVER PAGES EX75 to EX79–Show me before moving on to the next video