MCQs with Solutions for all Competitive Examinations

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?


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

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