In Excel, the intersection operator is: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the intersection operator is:

A. Comma (,)

B. Space

C. Semicolon (;)

D. Colon (:)

Answer: Option B

Solution (By JKSSB Mock Tests)

A space between two ranges returns their intersection. Comma is union, colon is range.

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, what does the '&' operator do?

A. Raises to power

B. Concatenates text strings

C. Adds numbers

D. Performs logical AND

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
& joins text.

This question belongs to: Computer Microsoft Office

Question #2

Which Access object is used to automate repetitive tasks without writing code?

A. Macro

B. Module

C. Report

D. Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Macros automate tasks via a simplified interface. Modules contain VBA code.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the error '#REF!' indicates:

A. Division by zero

B. Invalid cell reference (cell may have been deleted)

C. Formula name not recognized

D. Wrong data type

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
#REF! means a reference is invalid. #DIV/0! division by zero, #NAME? unrecognized text, #VALUE! wrong type.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs