Excel Quiz 60 Posted on January 1, 2026August 20, 2026 by Vijay Verma Excel Quiz 60 Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 You have test scores in A2:A20 and bin threshold limits in B2:B5 (4 bin values). When entered as an array formula, how many elements will the FREQUENCY(A2:A20, B2:B5) function output? 5 (One element more than the number of values in the bins array) 19 (The total count of values in the test scores range) 3 (One element less than the number of values in the bins array) 4 (Exactly the same number of elements as the bins array) 2 / 10 You have a table including header text in range A1:C50. You want to pass only the data rows (removing the 1st header row) into a dynamic array formula. Which modern function removes the specified number of top rows from an array? =DROP(A1:C50, 1) =SLICE(A1:C50, 1) =TAKE(A1:C50, 1) =TRIM(A1:C50, 1) 3 / 10 You have a dataset in cells A1:D100. You want to calculate the maximum value for each individual row dynamically, returning a single vertical array without copying a formula down. Which formula applies this calculation row by row? =MAP(A1:D100, MAX) =BYROW(A1:D100, LAMBDA(r, MAX(r))) =SCAN(A1:D100, LAMBDA(r, MAX(r))) =ROWMAX(A1:D100) 4 / 10 Column A contains Region, Column B contains Product, and Column C contains Sales. You want to look up the sales figure where Region equals "North" AND Product equals "Widget". Which formula correctly performs this multi-condition lookup? =XLOOKUP(AND(A2:A100="North", B2:B100="Widget"), C2:C100) =XLOOKUP(1, (A2:A100="North")*(B2:B100="Widget"), C2:C100) =XLOOKUP("North"&"Widget", A2:A100, B2:B100, C2:C100) =XLOOKUP("North""Widget", A2:A100:B2:B100, C2:C100) 5 / 10 When creating a Calculated Field directly inside a PivotTable, which calculation rule applies? Calculated fields can output dynamic dynamic arrays using UNIQUE Calculated fields fully support text functions like LEFT or MID Calculated fields operate on the sum of data fields and ignore cell references Calculated fields can reference specific cell coordinates like A1 6 / 10 Why is =GETPIVOTDATA generally preferred over direct cell references (like =C5) when creating financial dashboards linked to PivotTables? It automatically forces the underlying data source to refresh It dynamically retrieves data based on field names even if the PivotTable layout shifts It executes calculations faster than standard formulas It bypasses password protection on locked sheets 7 / 10 You have monthly cash flow values in cells A2:A13. You want a dynamic array formula that generates a cumulative running sum across all 12 months. Which dynamic array function generates this running total? =SCAN(0, A2:A13, LAMBDA(a, v, a + v)) =MAP(A2:A13, LAMBDA(x, SUM(x))) =REDUCE(0, A2:A13, LAMBDA(a, v, a + v)) =RUNNINGTOTAL(A2:A13) 8 / 10 Given a 2D table range A1:D10, you want to pass all values from the 3rd column into another function as a dynamic array. Which INDEX formula syntax returns the entire 3rd column? =INDEX(A1:D10, 3) =INDEX(A1:D10, ALL, 3) =INDEX(A1:D10, 0, 3) =INDEX(A1:D10, 3, 0) 9 / 10 You want to sort a dataset of names in A2:A50 based on Department in B2:B50 (ascending) and then by Salary in C2:C50 (descending). Which formula correctly configures this multi-level sort? =ORDER(A2:A50, B2:B50, 1, C2:C50, -1) =SORTBY(A2:A50, B2:B50, ASC, C2:C50, DESC) =SORTBY(A2:A50, B2:B50, 1, C2:C50, -1) =SORT(A2:A50, B2:B50, C2:C50) 10 / 10 You have two separate tables located in ranges A2:C10 and E2:G10. Which function stacks these two tables vertically into a single continuous array? =HSTACK(A2:C10, E2:G10) =APPEND(A2:C10, E2:G10) =CONCATENATE(A2:C10, E2:G10) =VSTACK(A2:C10, E2:G10) Your score is LinkedIn Facebook Twitter Retake quiz Exit
