FREE Robert Half Microsoft Excel Questions and Answers
What is the shortcut on the keyboard for choosing a row of active cells?
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 we add a custom list to Excel so that we can use it over and over again?
Explanation:
File > Option > Advanced. This option will help you add any custom list in Excel so you can use it in the future.
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?
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.
The current date can be entered into a cell using which shortcut refreshing combination?
Explanation:
To insert the current date, press Ctrl+; (semi-colon). To insert the present time, press Ctrl+Shift+; (semi-colon).
Which of the following features DOES NOT relate to Ribbon's Review Tab?
Explanation:
The sort function is associated with the Data tab on the Ribbon and not with the Review Tab.
Can we use the subtotal to determine a sales order's maximum or minimum value?
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.
How can I add a header or footer to a page that will be printed?
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.