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