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

Question

Share Report Error

In Excel, what does the '&' operator do?

A. Performs logical AND

B. Adds numbers

C. Raises to power

D. Concatenates text strings

Answer: Option D

Solution (By JKSSB Mock Tests)

& joins text.

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

Share Report

In MS Access, to import data from an Excel file, you can use:

A. External Data tab -> Import Excel

B. Create tab -> Table from Excel

C. Database Tools -> Import

D. Home tab -> Get External Data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The External Data tab provides import and link options.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which field property in MS Access ensures that a user cannot leave a specific field blank when entering a new database record?

A. Indexed

B. Validation Rule

C. Required

D. Input Mask

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Setting the 'Required' property to 'Yes' forces the user to enter data into that specific field before saving the record.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to open the 'Font' dialog box in MS Word?

A. Alt + O, F

B. Ctrl + F

C. Ctrl + D

D. Ctrl + Shift + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + D opens the Font dialog box in Word. Ctrl + F opens Find, Ctrl+Shift+F opens the Font dialog as well (but less common), Alt+O,F is menu navigation. However, Ctrl+D is the standard shortcut.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs