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

COUNTIF counts cells matching one criterion, e.g. =COUNTIF(A1:A10,">5").

Question 2

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

Accepted Answer

Enters the formula as an array formula

Answer

Ctrl+Shift+Enter confirms an array formula, displayed with curly braces {}.

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

Dollar signs anchor the row and/or column so the reference stays fixed when the formula is copied.

Question 4

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

Accepted Answer

AutoFill

Answer

AutoFill extends a recognized pattern (dates, numbers, custom lists) when you drag the fill handle.

Question 5

What does the TRIM function do in Excel?

Accepted Answer

Removes all spaces from text except single spaces between words

Answer

TRIM removes leading, trailing, and extra internal spaces, leaving only single spaces between words.

Robert Half Assessment Test Practice Test