Home / Programming Questions / Microsoft Excel MCQs / Page 40

Microsoft Excel MCQs with answers Page - 40

Dear candidates you will find MCQ questions of Microsoft Excel here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel 3-D reference in a formula

(A) Cannot be modified
(B) Only appears on summary worksheets
(C) Limits the formatting options
(D) Spans worksheets

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel the auto calculate feature

(A) Can only add values in a range of cells
(B) Provides a quick way to view the results of an arithmetic operation on a range of cells
(C) Automatically creates formulas and adds them to a worksheet
(D) None of the above

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu

(A) Edit
(B) Format
(C) Tools
(D) Data

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

(A) Edit
(B) Insert
(C) Format
(D) Tools

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel which of the following is not a worksheet design criterion

(A) Efficiency
(B) Auditability
(C) Description
(D) Clarity Correct Answer:

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel to copy cell contents using drag and drop, press the

(A) End key
(B) Shift key
(C) Esc key
(D) None of above

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel if you press …….., the cell accepts your typing as its contents.

(A) Enter
(B) Ctrl + Enter
(C) TAB
(D) Insert

M

Mr. Dubey • 51.17K Points
Coach

Q. In Excel the auto fill feature

(A) Extends a sequential series of data
(B) Automatically adds a range of cell values
(C) Applies a boarder around selected cells
(D) None of above

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.