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

In Microsoft Excel, the keyboard shortcut 'Shift + Spacebar' is used to select the entire row where the active cell is located. This is a quick and efficient way to highlight all cells across a row, which can then be used for various operations like formatting, deleting, or copying.

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

To add a custom list in Excel for repeated use, such as for auto-filling sequences, you navigate through the Excel options. The correct path is 'File > Options > Advanced,' then scroll down to the 'General' section, where you will find the 'Edit Custom Lists' button. This allows users to create and manage their own predefined lists for sorting and filling data.

Question 3

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

Accepted Answer

Page Setups

Answer

In Microsoft Excel, headers and footers for printed pages are managed within the 'Page Setup' options. This dialog box provides comprehensive controls for how a worksheet will appear when printed, including settings for margins, orientation, scaling, and the ability to add custom headers and footers to display information like page numbers, dates, or file names.

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

The keyboard shortcut 'Ctrl + PgDn' (Page Down) allows users to navigate to the next worksheet tab to the right, while 'Ctrl + PgUp' (Page Up) moves to the previous worksheet tab to the left. These shortcuts are essential for efficiently moving between multiple worksheets within an Excel workbook without using the mouse.

Question 5

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

Accepted Answer

YES

Answer

The Subtotal feature in Excel is highly versatile and can indeed be used to determine the maximum or minimum value within a sales order or any grouped data. When applying subtotals, Excel allows you to choose various summary functions, including SUM, COUNT, AVERAGE, MAX, and MIN, making it a powerful tool for analyzing grouped data.

Robert Half Assessment Test Practice Test

Robert Half Assessment Test Practice Test

FREE Robert Half Microsoft Excel Questions and Answers