Microsoft Excel Proficiency Flashcards
7 cards from real Robert Half Assessment Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Microsoft Excel Proficiency flashcards as text
Which Excel function returns the largest value in a range?
Answer: MAX
MAX scans a range and returns the highest numeric value found, ignoring text and empty cells.
A formula in C1 reads =A1+B1. When you copy this formula to C2, what does it become?
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.
What is the purpose of the SUMPRODUCT function?
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.
Which option under Paste Special allows you to paste only the calculated results of formulas, not the formulas themselves?
Answer: Paste Values
Paste Values pastes only the current numeric or text results of formulas, stripping out the underlying formula.
In Excel, what does the TRIM function do?
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.
A user wants to restrict data entry in a cell to whole numbers between 1 and 100. Which feature should they use?
Answer: Data Validation
Data Validation lets you define rules that restrict what values can be entered in a cell, including numeric ranges.
Which keyboard shortcut opens the Format Cells dialog box in Excel?
Answer: Ctrl+1
Ctrl+1 opens the Format Cells dialog, which provides access to number formats, alignment, font, borders, and fill settings.