Question: Need help solving this Excell assignment 2. Open the Challenge-Format Text worksheet 3. Change the cell style in cells in second row to one of



Need help solving this Excell assignment
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. Multiple Worksheet Practice 1. Open the Excel File-Practice One-Multiple Worksheets and save the file including your name. 2. Insert a new worksheet, and rename it Q1 Summary (this will remain a blank worksheet for now.) 3. Move the Expenses Summary worksheet to the far right, then move the Q1 Summary worksheet so that it is between March and April. 4. Create a copy of the Expenses Summary worksheet by right-clicking the tab. Do not just copy and paste the content of the worksheet into a new worksheet. 5. Change the color of the January tab to blue and the color of the February tab to red. 6. Save the file and upload it to the Assignment link. 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}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
