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. Colon (:)

D. Space

Answer: Option D

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 Word, what does the 'Gutter Margin' property refer to?

A. The bottom layout margin reserved for footnote entries.

B. The extra margin space added to the binding side of a document to prevent text coverage during binding.

C. The empty space located at the outer margins of headers.

D. The vertical spacing buffer separating two columns of text data.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A gutter margin adds extra space to the side or top margin of a document intended for binding, ensuring that text remains fully visible and readable after the document is bound.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type automatically inserts a unique sequential number?

A. AutoNumber

B. Text

C. Number

D. Calculated

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AutoNumber increments automatically.

This question belongs to: Computer Microsoft Office

Question #3

The shortcut to open the 'Page Setup' dialog in MS Excel is:

A. F12

B. Ctrl + P

C. Alt + P, S, P (or Page Layout tab)

D. Ctrl + F2

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
No direct single shortcut; you can use Alt+P, S, P. Or from Page Layout tab. I'll ask: Which tab contains Page Setup group? Answer: Page Layout. So I'll adjust.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs