Excel MCQ Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Excel MCQ flashcards as text
Which Excel feature allows you to automatically fill a series of data (e.g., Jan, Feb, Mar) by dragging?
Answer: AutoFill
AutoFill recognizes patterns and extends a series when you drag the fill handle.
What is the purpose of the IFERROR function?
Answer: Returns a specified value if a formula produces an error
IFERROR evaluates a formula and returns a custom value instead of displaying an error message.
Which Excel function combines text from multiple cells into one?
Answer: CONCATENATE
CONCATENATE (or & operator / CONCAT in newer versions) joins text strings from multiple cells.
What does pressing Ctrl + Z do in Excel?
Answer: Undo the last action
Ctrl + Z undoes the most recent action in Excel.
Which function returns the largest value in a set of values?
Answer: MAX
MAX returns the maximum (largest) value from a list of numbers or a range.
What happens when you freeze panes in Excel?
Answer: Selected rows or columns remain visible while scrolling
Freezing panes locks specific rows or columns so they stay visible as you scroll through the worksheet.
Which Excel function extracts a specified number of characters from the left side of a text string?
Answer: LEFT
LEFT(text, num_chars) returns the specified number of characters from the beginning of a text string.