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
What does the IFERROR function do in Excel?
Answer: Returns a specified value when a formula produces an error
IFERROR evaluates an expression and returns a custom result if it produces any error, otherwise returns the expression's value.
A spreadsheet column contains 'New York' in some cells and 'new york' in others. Which function would standardize them all to 'New York'?
Answer: PROPER
PROPER capitalizes the first letter of each word, converting 'new york' to 'New York'.
Which PivotTable feature allows you to display subtotals for sub-groups within a category?
Answer: Subtotals option
The Subtotals option in PivotTable design controls whether and where subtotal rows appear for each grouping.
What happens when you use the Remove Duplicates feature on a dataset in Excel?
Answer: One copy of each duplicate row is kept and others are permanently deleted
Remove Duplicates retains the first occurrence of each unique row and permanently deletes all subsequent duplicates.
Which formula correctly calculates the number of workdays between January 1 and January 31, 2024, excluding weekends?
Answer: =NETWORKDAYS("1/1/2024","1/31/2024")
NETWORKDAYS counts the number of whole working days between two dates, automatically excluding Saturdays and Sundays.
What is the purpose of Freeze Panes in Excel?
Answer: Locks rows or columns so they remain visible when scrolling
Freeze Panes locks specified rows or columns in place so headers stay visible as you scroll through large datasets.
Which Excel function converts a text string that looks like a number into an actual numeric value?
Answer: VALUE
VALUE converts a text string representing a number into an actual number that can be used in calculations.