Question: Task # 1: Display sales for a specific store. - Input - the owner will type a city name into cell H2. - Your task

 Task \# 1: Display sales for a specific store. - Input

Task \# 1: Display sales for a specific store. - Input - the owner will type a city name into cell H2. - Your task . create two formulas to show sales information for the store in that city, as follows: - H3 -- display the total sales amount for that one store - H4 - display the total number of sales for that store. Here is a sample screencap for Task \#1: Task \#2: Display sales for one specific product at one specific store - Input - the owner will type a city name into cell H7 and a product type into cell H8. - Your task - create two formulas to show sales information for the store in that city, as follows: - H9.. display the the total sales amount for the specified product (in H8 ) at the specified store (in H7). - H10.. display the number of sales for that combination of product and store. Task \#3: Display chocolate sales info In the data, Dark Chocolate and Milk Chocolate are different categories. The owner wants to know the combined total sales for all kinds of chocolate. - Your task - Create a SUMIFS formula in H14 that uses a wildcard criteria to compute the total sales for both milk and dark chocolate. (Groding note: you must have one formula that uses a wildcard criterio), Task \# 1: Display sales for a specific store. - Input - the owner will type a city name into cell H2. - Your task . create two formulas to show sales information for the store in that city, as follows: - H3 -- display the total sales amount for that one store - H4 - display the total number of sales for that store. Here is a sample screencap for Task \#1: Task \#2: Display sales for one specific product at one specific store - Input - the owner will type a city name into cell H7 and a product type into cell H8. - Your task - create two formulas to show sales information for the store in that city, as follows: - H9.. display the the total sales amount for the specified product (in H8 ) at the specified store (in H7). - H10.. display the number of sales for that combination of product and store. Task \#3: Display chocolate sales info In the data, Dark Chocolate and Milk Chocolate are different categories. The owner wants to know the combined total sales for all kinds of chocolate. - Your task - Create a SUMIFS formula in H14 that uses a wildcard criteria to compute the total sales for both milk and dark chocolate. (Groding note: you must have one formula that uses a wildcard criterio)

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!