In Excel, the formula =SUM(Sheet2:Sheet5!B3) will: MCQ with Answer and Explanation

In Excel, the formula =SUM(Sheet2:Sheet5!B3) will:
A. Sum range B3 on the active sheet
B. Sum cell B3 from Sheet2 through Sheet5
C. Cause an error because of incorrect syntax
D. Sum all cells named Sheet2 and Sheet5
Answer: Option B
Solution (By JKExamLibrary)
This 3-D reference sums the same cell across multiple worksheets.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
Which of the following is NOT a valid text wrapping option in MS Word?
A. Square
B. Tight
C. Behind Text
D. Circular

Correct Answer: Option D


Explanation:
Circular is not a wrapping style. Valid: In line with text, Square, Tight, Through, Top and Bottom, Behind Text, In Front of Text.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which command is used to remove all manual character formatting in Word?
A. Ctrl + Q
B. Ctrl + Spacebar
C. Ctrl + Shift + N
D. Ctrl + Shift + Z

Correct Answer: Option B


Explanation:
Ctrl + Spacebar clears character formatting (font, size, etc.). Ctrl + Q clears paragraph formatting.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In MS Excel, what does the 'Merge & Center' option do?
A. Merges selected cells into one and centers the content
B. Splits merged cells
C. Merges cells without centering
D. Centers text without merging

Correct Answer: Option A


Explanation:
Merge & Center combines the selected cells into a single cell and centers the text horizontally.

This question belongs to: Computer Microsoft Office