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. Logical AND

B. Error

C. Sum of A1 and B1

D. Concatenation of values in A1 and B1 without space

Answer: Option D

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

In MS Access, which object is used to create a formatted printout of data?

A. Query

B. Form

C. Table

D. Report

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Reports are designed for printing data in a formatted layout. Forms are for data entry, queries for retrieval, tables for storage.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In PowerPoint, the 'Gridlines' option helps to:

A. Draw shapes

B. Create a table

C. Align objects precisely on the slide

D. Add a chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Gridlines are non-printing lines for alignment.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What will be the output of the MS Excel formula =COUNTIF(A1:A4, >10) if cell entries are A1=5, A2=10, A3=15, and A4=20?

A. 1

B. 2

C. 3

D. 4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The formula filters for numbers strictly greater than 10. Out of the given values, 15 and 20 satisfy the condition, so the function returns 2.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs