Day 10 - Formatting a workbook continues
A well formatted document can transform a plain workbook filled with numbers and text into a powerful presentation that captures attention and adds visual emphasis to the points you want to make. On day 9 exercise, we have learned how to apply conditional formatting and format a workbook the way we wanted to present to our customers or co-worker. The assignment below will ask you to format a sales figure for the FrostiWear Store.
Case | FrostiWear
Linda Young is a sales manager for FrostiWear, a successful new store based in Hillsboro, Oregon. She is tracking the sales figure for FrostiWear’s line of gloves. She created a workbook that contains the sales figures from the past year for three glove models. She wants you to help format the sales report.
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 "FrostiWear" workbook to start.
If you're working in the classroom, you may find the Data File in the Share drive. |