Microsoft Excel 2010
  • Home
  • Daily Lessons
    • Day Two
    • Day Three
    • Day Four
    • Day Five
    • Day Six
    • Day Seven
    • Day Eight
    • Day Nine
    • Day Ten
    • Day Eleven
    • Day Twelve
    • Day Thirteen
    • Day Fourteen
  • Data Files
  • Answer Keys
  • Tutorial
  • Survey
  • Resource
  • Contact

Day 7 - Conditional Formatting

Formatting can help you analyze data by highlighting significant numbers or trends in the data. A conditional format applies formatting only when a cell’s value meets a specified condition.  For example, a conditional format can make negative numbers red and positive numbers green.  Conditional formats are dynamic, so a cell’s appearance will change to reflect its current value.

Case | ExterComp

Tom wants you to format a workbook that compares the sales of the X310 and X410 models during that time. The workbook has a documentation sheet, a Model comparison sheet comparing the total unit sold for each model in the eight sales regions, and a Monthly Sales sheet reporting the number of units sold per month.

In the Model comparison sheet, Tom wants you to highlight the sales regions that showed the greatest sales increases from 2008 to 2009
.

Instruction File

exercomp_instruction.pdf
File Size: 56 kb
File Type: pdf
Download File

Data File Required

The file on the left side is an instruction file. Click on Download File to open the file. Once opened, print a copy to get started.  This particular assignment requires a data file to start. After printing the instruction file, go to the Data Files tab and open "X410" workbook to start.
If you're working in the classroom, you may find the Data File in the Share drive.
Seattle Goodwill | 1400 S. Lane St. Seattle, WA 98144 | 206 860 5791 | www.seattlegoodwill.org
✕