Advance Excel Screening Test

1 / 20

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

Error!

NULL

#DIV/0!

0

2 / 20

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

=SHEETNAME(A1)

=RIGHT(A1,FIND("]",A1)-1)

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

=EXTRACTSHEET(A1)

3 / 20

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

32

64

Unlimited

128

4 / 20

Which Excel feature allows automation without using VBA?

Solver

Macros

Power Query

Data Validation

5 / 20

What does Power Pivot primarily help with?

Simple calculations

Data visualization

Data modeling and relationships

File compression

6 / 20

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

INDIRECT

CHOOSE

TEXTJOIN

UNIQUE

7 / 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

8 / 20

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

TEXTJOIN

FILTER

UNIQUE

SORT

9 / 20

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

=RANK(A1:A10, 3)

=MAX(A1:A10, 3)

=LARGE(A1:A10, 3)

=INDEX(A1:A10, 3)

10 / 20

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

RANK

QUARTILE

PERCENTRANK

PERCENTILE

11 / 20

Which Excel function can return multiple values from an array?

INDEX

FILTER

VLOOKUP

MATCH

12 / 20

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

Removes duplicates from queries

Merges queries based on a key column

Combines queries by adding new rows

Splits queries into multiple tables

13 / 20

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

ERROR TRAP

TRY CATCH

HANDLE ERROR

ON ERROR GOTO

14 / 20

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

TRANSPOSE

SUMIF

SEQUENCE

UNIQUE

15 / 20

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

MATCH

CELL

ADDRESS

INDEX

16 / 20

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

MATCH()

ROW()

COLUMN()

INDEX()

17 / 20

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

Finds the maximum value in a dataset

Adjusts an input value to reach a desired output

Performs statistical analysis

Creates pivot tables automatically

18 / 20

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

IFS

Both A and C

SWITCH

IF

19 / 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

Scatter Chart

Histogram

Pie Chart

20 / 20

What is the default delimiter in the TEXTSPLIT function?

Comma (,)

Semicolon (;)

There is no default

Space (" ")

Your score is

The average score is 31%

0%