12. Q2 Create the following worksheet and perform the commands given below 20 marks Item Description...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
Here are the steps to create the Garden Tools worksheet and perform the requested commands 1 Save th... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Create two row vectors: a = [3 9 -0.5 3 6. 1 5. -0.8 4] b = [12 -0.8 6 2 5 3 -7.4] (a) Use the two vectors in a MATLAB command to create a 3 4 matrix such that the first row consists of elements 3...
-
ITEM NO. QTY UNIT DESCRIPTION UNIT PRICE TOTAL 1 1 PCS UMBRELLA RACK STAND ORGANIZER 4,375.00 4,375.00 2 1 PCS TOWEL RACK 450.00 450.00 3 17 PCS SPRAY BOTTLE (MEDIUM) 30.00 510.00 ***NOTHING...
-
4 cubed + 10 X 20 + 8 squared 23
-
A production line will be used to manufacture an item. The line will be operated with using the same personnel during single shift operations. During the initial line certification, the first item...
-
What is its total corporate value?
-
With a progressive tax structure, it makes a great deal of difference whether husbands' and wives' incomes are added together and taxed, or taxed separately. Discuss some of the equity and efficiency...
-
Repeat Problem 15.D12 but for \(\mathrm{q}=0.0015 \mathrm{~m}^{2} / \mathrm{s}\). a. Determine film thickness \(\delta\), average vertical velocity of film, and Reynolds number. b. Determine average...
-
MBI, Inc., had sales of $141.6 million for fiscal 2010. The companys gross profit ratio for that year was 31.6%. Required: a. Calculate the gross profit and cost of goods sold for MBI, Inc., for...
-
A comparative balance sheet and income statement is shown for Cruz, Incorporated. CRUZ, INCORPORATED Comparative Balance Sheets At December 31 Assets Cash Accounts receivable, net Inventory Prepaid...
-
Fair value accounting: the shortcomings Find and read the following article: Benston, \(\mathbf{G}\) 2008, 'The shortcomings of fair value accounting described in SFAS 157', Journal of Accounting and...
-
El nmero de (1) Response area es un factor que muchas personas analizan al evaluar una cuenta para seguir y es un dato importante que las (2) Response area utilizan para medir sus propios esfuerzos...
-
Calculate his monthly (P+I) payment assuming the mortgage factor is $5.68 per $1,000
-
Explain why in recent years European banks turned their focus back to their national markets. Outline the potential risks associated with this process. Q2: Explain how the securitization technique...
-
Initial Population: Generation 1: Generation 2: Lab Genetic Algorithms Instructions Creating the Initial Population: The initial population was created using a random bit string generator. This step...
-
One of your customers has a current balance of $21,000 in his accounts payable balance. You agree to charge a 12 percent interest compounded monthly on the overdue balance with a repayment schedule...
-
a). The target capital structure for Jacob Industries is 40% common stock, 10% preferred stock, and 50% debt. If the cost of common equity for the firm is 18%, the cost of preferred stock is 10%, the...
-
"write a" program PrintMatrixLoop.java that performs the following. Ask user to enter the number of rows and columns of a matrix Use Loop to print a matrix of randomly generated Xs and Os Count how...
-
Use Stokes' Theorem to evaluate f(y+sin x) dx+(z+cos y) dy+rdz, where C is the rve r(t) = (sint, cost, sin 2t), t = [0, 2].
-
The Elixer Drug Company produces a drug from two ingredients. Each ingredient contains the same three antibiotics, in different proportions. One gram of ingredient 1 contributes 3 units, and 1 gram...
-
State University has planned six special catered events for the Saturday of its homecoming football game. The events include an alumni brunch, a parents brunch, a booster club luncheon, a postgame...
-
Rachel Sundusky is the manager of the South-Atlantic office of the Stateline Shipping and Transport Company. She is in the process of negotiating a new shipping contract with Polychem, a company that...
-
Discuss the idea that as society changes so does accounting.
-
What do you consider to be the main differences between fi nancial and management accounting?
-
Classify the following as an income, an expense, an asset or a liability: (a) Friend owes business money (b) Football clubs gate receipts (c) Petrol used by a car (d) Photocopier (e) Revenue or Sales...
Study smarter with the SolutionInn App