Excel Quiz 62 Posted on June 11, 2026August 19, 2026 by Vijay Verma Excel Quiz 62 This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. 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 Column A contains Region and Column B contains Sales. Which formula returns the second-highest Sales value for the East region? =SECOND(LARGE(FILTER(B2:B100,A2:A100="East"))) =LARGEIFS(FILTER(B2:B100,A2:A100="East"),2) =LARGE(FILTER(B2:B100,A2:A100="East"),2) =LARGEIFS(B2:B100,A2:A100,"East",2) 2 / 10 Suppose A2:A1000 contains names, including blanks and duplicates. Which formula returns a sorted unique list while ignoring blanks? =SORT(UNIQUE(A2:A1000)) =UNIQUE(SORT(FILTER(A2:A1000,A2:A1000=""))) =SORT(FILTER(UNIQUE(A2:A1000),A2:A1000="")) =SORT(UNIQUE(FILTER(A2:A1000,A2:A1000<>""))) 3 / 10 Suppose columns A:C contain: Customer | Product | Month You want to flag a row as "Duplicate" if the exact combination of Customer + Product + Month has appeared earlier in the data. Which formula in row 2, copied downward, works correctly? =IF(COUNT(A2:C2)>1,"Duplicate","") =IF(COUNTIFS(A$2:A$100,A2,B$2:B$100,B2,C$2:C$100,C2)=1,"Duplicate","") =IF(COUNTIFS(A:A,A2,B:B,B2,C:C,C2)>1,"Duplicate","") =IF(COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)>1,"Duplicate","") 4 / 10 You have: Column A = Region Column B = Product Column C = Sales Which formula returns Sales for Region = "West" and Product = "Laptop"? =XLOOKUP(TRUE, AND(A2:A100="West", B2:B100="Laptop"), C2:C100) =INDEX(C2:C100, MATCH("West", A2:A100, 0), MATCH("Laptop", B2:B100, 0)) =XLOOKUP(1, (A2:A100="West")*(B2:B100="Laptop"), C2:C100) =XLOOKUP("West"&"Laptop", A2:A100, B2:B100, C2:C100) 5 / 10 Column A contains dates and Column B contains sales amounts. Which formula counts transactions occurring in January 2026? =COUNTIFS(A2:A100,">="&DATE(2026,1,1),A2:A100,"<"&DATE(2026,2,1)) =COUNTIFS(A2:A100,">01/01/2026",A2:A100,"<31/01/2026") =COUNTIFS(A2:A100,MONTH(A2:A100)=1) =COUNTIFS(A2:A100,">"&DATE(2026,1,1),A2:A100,"<"&DATE(2026,1,31)) 6 / 10 Column A = Region and Column B = Sales. You want to rank each salesperson's sales within their own region, with the highest sales receiving rank 1. Which approach is appropriate? =RANK(B2,FILTER(B:B,A:A<>A2)) =RANK(B2,B:B) =RANK(B2,FILTER(B:B,A:A=A2),1) =COUNTIFS(A:A, A2, B:B, ">"&B2) + 1 7 / 10 Cell A2 contains: AB12X345CD67X890EF You need to extract all numbers that occur immediately after X, returning: 345 and 890 Which Excel 365 formula is most appropriate? =TEXTSPLIT(A2,"X") =TEXTAFTER(A2,"X") =REGEXEXTRACT(A2, "(?<=X)\d+", 1) =REGEXEXTRACT(A2,"X(\d+)") 8 / 10 Which formula correctly uses LET to calculate the 10% discount on A2, then add 18% GST on the discounted amount? =LET(x,A2*90%,A2+x*18%) =LET(x,A2*10%,x*118%) =LET(x,A2*90%,x*118%) =LET(x,A2-10%,x+18%) 9 / 10 Column A contains Employee, B contains Department, and C contains Salary. Which formula returns employees from IT department earning more than ₹100,000? =FILTER(A2:A500,(B2:B500="IT")*(C2:C500>100000)) =FILTER(A2:A500,(B2:B500="IT")&(C2:C500>100000)) =FILTER(A2:A500,(B2:B500="IT")+(C2:C500>100000)) =FILTER(A2:A500,B2:B500="IT",C2:C500>100000) 10 / 10 Cell A2 contains: INV-2026-4587-IN Which formula extracts 2026? =TEXTAFTER(TEXTBEFORE(A2,"-"),"-") Both MID(A2,5,4) and TEXTBEFORE(TEXTAFTER(... =MID(A2,5,4) =TEXTBEFORE(TEXTAFTER(A2,"-"),"-") Your score is LinkedIn Facebook Twitter Retake quiz Exit
