Robert Half Assessment Test Microsoft Excel Proficiency 5 — Questions and Answers
Question 1: Which Excel function returns the largest value in a range?
- LARGE
- MAX (Correct answer)
- UPPER
- TOP
Correct answer: MAX
MAX scans a range and returns the highest numeric value found, ignoring text and empty cells.
Question 2: A formula in C1 reads =A1+B1. When you copy this formula to C2, what does it become?
- =A1+B1
- =A2+B2 (Correct answer)
- =$A$1+$B$1
- =A1+B2
Correct answer: =A2+B2
Relative references shift by the same number of rows/columns as the copy distance, so copying down one row adjusts row numbers by one.
Question 3: What is the purpose of the SUMPRODUCT function?
- Sums all products in a catalog list
- Multiplies corresponding elements in arrays and returns the sum of those products (Correct answer)
- Returns the largest product of any two values in a range
- Creates a multiplication table for two ranges
Correct answer: Multiplies corresponding elements in arrays and returns the sum of those products
SUMPRODUCT multiplies corresponding elements across multiple arrays and then sums all the resulting products.
Question 4: Which option under Paste Special allows you to paste only the calculated results of formulas, not the formulas themselves?
- Paste All
- Paste Formulas
- Paste Values (Correct answer)
- Paste Formats
Correct answer: Paste Values
Paste Values pastes only the current numeric or text results of formulas, stripping out the underlying formula.
Question 5: In Excel, what does the TRIM function do?
- Shortens text to a specified number of characters
- Removes all leading, trailing, and extra internal spaces from text (Correct answer)
- Deletes empty rows from a range
- Cuts the selected cell content to the clipboard
Correct answer: Removes all leading, trailing, and extra internal spaces from text
TRIM removes leading and trailing spaces and reduces multiple internal spaces to a single space, cleaning up imported text.
Question 6: A user wants to restrict data entry in a cell to whole numbers between 1 and 100. Which feature should they use?
- Conditional Formatting
- Data Validation (Correct answer)
- Cell Protection
- Named Ranges
Correct answer: Data Validation
Data Validation lets you define rules that restrict what values can be entered in a cell, including numeric ranges.
Question 7: Which keyboard shortcut opens the Format Cells dialog box in Excel?
- Ctrl+1 (Correct answer)
- Ctrl+F
- Alt+Enter
- Ctrl+Shift+F
Correct answer: Ctrl+1
Ctrl+1 opens the Format Cells dialog, which provides access to number formats, alignment, font, borders, and fill settings.
Robert Half Assessment Test Microsoft Excel Proficiency 5
Which Excel function returns the largest value in a range?