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

Question

Share Report Error

In Excel, the intersection operator is:

A. Semicolon (;)

B. Comma (,)

C. Space

D. Colon (:)

Answer: Option C

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 MS Access, a query that groups data and calculates sums, averages, or counts is known as:

A. Totals query

B. Crosstab query

C. Select query

D. Parameter query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Totals query (using Group By, Sum, Avg, etc.) aggregates data. Crosstab query also aggregates but in a cross-tab format.

This question belongs to: Computer Microsoft Office

Question #2

To insert a new slide in PowerPoint, which shortcut is used?

A. Ctrl + N

B. Ctrl + D

C. Ctrl + I

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + M inserts a new slide. Ctrl + N creates a new presentation, Ctrl + D duplicates the selected slide.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the function =CHOOSE(2, "Red", "Green", "Blue") returns:

A. Error

B. Blue

C. Green

D. Red

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
CHOOSE returns the 2nd value: Green.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs