In Excel, to name a range, you can: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, to name a range, you can:

A. Formulas -> Define Name

B. Select range, type name in Name Box and press Enter

C. Insert -> Name

D. Both A and B

Answer: Option D

Solution (By JKSSB Mock Tests)

Both methods work.

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, to open a form in read-only mode (preventing edits), set the form's property:

A. Record Locks to All Records

B. Data Entry to Yes

C. Enabled to No

D. Allow Edits to No

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Setting Allow Edits, Allow Deletions, Allow Additions to No makes the form read-only.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the keyboard shortcut to cut selected content in MS Office?

A. Ctrl + C

B. Ctrl + V

C. Ctrl + X

D. Ctrl + Z

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl + X cuts (removes) the selection and places it on the clipboard. Ctrl + C copies, Ctrl + V pastes, Ctrl + Z undoes.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the function of the keyboard shortcut Ctrl + W across Microsoft Office applications like Word and Excel?

A. Launches the web browser lookup helper tool

B. Closes the currently active document or workbook window

C. Exits the entire parent software application system

D. Saves the file and opens a blank document layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + W closes the currently active file, document, or workbook window without closing the main parent application shell. Alt + F4 exits the entire application.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs