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. Shift + Enter

B. Enter

C. Alt + 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

Share Report

What is the shortcut key used to display the traditional 'Save As' file dialog window directly in MS Word and Excel?

A. Ctrl + S

B. F12

C. Alt + F2

D. Shift + F12

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The F12 function key opens the 'Save As' dialog box directly, allowing users to save files under alternative names, extensions, or file directories.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to calculate the payment for a loan based on constant payments and interest rate, but for a given number of periods?

A. NPER

B. RATE

C. PV

D. PMT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
PMT calculates the periodic payment. NPER calculates number of periods, PV present value, RATE interest rate.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, which function finds the smallest number in a range?

A. MIN()

B. MAX()

C. SMALL()

D. LOWER()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MIN returns the smallest numeric value. SMALL returns the k-th smallest. LOWER converts text to lowercase.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs