Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

12. Q2 Create the following worksheet and perform the commands given below 20 marks Item Description Spade Garden Shovel Hose 25' Hose 50' Power

image

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

Step by Step Solution

3.49 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

Here are the steps to create the Garden Tools worksheet and perform the requested commands 1 Save th... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Management Science

Authors: Bernard W. Taylor

11th Edition

132751917, 978-0132751919

More Books

Students also viewed these Accounting questions

Question

4 cubed + 10 X 20 + 8 squared 23

Answered: 1 week ago