Robert Half Assessment Test Microsoft Excel 2

Question 1

Which function returns the number of cells in a range that meet a single criterion?

Accepted Answer

COUNTIF

Answer

COUNT

Answer

COUNTA

Answer

SUMIF

Question 2

What does pressing Ctrl+Shift+Enter do when entering a formula?

Accepted Answer

Enters the formula as an array formula

Answer

Saves the workbook

Answer

Applies bold formatting

Answer

Opens the formula wizard

Question 3

In Excel, what is the purpose of the $ symbol in a cell reference like $B$4?

Accepted Answer

Makes the reference absolute so it doesn't change when copied

Answer

Formats the cell as currency

Answer

Locks the worksheet

Answer

Indicates a named range

Question 4

Which Excel feature automatically fills a series based on a pattern you establish?

Accepted Answer

AutoFill

Answer

AutoCorrect

Answer

Flash Fill

Answer

Quick Fill

Question 5

What does the TRIM function do in Excel?

Accepted Answer

Removes all spaces from text except single spaces between words

Answer

Rounds a number to a specified number of digits

Answer

Extracts a substring from the middle of text

Answer

Converts text to uppercase

Question 6

When you freeze panes in Excel, what is the primary benefit?

Accepted Answer

It locks row/column headers so they stay visible while scrolling

Answer

It prevents editing of selected cells

Answer

It protects the worksheet with a password

Answer

It merges selected cells

Question 7

Which function would you use to combine the text in cells A1 and B1 with a space between them?

Accepted Answer

=CONCAT(A1," ",B1)

Answer

=JOIN(A1," ",B1)

Answer

=MERGE(A1,B1)

Answer

=COMBINE(A1,B1)