Formatting Practice

1. Open the Excel File-Practice One-Basics and save the file including your name.

2. Open the Challenge-Format Text worksheet

3. Change the cell style in cells in second row to one of your choice.

4. Change the font style, color and size in row one to one of your choice. Bold the Title, include your name in the title and center this title.

5. Open the Challenge Format-Num worksheet.

6. Change the sales tax rate to the Percentage format (be sure to keep to the correct decimal level.)

7. Apply the Currency format to all currency related cells. Center the contents of Column C.

8. Insert a new line and add a coffee name of your choice along with a price and a quantity. Insure the same formatting requirement set earlier. Remember to create a Grand Total.

9. Change the background color in Row 11 to light gray.

10. Save and Upload this worksheet in the Assignment Tab.