In Excel, what does the '&' operator do? MCQ with Answer and Explanation

In Excel, what does the '&' operator do?
A. Raises to power
B. Concatenates text strings
C. Performs logical AND
D. Adds numbers
Answer: Option B
Solution (By JKExamLibrary)
& joins text.

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, to add a border to a page, go to:
A. Insert -> Borders
B. Layout -> Borders
C. Design -> Page Borders
D. Home -> Borders

Correct Answer: Option C


Explanation:
Page Borders is under Design tab.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which transition or animation effect property in MS PowerPoint allows an animation to start at the exact same time as the previous animation item?
A. Trigger
B. On Click
C. After Previous
D. With Previous

Correct Answer: Option D


Explanation:
The 'With Previous' setting starts the selected animation effect simultaneously with the animation immediately preceding it on the slide timeline.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which of the following database tools in MS Access is designed to summarize, group, and format table information for clear paper printing or digital distribution?
A. Form
B. Macro asset
C. Report
D. Query setup

Correct Answer: Option C


Explanation:
Reports are specialized database objects used to organize, summarize, and format data from tables or queries for printing or professional distribution.

This question belongs to: Computer Microsoft Office