Question: (Review Excel Formulas and Functions Tutorial, located in the topic Resources.) Open Sheet 2 by clicking the Sheet 2 tab at the bottom of the

(Review "Excel Formulas and Functions Tutorial," located in the topic Resources.) Open Sheet 2 by clicking the Sheet 2 tab at the bottom of the Excel Workbook. In cell D1, type "Total Unit Sales." Using the basic calculation functionality of Excel, find the total unit sales (Price per Unit times the Units Sold) for each product. Do not use a separate calculator to find the results. Include the result in column D. Type "Average" in cell A12. In cell B12, insert a function to find the average price per unit. In cell C12, insert a function to find the average number of units sold. Change the price per unit of weed spray to $26.06. Change the plastic buckets units sold to 359. Type Total Sales in cell F4. Insert a function in cell G4 for the sum of all Total Unit Sales. Rename Sheet 2 "Garden Store

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

I would like someone to look over my project. I am unsure about the unearned revenue portion. Also, I think the net income should be the retained earning but I can't balance...Either A. I am off...

those teo pages are the page 427. only those 2 questions need to be answered For this assignment, you will (1) whark with Excel; and (2) respond to series of prompts (you'll write your responses...

Hello! I need some help filling preparing a cash flow statement for this accounting problem please show formulas/work so I can refer back to it for next time I get stuck. Thank you! INNOVATION...

Innovation Electronics, Inc. has provided you with the year end Income Statement Balance Sheet. The Controller has asked you to prepare the Statement of Cash Flows for the same year ended December...

Income Statement: Balance Sheet: Statement of Cashflows: If you can put down what you did to get the final highlighted number in the cash flows, that would be awesome! Innovation Electronics, Inc....

Complete the statement of cash flows (indirect method) shown below by using formulas that reference data from the income statement and balance sheet (found by clicking the tabs at the bottom of this...

Complete the statement of cash flows ( indirect method ) shown below by using formulas that reference data from the income statement and balance sheet ( found by clicking the tabs at the bottom of...

3. Correctly encode the following METAR report in the correct order. Conditions at: CYYZ (TORONTO/PEARSON, ON, CA) observed 0000 UTC 19 January 2021 Temperature: -0.0C (32F) Dew point: -3.0C (26.6F)...

What is meant by the term cost of goods manufactured (CGM)? How is CGM calculated?

7. Calculating Returns and Variability (LO1) Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Returns Year X Y 1 15% 21%...

Oust the Turtle Company has the following balances on December 31, 2020: Cash on hand 4,500.00 Cash in bank A 33,000.00 Cash in bank X 50,000.00 Cash in bank C 822,999.72 Cash on hand includes $ 3....