What is the shortcut to insert a comment in MS Excel? MCQ with Answer and Explanation

Question

Share Report Error

What is the shortcut to insert a comment in MS Excel?

A. Shift + F2

B. Ctrl + F2

C. F2

D. Alt + F2

Answer: Option A

Solution (By JKSSB Mock Tests)

Shift+F2 inserts or edits a comment in Excel. (In newer versions, Right-click > New Note.)

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 PowerPoint, what is the 'Reading View' used for?

A. Edit slide content

B. Preview the presentation in a window with navigation controls

C. View speaker notes

D. View slide thumbnails

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Reading View plays the slide show in a resizable window.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, what does the formula =TRIM(A1) do?

A. Removes all extra spaces from text except single spaces between words

B. Converts text to proper case

C. Removes all spaces from the text

D. Deletes non-printable characters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
TRIM removes leading, trailing, and repeated spaces. CLEAN removes non-printable characters.

This question belongs to: Computer Microsoft Office

Question #3

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. PV

B. NPER

C. RATE

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

Explore All Microsoft Office MCQs