Question 9 - In Wokrers sheet (10 points): Use Advanced Filter to retrieve all the rows matching the next conditions:

The Total_Income is between 4,000 and 11,000 inclusive.

The branch 3rd letter is l ("L")

Use copy to another location. The Criteria range will begin in cell L1. The output range will begin in cell L10. Retrieve only the columns (in this order): Category, Branch, SalesPerson, and Position.

Question 10 - In Pivots sheet (10 points): Use the data range "A2:D211" as input for all 3 tables starting in H3.

Table 1 (H3) - Calculate the table using the minifs, averageifs, maxifs, sumifs, countifs functions.

Table 2 (P3) - Calculate the table using the min, average, max, sum, count functions combine with the FILTER function.

Table 3 (W2) - Calculate the same 5 columns as before using a pivot table.

Question 11 - : (15 points).

In NorthWind sheet you have a pictures of NorhWind2023 data results. Assume

that all relations in Power Pivot exits. Write your answers in NorthWind sheet.

What will be the result of next measures: Question 1:= DISTINCTCOUNT('Order Details'[ProductID])

Question 2:=SUMX('Order Details',[Quantity]*[UnitPrice]*(1-[Discount])) Question 3:= CALCULATE(sum('Order Details'[Total Line]),

DimDate[Year]=2020,DimDate[Month]>10) Question 4:= DIVIDE(sum('Order Details'[Total Line]),1000000,0)

Question 5: In Merge sheet we have 2 tables. Table 1 the previous year Dean's list students. Table 2 the best students in the current year. A student cannot appear on the dean's list two years in a row. You need to merge these 2 tables for the current year dean's list. What right type of merge needed (the 6 options picture is at column J. write your answer in the previous sheet.