FREE Robert Half Microsoft Excel Questions and Answers

Question 1

What is the shortcut on the keyboard for choosing a row of active cells?

Accepted Answer

Shift + Spacebar

Answer

Ctrl + Spacebar

Answer

Ctrl + End?

Answer

Shift + End

Question 2

How can we add a custom list to Excel so that we can use it over and over again?

Accepted Answer

File > Options > Advanced > General > Edit custom List

Answer

File > Options > Formulas > Calculation option > Edit Custom List

Answer

File > Options > General > Default Program > Edit Custom List

Answer

File > Option > Add-In > Edit Custom List.

Question 3

How can I add a header or footer to a page that will be printed?

Accepted Answer

Page Setups

Answer

Print Area

Answer

Page Break

Answer

Margin

Question 4

Most Excel spreadsheets have many worksheets (noted on the tabs at the bottom right-hand side of the Excel screen). Which of the following corresponds to the keyboard shortcut in Microsoft Excel for navigating between worksheets?

Accepted Answer

Ctrl+PgDn/PgUp

Answer

Alt+PgDn/PgDn

Answer

Alt+Tab

Answer

Ctrl+UpArrow/DownArrow

Question 5

Can we use the subtotal to determine a sales order's maximum or minimum value?

Accepted Answer

YES

Answer

NO

Question 6

Which of the following features DOES NOT relate to Ribbon's Review Tab?

Accepted Answer

The sort data function.

Answer

The spelling checker.

Answer

The track changes function.

Answer

The comment function.

Question 7

The current date can be entered into a cell using which shortcut refreshing combination?

Accepted Answer

Ctrl+; (Control+semicolon)

Answer

Ctrl+Shift+; (Control+Shift+semicolon)

Answer

Ctrl+D

Answer

Ctrl+Shift+D