Day 16 (Adv Apps)

BEGIN THE FOLLOWING TODAY–YOU WILL FINISH IT NEXT CLASS:

Microsoft Excel 2016

Module 2: Formatting Workbook Text and Data

GOAL: Before you leave today you will be able to demonstrate you have learned the following skills in Excel:

  1. Change fonts, font style, and font color
  2. Add fill colors and a background image
  3. Create formulas to calculate sales data
  4. Format numbers as currency and percentages
  5. Format dates and times
  6. Align, indent, and rotate cell contents
  7. Merge a group of cells
  8. Use the AVERAGE function
  9. Apply cell styles
  10. Copy and paste formats with the Format Painter
  11. Find and replace text and formatting
  12. Change workbook themes
  13. Highlight cells with conditional formats
  14. Format a worksheet for printing
  15. Set the print area, insert page breaks, add print titles, create headers and footers, and set margins
  1. End of Module Material
    1. Review Assignments: Read and do pages EX 123 to EX 124–Print as instructed–be sure to print the formulas also
    2. Case Problem 1: Read and do pages EX 125 to EX 126–Print as instructed–be sure to print the formulas also
    3. Case Problem 2: Read and do pages EX 126 to EX 127–Print as instructed–be sure to print the formulas also
  2. Extra Credit
    1. Case Problem 3: Read and do pages EX 127 to EX 129–Print as instructed–be sure to print the formulas also
    2. Case Problem 4: Read and do pages EX 129 to EX 130–Print as instructed–be sure to print the formulas also