Which Excel feature allows you to automatically fill cells with a series (e.g., 1,2,3 or Mon,Tue,Wed)? MCQ with Answer and Explanation

Which Excel feature allows you to automatically fill cells with a series (e.g., 1,2,3 or Mon,Tue,Wed)?

A. Data Validation

B. AutoFill handle

C. Flash Fill

D. Goal Seek

Answer: Option B

Dragging the fill handle (small square at bottom-right) creates series. Flash Fill detects patterns.

This question belongs to: Computer Microsoft Office

No comments yet. Be the first to start the discussion!

Question #1 Report Error

In Excel, which function is used to return the number of rows in a range?

A. ROWS

B. COLUMNS

C. ROW

D. COUNT

Correct Answer: Option A

Explanation:
ROWS returns the count of rows in a reference. ROW returns the row number of a reference. COLUMNS returns column count.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

What does the F4 key do in MS Excel after applying a format?

A. Repeats the last action (e.g., formatting)

B. Closes the current workbook

C. Toggles between absolute and relative reference in a formula

D. Opens the Format Cells dialog

Correct Answer: Option A

Explanation:
F4 repeats the last command or action. In a formula editing mode, F4 cycles reference types.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In PowerPoint, the 'Compare' feature allows:

A. Merging two presentations and reviewing changes

B. Comparing two slide transitions

C. Comparing file sizes

D. Comparing fonts

Correct Answer: Option A

Explanation:
Compare (Review tab) merges presentations.

This question belongs to: Computer Microsoft Office