Advance Excel Screening Test

1 / 20

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

ON ERROR GOTO

ERROR TRAP

HANDLE ERROR

TRY CATCH

2 / 20

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

SWITCH

IFS

IF

Both A and C

3 / 20

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

ADDRESS

CELL

INDEX

MATCH

4 / 20

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

64

128

Unlimited

32

5 / 20

What does Power Pivot primarily help with?

Data modeling and relationships

Simple calculations

File compression

Data visualization

6 / 20

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

Adjusts an input value to reach a desired output

Performs statistical analysis

Creates pivot tables automatically

Finds the maximum value in a dataset

7 / 20

What is the default delimiter in the TEXTSPLIT function?

Space (" ")

Semicolon (;)

Comma (,)

There is no default

8 / 20

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

TRANSPOSE

SUMIF

SEQUENCE

UNIQUE

9 / 20

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

Both A and B

Changes the calculation context

Filters data dynamically

Modifies row-level security

10 / 20

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

=EXTRACTSHEET(A1)

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

=SHEETNAME(A1)

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

11 / 20

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

CHOOSE

UNIQUE

INDIRECT

TEXTJOIN

12 / 20

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

QUARTILE

PERCENTILE

PERCENTRANK

RANK

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

14 / 20

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

FILTER

SORT

TEXTJOIN

UNIQUE

15 / 20

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

Splits queries into multiple tables

Merges queries based on a key column

Removes duplicates from queries

Combines queries by adding new rows

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

Histogram

Scatter Chart

Pie Chart

Line Chart

17 / 20

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

INDEX()

ROW()

COLUMN()

MATCH()

18 / 20

Which Excel function can return multiple values from an array?

INDEX

MATCH

FILTER

VLOOKUP

19 / 20

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

NULL

0

Error!

#DIV/0!

20 / 20

Which Excel feature allows automation without using VBA?

Solver

Macros

Power Query

Data Validation

Your score is

The average score is 31%

0%