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

Question Report Error

In Excel, the intersection operator is:

A. Comma (,)

B. Semicolon (;)

C. Colon (:)

D. Space

Answer: Option D

Solution (By JKExamLibrary)

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

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In MS Word, 'Text Effects and Typography' is available under:

A. Both A and B

B. Design tab

C. Insert tab -> WordArt

D. Home tab -> Font group

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Text Effects button is in the Font group on Home tab (glowing A).

This question belongs to: Computer Microsoft Office

Question #2 Report Error

What is the default font and size in MS Word 2016?

A. Calibri, 12 pt

B. Times New Roman, 12 pt

C. Arial, 10 pt

D. Calibri, 11 pt

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Default font is Calibri 11 pt since Word 2007.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In PowerPoint, which shortcut key is used to insert a new comment?

A. Ctrl + Shift + M

B. Ctrl + Alt + M

C. Ctrl + M

D. Alt + M

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Ctrl+Alt+M inserts comment.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs