Home / Programming Questions / Microsoft Excel MCQs / Page 37

# Microsoft Excel MCQs with answers Page - 37

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.

V

Vishal Gupta • 7.73K Points
Tutor III

## `Q. To center worksheet titles across a range of cells, you must`

(A) Widen the columns
(B) Select the cells containing the title text plus the range over which the title text is to be centered
(C) Select the cells containing the title text plus the range over which the title text is to be enfettered
(D) Format the cells with the comma style

V

Vishal Gupta • 7.73K Points
Tutor III

## `Q. Which option allows you to Bold all the negative values within the selected cell range:`

(A) Zero Formatting
(B) Conditional Formatting
(C) Compare Formatting
(D) Negative Formatting

V

Vishal Gupta • 7.73K Points
Tutor III

## `Q. What is the shortcut key to insert new sheet in current workbook?`

(A) F11
(B) Alt + F11
(C) Ctrl + F11
(D) Shift + F11

V

Vishal Gupta • 7.73K Points
Tutor III

## `Q. Data can be arranged in a worksheet in a easy to understand manner using`

(A) auto formatting
(B) changing fonts
(C) applying styles
(D) all of above

V

Vishal Gupta • 7.73K Points
Tutor III

## `Q. Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?`

(A) =B1+25
(B) =\$B\$1+25
(C) =1\$B\$+25
(D) =B1:B3

V

Vishal Gupta • 7.73K Points
Tutor III

## `Q. Getting data from a cell located in a different sheet is called:`

(A) Referencing
(B) Accessing
(C) Updating
(D) Functioning

M

Mr. Dubey • 51.17K Points
Coach

## `Q. In Excel default header for a worksheet is`

(B) The date and time
(C) None
(D) The sheet tab name

M

Mr. Dubey • 51.17K Points
Coach

## `Q. In Excel which of the following is not an option in the spelling dialog box`

(A) Edit
(B) Ignore
(C) Ignore all
(D) Change

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.