Robert Half Assessment Test Microsoft Excel Proficiency 2

Question 1

Which Excel function returns the position of a value within a range?

Accepted Answer

MATCH

Answer

FIND

Answer

SEARCH

Answer

INDEX

Question 2

What does the $ symbol do when placed before a column letter in a cell reference like $B5?

Accepted Answer

Locks the column only

Answer

Locks the entire row

Answer

Locks the entire cell

Answer

Locks the row only

Question 3

A manager wants to highlight all sales figures above $10,000 automatically. Which Excel feature should she use?

Accepted Answer

Conditional Formatting

Answer

Data Validation

Answer

Sparklines

Answer

Goal Seek

Question 4

Which function counts only the cells in a range that contain numbers?

Accepted Answer

COUNT

Answer

COUNTA

Answer

COUNTIF

Answer

COUNTBLANK

Question 5

What is the keyboard shortcut to apply the current date to a cell in Excel?

Accepted Answer

Ctrl+;

Answer

Ctrl+Shift+T

Answer

Ctrl+D

Answer

Alt+T

Question 6

In an Excel table, what automatically happens when you add a new row directly below the last data row?

Accepted Answer

The table expands to include the new row

Answer

A new worksheet is created

Answer

A warning dialog appears

Answer

The new row is ignored by formulas

Question 7

Which Excel chart type is best suited for showing parts of a whole as percentages?

Accepted Answer

Pie chart

Answer

Line chart

Answer

Scatter chart

Answer

Area chart