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.

Menu Plan for November Customer Invoice Zasm PERVIAN COFFEE Bad Llama Peruvian Coffee 2121 14th Avenue Circle Drive Raleigh, NC 27607 Invoice \#40592 \begin{tabular}{lrrr} \multicolumn{1}{c}{ ITEM DESCRIPTION } & UNIT PRICE & QUANTITY & LINE TOTAL \\ \hline Cusco Dark Roast & 6.59 & 3 & 19.77 \\ Amazon Amanecer Breakfast Roas & 6.89 & 8 & 55.12 \\ Sacred Valley Medium Roast & 6.49 & 10 & 64.9 \\ Machu Picchu Special Blend & 7.29 & 2 & 14.58 \\ \hline & & SALES TAX RATE: & 0.075 \\ & & TAX: & 11.57775 \\ & & TOTAL: & 154.37 \end{tabular}