MS Excel MCQs
1) The other name for MS Excel is :
a) Spreadsheet
b) Long sheet
c) Gridlines sheet
d) None of these
2) It contains rows and columns and used to record/compare numerical, financial data.
a) MS Word
b) MS Powerpoint
c) Spreadsheet
d) MS Access
3) It is smallest unit/ element of the worksheet in which the data is entered.
a) Box
b) Rectangle
c) cell
d) Both A and C
4) A group of cells arranged vertically is called :
a) Row
b) Cell
c) Column
d) Table
5) A group of cells that are arranged horizontally are called :
a) Cell
b) Row
c) Column
d) All of these
6) The by default file name of MS Excel is :
a) Presentation 1
b) Book 1
c) Document 1
d) Untitled Paint
7) In Excel there are total …………………….. columns and ……………………. Rows
a) 10,48,576, 16,386
b) 10,48,756, 18,636
c) 1,48,576 , 38,686
d) 1,04,857 , 16,683
8) In MS Excel, rows are named ……………………. and columns are named as ……………………………
a) 1,2,3,4 , A,B,C,D
b) i, ii, iii, iv , a, b, c, d
c) I, II, III, IV, A, B, C,
D d) None of these
9) A cell that is referred by its column name and row number is called :
a) Cell place
b) Cell location
c) Cell venue
d) Cell address
10) It the currently selected cell :
a) Working cell
b) active cell
c) Live cell
d) All of these
11) It helps us perform calculations using formulae that are already defined.
a) Formula
b) Feature
c) Function
d) Option
12) It is pre-defined ,and helps us to perform calculations :
a) Formula
b) Feature
c) Function
d) Option
13) It is compulsory used at the very beginning of every formula in your worksheet
a) : (Colon Sign)
b) ; (Semi-colon sign)
c) ? (Question mark sign)
d) = (Equal sign)
14) Sum, Min, Max, Today, Average etc are the examples of :
a) Formula
b) Feature
c) Function
d) Option
15) MS Excel provides us by default ………….. worksheets for us to work on
a) 5
b) 1
c) 4
d) 3
Answer Keys
|
1 |
A |
| 2 |
C |
|
3 |
C |
| 4 |
C |
|
5 |
B |
| 6 |
B |
|
7 |
A |
| 8 |
A |
|
9 |
D |
| 10 |
B |
|
11 |
C |
| 12 |
A |
|
13 |
D |
| 14 |
C |
|
15 |
D |
