Microsoft Excel MCQs for Competitive Examination
Q. 1
How are data organised in a spreadsheet?
(A) Lines and spaces
(B) Layers and planes
(C) Height and weight
(D) Rows and columns
Answer: (D) Rows and column
Explanation: N/A
Q. 2
The basic unit of a worksheet into which you enter data in Excel is called a
(A) Tab
(B) Cell
(C) Range
(D) Box
Answer: (B) Cell
Explanation: N/A
Q. 3
In excel, = Sum(B1 : B2) is an example of a
(A) Function
(B) Cell address
(C) Formula
(D) Value
Answer: (C) Formula
Explanation: N/A
Q. 4
Which of the following is not a valid formula in Microsoft Excel?
(A) = A2 + A1
(B) = A2 + 1
(C) = 1 + A2
(D) =1A + 2
Answer: (D) =1A + 2
Explanation: N/A
Q. 5
All of the following terms are related to spreadsheet software except
(A) Worksheet
(B) Cell
(C) Virus detection
(D) Formula
Answer: (C) Virus detection
Explanation: N/A
Q. 6
Which of the following is not a spreadsheet software?
(A) Snowball
(B) Apple numbers
(C) Microsoft Access
(D) Lotus 1-2-3
Answer: (C) Microsoft Access
Explanation: N/A
Q. 7
In Excel, the name of the current sheet is shown on
(A) Title bar
(B) Ribbon
(C) Status bar
(D) Menu bar
Answer: (A) Title bar
Explanation: N/A
Q. 8
Which of the following is not a function in MS-Excel?
(A) SUM
(B) AVG
(C) MAX
(D) MIN
Answer: (B) AVG
Explanation: N/A
Q. 9
A function in MS-Excel must begin with
(A) =
(B) @
(C) *
(D) ()
Answer: (A) =
Explanation: N/A
Q. 10
In Excel, columns are labelled as
(A) A, B, C etc.
(B) 1, 2, 3 etc.
(C) A1, A2, A3 etc.
(D) A1, B1, C! etc.
Answer: (A) A, B, C etc.
Explanation: N/A
Q. 11
What is the shortcut key to enter the current time in excel?
(A) Ctrl + Shift + ;
(B) Ctrl + ;
(C) Ctrl + Alt + ;
(D) Ctrl + Shift + T
Answer: (A) Ctrl + Shift + ;
Explanation: N/A
Q. 12
What is the shortcut key to enter the current date in excel?
(A) Ctrl + Alt + T
(B) Ctrl + D
(C) Ctrl + Shift + ;
(D) Ctrl + ;
Answer: (D) Ctrl + ;
Explanation: N/A
Q. 13
What does an electronic spreadsheet consist of?
(A) Rows
(B) Columns
(C) Cells
(D) All of these
Answer: (D) All of these
Explanation: N/A
Q. 14
The letter and number of the intersecting column and row is the
(A) Cell location
(B) Cell position
(C) Cell address
(D) Cell contents
Answer: (C) Cell address
Explanation: N/A
Q. 15
MS-Excel is used for
(A) Letter writing
(B) Spreadsheet calculation
(C) Presentation
(D) Painting
Answer: (B) Spreadsheet calculation
Explanation: N/A
Q. 16
We can add chart from which of the following menu?
(A) Home
(B) Insert
(C) View
(D) Review
Answer: (B) Insert
Explanation: N/A
Q. 17
Which of the following is not a cell address in MS-Excel?
(A) A3
(B) AB9
(C) AA1
(D) A1B1
Answer: (D) A1B1
Explanation: N/A
Q. 18
In excel, a collection of worksheets is called
(A) Excel book
(B) Worksheet
(C) Excel sheets
(D) Workbook
Answer: (D) Workbook
Explanation: N/A
Q. 19
The process of joining two or more cell is called
(A) Wrap
(B) Merge
(C) Sort
(D) Align
Answer: (B) Merge
Explanation: N/A
Q. 20
In Excel, rows are labelled as
(A) A, B, C etc.
(B) 1, 2, 3 etc.
(C) A1, A2, A3 etc.
(D) A1, B1, C! etc.
Answer: (B) 1, 2, 3 etc.
Explanation: N/A