1 |
Which of the following function is used to get current data is MS-Excel |
Year
Today
Month
Exact
|
2 |
The correct column address is; |
AB
15
3D
D3
|
3 |
Every all of a worksheet has a unique; |
Row
Column
Address
Both a & b
|
4 |
Calling cells by just their address (such as "A1") is called. |
Relative referencing
Absolute referencing
Calling Method
None
|
5 |
For the custom format ##.000, the number 242.59 will appear as; |
242.59000
24.2590
242.59
None
|
6 |
A worksheet contains________ rows. |
65536
256
173214
None
|
7 |
Which of the following functions is used to get the current date? |
Exact ()
Today ()
Month ()
Year ()
|
8 |
Formula can be applied on: |
Values
Labels
Unmerged Cells
None
|
9 |
The actual working area in Excel is; |
Workbook
Worksheet
Spreadsheet
Notesheet
|
10 |
Which of the following is a spreadsheet? |
MS-Word
Ms-Excel
Ms-Powerpoint
Both a & b
|
11 |
By default how many worksheets are present in MS-Excel workbook? |
3
4
5
None
|
12 |
A formula in MS-Excel begins with symbol. |
+
-
=
/
|
13 |
Group of worksheet is called; |
Cell
Workbook
Bar
Status
|
14 |
Which of the following is an absolute address; |
A1
A1$
A$1$
None
|
15 |
Each cell in a spreadsheet has a unique; |
Row
Column
Address
Row and column
|