In Excel, the formula =A1&B1 will result in: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the formula =A1&B1 will result in:

A. Sum of A1 and B1

B. Logical AND

C. Concatenation of values in A1 and B1 without space

D. Error

Answer: Option C

Solution (By JKSSB Mock Tests)

& concatenates 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

What is the maximum zoom scale percentage supported natively within the workspace window of Microsoft Excel?

A. 200%

B. 500%

C. 1000%

D. 400%

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
MS Excel and MS PowerPoint support a maximum zoom scale of 400%, while MS Word allows zooming up to 500%.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, which of the following is a valid animation effect category?

A. All of the above

B. Entrance

C. Emphasis

D. Exit

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Entrance, Emphasis, and Exit are the main animation categories.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, a 'Macro' is used to:

A. Import external data

B. Create reports

C. Automate a series of actions without writing VBA code

D. Store data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Macros provide a simplified automation tool.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs