Robert Half Assessment Test

FREE Robert Half Microsoft Excel Questions and Answers

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

YES

Correct! Wrong!

Explanation:
The correct answer is, Yes. We can find maximum or minimum Values with the help of subtotal by changing the use Function in the subtotal.

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

The sort data function.

The spelling checker.

The track changes function.

The comment function.

Correct! Wrong!

Explanation:
The sort function is associated with the Data tab on the Ribbon and not with the Review Tab.

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

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

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

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

File > Options > Advanced > General > Edit custom List

Correct! Wrong!

Explanation:
File > Option > Advanced. This option will help you add any custom list in Excel so you can use it in the future.

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

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

Ctrl+D

Ctrl+Shift+D

Ctrl+; (Control+semicolon)

Correct! Wrong!

Explanation:
To insert the current date, press Ctrl+; (semi-colon). To insert the present time, press Ctrl+Shift+; (semi-colon).

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

Shift + Spacebar

Ctrl + Spacebar

Ctrl + End?

Shift + End

Correct! Wrong!

Explanation:
Holding down the Shift key while pressing Spacebar will select the entire row in which the cursor is currently positioned in Microsoft Excel.

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

Print Area

Page Break

Page Setups

Margin

Correct! Wrong!

Explanation:
page setups. Page setup allows us to adjust print page settings. When you click on the page setup option, it will show you a page header and footer option to edit. For Page setup, please click on page layout and then click on the arrow on the left bottom corner of the page setup option.

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?

Alt+PgDn/PgDn

Alt+Tab

Ctrl+UpArrow/DownArrow

Ctrl+PgDn/PgUp

Correct! Wrong!

Explanation:
You can use either Ctrl+PgDn or Ctrl+PgUp to switch between the worksheets in a workbook. Press this shortcut repeatedly to navigate through the available worksheets.

FREE Robert Half Microsoft Excel Questions and Answers

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

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

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

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

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

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

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?

Related Post