Free Robert Half Microsoft Excel Questions and Answers — Questions and Answers
Question 1: What is the shortcut on the keyboard for choosing a row of active cells?
- Shift + Spacebar (Correct answer)
- Ctrl + Spacebar
- Ctrl + End?
- Shift + End
Correct answer: Shift + Spacebar
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?
- 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 answer)
Correct answer: File > Options > Advanced > General > Edit custom List
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?
- Print Area
- Page Break
- Page Setups (Correct answer)
- Margin
Correct answer: Page Setups
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?
- Alt+PgDn/PgDn
- Alt+Tab
- Ctrl+UpArrow/DownArrow
- Ctrl+PgDn/PgUp (Correct answer)
Correct answer: Ctrl+PgDn/PgUp
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?
- YES (Correct answer)
- NO
Correct answer: YES
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.
Question 6: Which of the following features DOES NOT relate to Ribbon's Review Tab?
- The sort data function. (Correct answer)
- The spelling checker.
- The track changes function.
- The comment function.
Correct answer: The sort data function.
The Review tab in Microsoft Office applications like Excel is primarily dedicated to tools for collaboration, proofreading, and document finalization. Functions such as the spelling checker, track changes, and comments are integral to reviewing and refining content. In contrast, the 'sort data' function is typically found under the Data tab, as its purpose is to organize and manipulate data within a spreadsheet, not to review its textual or structural integrity.
Question 7: 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 answer)
Correct answer: Ctrl+; (Control+semicolon)
In Microsoft Excel, the shortcut Ctrl+; (Control+semicolon) is specifically used to quickly insert the current date into the active cell. This is a highly efficient feature for data entry, allowing users to timestamp information without manually typing the date. Other shortcuts serve different purposes, such as Ctrl+Shift+; for inserting the current time or Ctrl+D for filling down content.
Free Robert Half Microsoft Excel Questions and Answers
What is the shortcut on the keyboard for choosing a row of active cells?