Microsoft Excel Excel MCQ 3 — Questions and Answers
Question 1: Which Excel feature allows you to automatically fill a series of data (e.g., Jan, Feb, Mar) by dragging?
- AutoSum
- Flash Fill
- AutoFill (Correct answer)
- AutoComplete
Correct answer: AutoFill
AutoFill recognizes patterns and extends a series when you drag the fill handle.
Question 2: What is the purpose of the IFERROR function?
- Prevents formulas from being entered
- Returns a specified value if a formula produces an error (Correct answer)
- Highlights cells that contain errors
- Converts error values to zero
Correct 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.
Question 3: Which Excel function combines text from multiple cells into one?
- JOIN
- MERGE
- CONCATENATE (Correct answer)
- COMBINE
Correct answer: CONCATENATE
CONCATENATE (or & operator / CONCAT in newer versions) joins text strings from multiple cells.
Question 4: What does pressing Ctrl + Z do in Excel?
- Redo the last action
- Undo the last action (Correct answer)
- Save the workbook
- Zoom in on the spreadsheet
Correct answer: Undo the last action
Ctrl + Z undoes the most recent action in Excel.
Question 5: Which function returns the largest value in a set of values?
- LARGE
- MAX (Correct answer)
- UPPER
- CEILING
Correct answer: MAX
MAX returns the maximum (largest) value from a list of numbers or a range.
Question 6: What happens when you freeze panes in Excel?
- The spreadsheet becomes read-only
- Selected rows or columns remain visible while scrolling (Correct answer)
- All formulas are converted to values
- The workbook is saved automatically
Correct 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.
Question 7: Which Excel function extracts a specified number of characters from the left side of a text string?
- MID
- LEFT (Correct answer)
- FIND
- TEXT
Correct answer: LEFT
LEFT(text, num_chars) returns the specified number of characters from the beginning of a text string.
Microsoft Excel Excel MCQ 3
Which Excel feature allows you to automatically fill a series of data (e.g., Jan, Feb, Mar) by dragging?