In Excel, to enter the same data into multiple selected cells at once, type the data and press: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, to enter the same data into multiple selected cells at once, type the data and press:

A. Alt + Enter

B. Enter

C. Shift + Enter

D. Ctrl + Enter

Answer: Option D

Solution (By JKSSB Mock Tests)

Ctrl+Enter fills all selected cells with the entered data.

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

In MS Access, the 'Validation Rule' property is used to:

A. Require that a value be entered

B. Set a default value

C. Specify a condition that data must satisfy to be entered

D. Define the input mask pattern

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Validation Rule checks data against an expression (e.g., >=0). Validation Text provides message.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, what field rule dictates whether a database field can accept or store null values?

A. Default Value option

B. Required property

C. Validation Rule

D. Allow Zero Length setting

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When 'Required' is set to 'Yes', the field cannot be left blank or contain a null value when saving records.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, to see the SQL code behind a query, switch to:

A. Datasheet View

B. Design View

C. Layout View

D. SQL View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SQL View displays the SQL statement.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs