1 |
Range of cells from C2 to C100 is referenced as: |
C2-100
C2:C100
C2 to C100
C2:100
|
2 |
Symbol is used before formula: |
&
=
#
$
|
3 |
____ menu contains the 'Name' command: |
File
View
Insert
Format
|
4 |
The absolute reference of cell address A15 is written as: |
$A15
$A15$
A$15
$A$15
|
5 |
_____ is an absolute address: |
A1
A1$
A$1$
None
|
6 |
A mathematical expression that is used to perform calculation on worksheet is called: |
Cell
Format
Formula
Address
|
7 |
Which of the following is an absolute address? |
A1
A1$
$A$1
None of these
|
8 |
To add the value of cell 'C9' of worksheet "Sheet3" with the cell 'B2' of current worksheet, the formula is written as: |
=C9+B2
=Sheet3!C9+B2
=Sheet3!B2+C9
=Sheet3!B2+sheet3!C9
|
9 |
Formula can only be applied on: |
Values
Labels
Unmerged cells
None
|
10 |
For a currency format cell, the number 461.593 will be displayed as: |
461.593
$4615.19
$46159.3
$461.59
|
11 |
If the custom format is ###.000 then the number 16.3 will be displayed as: |
016.3
16.30
16.300
16.3
|
12 |
If the custom format is ##.### then the number 23349 will be displayed as: |
167.00
23.349
16.300
16.3
|
13 |
If the custom format is 00000 then the number 420 will be displayed as: |
420
0420
00420
420.00
|
14 |
The default number format assigned to a cell is: |
Currency
Number
Text
General
|
15 |
Each number of format consist of _______ part: |
2
3
4
5
|