Advance Excel Screening Test

By Collab Team Contributor / February 15, 2025

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 Chart
B) Line Chart
C) Scatter Chart
D) 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!

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

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

Unlimited

20 / 20

Which Excel feature allows automation without using VBA?

Solver

Macros

Power Query

Data Validation

Your score is

The average score is 31%

What does the "Goal Seek" feature in Excel do?

What does the DAX function CALCULATE do in Power BI?

In Power Query, what does the "Append Queries" function do?

Which function is used to return the address of a cell that matches a condition?

Which of the following chart types is best for showing trends over time?

Which function can be used to generate a unique list from a dataset?

Which of the following functions is used to return the k-th percentile of a data set in Excel?

In Excel VBA, which statement is used to handle errors?

What will the formula =IFERROR(10/0,"Error!") return?

Which of the following functions can create dynamic dependent drop-down lists?

Which Excel function can return multiple values from an array?

Which formula is used to extract the sheet name from a cell reference?

What does Power Pivot primarily help with?

Which of the following formulas will correctly return the third-largest value in a range A1:A10?

In Excel, which formula is used to retrieve the column number of a reference?

What is the default delimiter in the TEXTSPLIT function?

Which function is used to evaluate multiple conditions and return a value?

Which of the following functions will NOT return an array in Excel?

What is the maximum number of conditions that can be used in an IF function in Excel?

Which Excel feature allows automation without using VBA?

Related Posts

Leave a Comment Cancel Reply

What does the DAX function `CALCULATE` do in Power BI?

What will the formula `=IFERROR(10/0,"Error!")` return?

What is the maximum number of conditions that can be used in an `IF` function in Excel?