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

Question

Share Report Error

In Excel, the formula =SUM(Sheet2:Sheet5!B3) will:

A. Sum range B3 on the active sheet

B. Sum all cells named Sheet2 and Sheet5

C. Sum cell B3 from Sheet2 through Sheet5

D. Cause an error because of incorrect syntax

Answer: Option C

Solution (By JKSSB Mock Tests)

This 3-D reference sums the same cell across multiple worksheets.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In Excel, which function returns the current date without time?

A. =NOW()

B. =TODAY()

C. =DATE()

D. =CURRENTDATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
TODAY() returns the current date (without time). NOW() returns date and time. DATE creates a date from components. CURRENTDATE is not a function.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which of the following is used to create a dynamic cross-reference to a heading, footnote, or caption?

A. Hyperlink

B. Bookmark

C. Cross-reference

D. Comment

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Cross-reference creates a link to an item like a heading, figure, or footnote, updating the reference number when the target changes. Hyperlink is a web link, Bookmark marks a location, Comment adds notes.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function would you use to find the position of 'at' in the text 'Education'?

A. Both A and B

B. SEARCH("at", "Education")

C. FIND("at", "Education")

D. MATCH("at", "Education")

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both SEARCH and FIND return the starting position. SEARCH is case-insensitive, FIND is case-sensitive.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs