In Excel, to quickly copy a formula down to adjacent cells, double-click: MCQ with Answer and Explanation

In Excel, to quickly copy a formula down to adjacent cells, double-click:
A. The fill handle of the cell
B. The cell border
C. The formula bar
D. The column header
Answer: Option A
Solution (By JKSSB Mock Tests)
Double-clicking the fill handle copies the formula down as far as contiguous data in the adjacent column.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which native view layout option in MS Word strips out all pagination, margins, headers, and backgrounds, displaying text lines as a continuous flat page layout similar to a web browser window?
A. Read Mode view
B. Print Layout View
C. Draft structural mode
D. Web Layout View

Correct Answer: Option D


Explanation:
Web Layout view wraps text lines to match the boundaries of the application window, hiding physical page breaks and structural margin configurations.

This question belongs to: Computer Microsoft Office
Question #2
To select an entire paragraph in MS Word, you can:
A. Shift + Click
B. Triple-click anywhere in the paragraph
C. Ctrl + Click
D. Double-click the paragraph

Correct Answer: Option B


Explanation:
Triple-click selects the whole paragraph.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, what does the formula =SUMIF(A1:A10, ">5") do?
A. Returns error
B. Sums all values and adds 5
C. Counts cells greater than 5
D. Sums values in A1:A10 that are greater than 5

Correct Answer: Option D


Explanation:
SUMIF with criteria ">5" sums cells >5 in the range.

This question belongs to: Computer Microsoft Office