Microsoft Excel 2016

Module 2: Formatting Workbook Text and Data

  1. 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
  2. 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
  3. 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