Advance Excel Screening TestBy Collab Team Contributor / February 15, 2025 Advance Excel Screening Test 1 / 20 Which of the following formulas will correctly return the third-largest value in a range A1:A10? =MAX(A1:A10, 3) =LARGE(A1:A10, 3) =RANK(A1:A10, 3) =INDEX(A1:A10, 3) 2 / 20 In Excel, which formula is used to retrieve the column number of a reference? COLUMN() MATCH() INDEX() ROW() 3 / 20 Which Excel function can return multiple values from an array? VLOOKUP INDEX MATCH FILTER 4 / 20 In Excel VBA, which statement is used to handle errors? ON ERROR GOTO HANDLE ERROR TRY CATCH ERROR TRAP 5 / 20 What does the "Goal Seek" feature in Excel do? Creates pivot tables automatically Performs statistical analysis Adjusts an input value to reach a desired output Finds the maximum value in a dataset 6 / 20 What does Power Pivot primarily help with? Data visualization File compression Simple calculations Data modeling and relationships 7 / 20 What is the maximum number of conditions that can be used in an IF function in Excel? 128 64 Unlimited 32 8 / 20 Which function is used to evaluate multiple conditions and return a value? IF IFS SWITCH Both A and C 9 / 20 Which Excel feature allows automation without using VBA? Solver Power Query Data Validation Macros 10 / 20 Which of the following functions is used to return the k-th percentile of a data set in Excel? RANK PERCENTRANK QUARTILE PERCENTILE 11 / 20 What will the formula =IFERROR(10/0,"Error!") return? #DIV/0! Error! NULL 0 12 / 20 Which of the following chart types is best for showing trends over time?A) Pie ChartB) Line ChartC) Scatter ChartD) Histogram Pie Chart Line Chart Scatter Chart Histogram 13 / 20 In Power Query, what does the "Append Queries" function do? Removes duplicates from queries Combines queries by adding new rows Merges queries based on a key column Splits queries into multiple tables 14 / 20 Which of the following functions can create dynamic dependent drop-down lists? UNIQUE INDIRECT TEXTJOIN CHOOSE 15 / 20 What is the default delimiter in the TEXTSPLIT function? There is no default Space (" ") Comma (,) Semicolon (;) 16 / 20 Which of the following functions will NOT return an array in Excel? TRANSPOSE UNIQUE SUMIF SEQUENCE 17 / 20 Which function can be used to generate a unique list from a dataset? SORT FILTER UNIQUE TEXTJOIN 18 / 20 Which function is used to return the address of a cell that matches a condition? ADDRESS INDEX CELL MATCH 19 / 20 What does the DAX function CALCULATE do in Power BI? Changes the calculation context Modifies row-level security Filters data dynamically Both A and B 20 / 20 Which formula is used to extract the sheet name from a cell reference? =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) =RIGHT(A1,FIND("]",A1)-1) =EXTRACTSHEET(A1) =SHEETNAME(A1) Your score isThe average score is 31% 0% Restart quiz
By
/ February 15, 2025 By
/ February 15, 2025 By
/ February 15, 2025 By
/ February 15, 2025 By
/ February 15, 2025 By
/ February 15, 2025