Question: Create a one variable Data Table from what you just copied and pasted giving the average sales for each department, and the Largest Sale from

Create a one variable Data Table from what you just copied

Create a one variable Data Table from what you just copied and pasted giving the average sales for each department, and the Largest Sale from each department. (Hint: Daverage and Dmax and create your criteria range starting in Cell A1)

On the Data table Sheet. Create a 2 variable data table starting in Cell A20 giving the Average Sales for each department by Gender. Start your Criteria Range in cell A15. (Hint: DAverage and the criteria range should include Department and Gender).

On the Employee Sales sheet, in Cell A52, create a formula to calculate the total sales by Males. Use the criteria range in cells A47:A48.

On the Employee Sales sheet, in cell C52, create a formula to calculate the total sales by Females. Use the criteria range in Cells C47:C48.

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 General Management Questions!

14. Create a one variable Data Table from what you just copied and pasted giving the total sales for each department, and the Largest Sale from each department. Start your Criteria range in cell A1....

please any help with this excel homework the 3 first pic are from the excel file and lasr three are the instructions. please and thank you!!! 1 f $ Employee # 7 03467 8 08467 9 01340 10 04070 11...

Assessment Details Scenario: Pastas R Us, Inc. is a fast-casual restaurant chain specializing in noodle-based dishes, soups, and salads. Since its inception, the business development team has favored...

In cell G7, create a vlookup formula to look up and return the department head names for each department. You will find the department heads listed on the Department Head sheet (Remember that vlookup...

Course Title: Data Analysis and Business Analytics Assessment Title: Competency 1 Assessment Points: 1 00 Assignment Directions Read the scenario, part 1, part 2, and the rubric before beginning your...

1. In cell A1 type in your name. 2. In cell A2 type in your email address. 3. In cell B1 give a formula to find todays date. Make sure the formula will update to the current date every time it is...

10. starting in cell N1, run an advanced data filter that will filter out the Employee # and Total Sales for the employees found in the Computer Department. Create your criteria Range starting in...

Petra Refining Company processes gasoline. Petroleum is placed in production in the Refining Department and, after processing, is transferred to the Blending Department, where detergents are added....

Figure P13.7 shows a system being driven by base excitation through a damping element. Assume that the base displacement is sinusoidal: y(t) = Y sin (t. a. Derive the expression for X, the...

The residual income valuation model is suitable as an alternative to a free cash flow model when the company is not dividend-paying. 1) True 2) False

The annual demand for an item is 1,700 units. The order cost is $7. Unit cost is $8 and the unit holding cost per year is 18% of the item's value. The order quantity is 125 units. What are the total...