Day 9 - Formatting a workbook
Highlighting Rules
Rule_ _ _ _ _ _ _ _ _ _ _ _ _ _ Highlights
Greater Than_ _ _ _ _ _ _ _ _ _Cell that are greater than a specified number
Less Than _ _ _ _ _ _ _ _ _ _ _Cell that are less than a specified number
Between_ _ _ _ _ _ _ _ _ _ _ __Cells that are between two specified numbers
Equal To_ _ _ _ _ _ _ _ _ _ ___Cells that are equal to a specified number
Test That Contains_ _ _ _ _ _ Cells that contain specified text
A Date Occurring_ _ _ _ _ _ _ Cells that contain a specified date
Duplicate Values ___________Cells that contain duplicate or unique values
Greater Than_ _ _ _ _ _ _ _ _ _Cell that are greater than a specified number
Less Than _ _ _ _ _ _ _ _ _ _ _Cell that are less than a specified number
Between_ _ _ _ _ _ _ _ _ _ _ __Cells that are between two specified numbers
Equal To_ _ _ _ _ _ _ _ _ _ ___Cells that are equal to a specified number
Test That Contains_ _ _ _ _ _ Cells that contain specified text
A Date Occurring_ _ _ _ _ _ _ Cells that contain a specified date
Duplicate Values ___________Cells that contain duplicate or unique values
Case |Iowa
Kay Lewis is a political columnist, commentator, and blogger. Her website, Lewis Reports, contains historic information on campaigns and elections. Recently, Kay compiled state-by-state and county-by-county voting totals for the past 15 presidential elections. She wants this information in an Excel workbook so she can analyze voting preferences and trends. Kay has created a workbook that contains the election results from the 2004 presidential election in Iowa. She asks you to format the workbook. She wants formats that quickly show which candidates won the state and county levels as well as the margin of victory. Counties that went heavily Democratic or Republican should have formats that reflect this fact.
Instruction File
|
Data File RequiredThe 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 "Iowa" workbook to start.
If you're working in the classroom, you may find the Data File in the Share drive. |