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