Question: Question one: cell F 2 - Use a formula referring to other amounts in the road to calculate total units Your next questions are in

Question one: cell F

2 -

Use a formula referring to other amounts in the road to calculate total units

Your next questions are in relation to a pivot table, please tell me how to filter the pivot table to get the right answers. I also do not know how to some filters on Mac so please help me with that too. The filters are months, Donatello model, Leonardo model, Michelangelo model, Raphael model, total units, sales amount, customer, region, sales person

Question one: listed by salesperson, what is the lowest amount of total sales in june and july for kirby co

. ?

Question two: listed by region, what is the fewest number of sales invoices in june?

Question three: listed by customer in the north and south regions, what is the second lowest average sales amount?

Question four: what percentage of those units were the raphael model?

Question one: cell F2- Use a formula referring to other amounts

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question 1 Lowest Total Sales in June and July for Kirby Co Listed by Salesperson Filter the pivot table to show only June and July and set the Custom... View full answer

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 Accounting Questions!

Complete one column on the Data worksheet: Remaining Job Amount, Use this information to complete the requirements below. R1. Cell F2: Use a formula referring to other amounts in the row to calculate...

Company A provides delivery services to and from warehouses owned by a large e-commerce company. The company operates 10 routes in the local area. The company owns three types of fixed assets:...

im so confused please help i included ALL of the instructions given. which part is insufficent, i will add more B D F G H 2 E Flexible Budget Performance Report Project 3 4 Kristin's Frozen...

Completing this activity will help you leam to: - Extract information from sales data. - Extract information from a data set using Excel formulas, functions, and/or pivot tables. Scenario: Company A...

Hello, I really need some help here. The instructions are on the bottom page. Please start reading from top to bottom. I have 24 hours to submitted. AutoSave . OFF 1 Flexible budget project_Student...

https://1drv.ms/x/s!Ajz1egTFoa8gcuoTSY77n4NOPPw?e=bcNvmP Scenario: Company A began business operations this year. The company performs repair and upgrade jobs on heavy machinery for its customers....

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to...

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

I need help on the screen shot provided on the Costs Volume Profit Analysis, Profit volume forecast: This is the criteria for Costs Volume Profit Analysis: This is the criteria for Profit volume...

Acme Tarp Company has decided to import some cotton tarps from India. About half of the tarps will be used to make tents. The other half will be used to make sails. Assume that importation is...

A projectile is fired from horizontal ground with speed v and projection angle 0. When the acceleration due to gravity is g, the range of the projectile is d. If at the highest point in its...

Aladdin's Gyrocery has two product segments: falafel and gyros. Data for each product segment is as follows: Gyros Falafel Units sold 9,500 6,300 Revenue $85,500 $37,800 Variable Costs $38,000...

Which of the following is true of Generation Z ? ( Read through all answers. ) All of the answers listed are true Prefer popular mass produced products that look just like what their friends have...

From question 6, or based on other sources, select an organization you would like to work for. Research the company and develop some questions in preparation for a job interview.

Select a job you are interested in getting. Go online to one or more of the following websites to determine the compensation for the job you want: www.salaryexpert. com, www.indeed.com/salary,...

Prepare or revise your resume, and then evaluate it using Self-Assessment Exercise A-3. How did you score? Based on your assessment, revise your resume.