MCQs with Solutions for all Competitive Examinations

Microsoft Excel MCQs for Competitive Examination

Q. 21
In MS-Excel, predefined formulas are called

(A) Cell
(B) Equation
(C) Function
(D) Symbol

Answer: (C) Function
Explanation: N/A

Q. 22
Intersection of rows and column is called

(A) Cell
(B) Tab
(C) Active cell
(D) Formula

Answer: (A) Cell
Explanation: N/A

Q. 23
How to specify cell range from A1 to A10 in MS-Excel?

(A) (A1, A10)
(B) A1 : A10 
(C) A1 to A10
(D) A1 – A10

Answer: (B) A1 : A10
Explanation: N/A

Q. 24
When you start Excel, by default the opening workbook has the name

(A) Book 1
(B) Sheet 1
(C) Doc 1
(D) Book-1

Answer: (A) Book 1
Explanation: N/A

Q. 25
An Excel workbook is a collection of ______________.

(A) Excel sheet
(B) Chart
(C) Worksheet
(D) Cell

Answer: (C) Worksheet
Explanation: N/A

Q. 26
In Excel, the cell in which you are currently working is known as

(A) Current cell
(B) Active cell
(C) Default cell
(D) None of the above

Answer: (B) Active cell
Explanation: N/A

Q. 27
In Excel, the name box shows

(A) Cell address of the active cell
(B) Cell address of the previously active cell
(C) Name of the workbook currently working on
(D) Contents of the active cell

Answer: (A) Cell address of the active cell
Explanation: N/A

Q. 28
_________________ displays the conents of the active cell.

(A) Name box
(B) Formula bar
(C) Tool bar
(D) Task bar

Answer: (B) Formula bar
Explanation: N/A

Q. 29
The keyboard shortcut to edit a cell in MS-Excel is

(A) F3
(B) F4
(C) F2
(D) F1

Answer: (C) F2
Explanation: N/A

Q. 30
To add the values of cell range from A1 to A5, which of the following function is used?

(A) = SUM(A1 : A5)
(B) = ADD(A1 : A5)
(C) = SUM(A1 + A5)
(D) = SUM(A1 – A5)

Answer: (A) = SUM(A1 : A5)
Explanation: N/A

Q. 31
AutoSum command can be accessed from which menu?

(A) Home
(B) Insert
(C) Formulas
(D) Data

Answer: (C) Formulas
Explanation: N/A

Q. 32
The _______________ function is used to count the number of non-blank values in the selected cell range.


Answer: (A) COUNT
Explanation: N/A

Q. 33
Which function is used to find the maximum value in a cell range?


Answer: (B) MAX
Explanation: N/A

Q. 34
To select the current column, the shortcut key is

(A) Ctrl + Spacebar
(B) Ctrl + A
(C) Shift + Enter
(D) Ctrl + Enter

Answer: (A) Ctrl + Spacebar
Explanation: N/A

Q. 35
A cell entry can be edited in the cell or in the

(A) Menu bar
(B) Edit menu
(C) Formula bar
(D) Function bar

Answer: (C) Formula bar
Explanation: N/A

Q. 36
keyboard shortcut F4 is used to 

(A) Edit the selected cell
(B) Go to a specific cell
(C) Spell check 
(D) Go to the next cell

Answer: (B) Go to a specific cell
Explanation: N/A

Q. 37
The shortcut key to select the entire row is

(A) Ctrl + Space
(B) Shift + Space
(C) Ctrl + A
(D) Shift + A

Answer: (B) Shift + Space
Explanation: N/A

Q. 38
Which command is used to calculate total characters in a cell?

(A) Len
(B) Length
(C) Mid
(D) Sid

Answer: (A) Len
Explanation: N/A

Q. 39
Which sign is used to create an absolute cell reference?

(A) $
(B) @
(C) &
(D) %

Answer: (A) $
Explanation: N/A

Q. 40
Which function is used to find the minimum value in a cell range?


Answer: (D) MIN
Explanation: N/A

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on reddit
Share on whatsapp
Share on email
Share on telegram