12. Q2 Create the following worksheet and perform the commands given below 20 marks Item Description...

Transcribed Image Text:

12. Q2 Create the following worksheet and perform the commands given below 20 marks Item Description Spade Garden Shovel Hose 25' Hose 50' Power Hose Tools Misc Minim um Maximum Average Units sold 1355 1729 1124 2212 2000 2400 Unit Cost $13.75 5.96 6.45 11.45 20.35 16.00 Unit Selling Price $18.25 12.99 15.95 21.50 30.25 23.50 1. Save the worksheet as Garden Tools 2. Give the title Garden Tools, merge center and make it attractive 3. Insert columns/rows where needed 4. Find the total for all columns 5. Apply borders to the worksheet and shading to calculated rows/columns 6. Find the Total Sales based on Cost 7. Find the Total Sales based on selling Price 8. Find the Profit for each item 9. Find the average, highest value, and lowest value for total sales 10. Add the title Garden Tools for the worksheet. Use Title style and center across the columns. Use fill color of your choice 11. Use currency style for first row of numbers, for the last 4 columns and the last three rows of numbers Find the percentage of profit 13. Sort the table lowest to the highest based on Total selling price 14. Apply table style of your choice for the data except the title 15. Use a double line outside border for the data 16. Add all enhancements to create an attractive worksheet 17. Save and email to instructor 12. Q2 Create the following worksheet and perform the commands given below 20 marks Item Description Spade Garden Shovel Hose 25' Hose 50' Power Hose Tools Misc Minim um Maximum Average Units sold 1355 1729 1124 2212 2000 2400 Unit Cost $13.75 5.96 6.45 11.45 20.35 16.00 Unit Selling Price $18.25 12.99 15.95 21.50 30.25 23.50 1. Save the worksheet as Garden Tools 2. Give the title Garden Tools, merge center and make it attractive 3. Insert columns/rows where needed 4. Find the total for all columns 5. Apply borders to the worksheet and shading to calculated rows/columns 6. Find the Total Sales based on Cost 7. Find the Total Sales based on selling Price 8. Find the Profit for each item 9. Find the average, highest value, and lowest value for total sales 10. Add the title Garden Tools for the worksheet. Use Title style and center across the columns. Use fill color of your choice 11. Use currency style for first row of numbers, for the last 4 columns and the last three rows of numbers Find the percentage of profit 13. Sort the table lowest to the highest based on Total selling price 14. Apply table style of your choice for the data except the title 15. Use a double line outside border for the data 16. Add all enhancements to create an attractive worksheet 17. Save and email to instructor

Answer rating: 100% (QA)

Here is the completed Garden Tools worksheet based on the given instructions plaintext Item Units So... View the full answer