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.
(A) COUNT
(B) CNT
(C) TOTAL
(D) COU
Answer: (A) COUNT
Explanation: N/A
Q. 33
Which function is used to find the maximum value in a cell range?
(A) MAXIMUM
(B) MAX
(C) HIGHEST
(D) HIGH
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?
(A) MINIMUM
(B) SMALLEST
(C) MINM
(D) MIN
Answer: (D) MIN
Explanation: N/A