Using data file attached with this assignment to solve the following questions

Write the formula for calculating the following values:-

Added two columns first one is Bouns and second is additional Bouns.

- Bonus:- which equal 3% of invoice total plus 150.

Additional Bonus := 8% from TotalPriceplus 200.

Using functions like sumif, sumifs, countif, countifs for summarizing the data as

1- calculate the total Quantities for all products that were sold in the West region.

2- find the max Quantity and minimum and average for all products.

3- Count the number of Products that are sold in the East region in Boston City and their category is Fruit.

4- calculate the total of invoice total in all regions.

5- calculate the total invoicetotal for all products that are sold in New York and from the category Snacks.

6-Count the number of Products that are sold in the West region in Los Angeles City and their category is Snacks.

7- calculate the total invoice total for all Categories.

8- calculate the total Quantities for all Categories

.