In Excel, to protect a worksheet from being edited, you can: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, to protect a worksheet from being edited, you can:

A. View tab -> Lock

B. Home tab -> Format -> Protect

C. Review tab -> Protect Sheet

D. File -> Info -> Protect Workbook

Answer: Option C

Solution (By JKSSB Mock Tests)

Protect Sheet is under Review tab.

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 Access, which of the following is a valid expression for a query criterion?

A. >100

B. Like 'S*'

C. Between #1/1/2020# And #12/31/2020#

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All are valid criteria expressions in Access queries.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which shortcut key opens the 'Find' dialog box in MS Word?

A. Ctrl + G

B. F3

C. Ctrl + H

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + F opens Find. Ctrl + H opens Replace, Ctrl + G opens Go To, F3 repeats last find.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the shortcut key to insert a new worksheet in Excel?

A. Alt + I, W

B. Ctrl + Shift + N

C. Shift + F11

D. Both A and B

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Shift+F11 inserts a new worksheet, and Alt+I,W is the old menu shortcut. So both are valid.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs