Unformatted text preview: 4. Create appropriate formulas for Rows 16 through 19 for all columns. Be sure cells are formatted correctly. 5. Add conditional formatting to cells I4:I15 so that Net Pay greater than $1,500.00 appears in a bold, blue font color. 6. Rename the Worksheet tab to: PayRoll 7. Be sure to save the file. 8. Zip the file into a file named: 146XXX02.zip (where XXX are your initials) and submit....
View Full Document
- Spring '10
- Following, Decimal, Summation