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 cell B3 from Sheet2 through Sheet5

B. Sum all cells named Sheet2 and Sheet5

C. Sum range B3 on the active sheet

D. Cause an error because of incorrect syntax

Answer: Option A

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

Share Report

Which property under an MS Access query design matrix allows database administrators to filter records to show only those matching a specific range, such as values between 100 and 500?

A. Sort Row

B. Show checkbox parameter

C. Field Identifier alignment

D. Criteria Row

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Criteria row in the Query Design grid is where you input logical expressions (such as 'Between 100 And 500') to filter the records extracted from the database.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, which of the following is used to insert a comment?

A. All of the above

B. Review > New Comment

C. Insert > Comment

D. Ctrl + Alt + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can insert a comment via Review > New Comment, or Insert > Comment (in some versions), or the shortcut Ctrl+Alt+M. So all are valid.

This question belongs to: Computer Microsoft Office