NEW
Font size
WorksheetsSpreadsheets-grade-10
Total questions: 12
Worksheet time: 6mins
In__________referencing the relative address of the cell gets adjusted with respect to the current cell.
Relative
Absolute
Mixed
Nil
To create an absolute cell reference ___________ sign is used before the parts of formula.
#
$
*
=
cell address A4 in a formula means it is a
Mixed cell reference
Absolute cell reference
Relative cell reference
All the above
cell address $A4 in a formula means it is a
Mixed cell reference
Absolute cell reference
Relative cell Reference
All the above
Cell address $A$4 in a formula means it is a
Absolute cell reference
Mixed cell reference
Relative cell reference
None of these
cell address A$4 in a formula means it is a
Relative reference
Mixed Reference
Absolute Reference
None of these
How would you refer to the range starting from 2nd column , 2nd row and spread till 6th column and 3rd row?
[E3:A1]
[A2:E3]
[B2:F3]
[A1:F3]
The formula in cell A2 is B2+C3.On copying this formula to cell C2, the formula in cell C2 will be.
=B2+C3
=C3+B2
=D2+E3
=E3+D2
Cancel button(x on formula bar) can be used to undo a cell entry after it has been completed?
True
False
Under what menu will you find the Sort command?
Edit
Format
Insert
Data
Under what menu will you find the merge cells command?
Sort
Data
Format
Insert
Cell referencing technique in which cells are referred to by their relative position in the worksheet?
Mixed referencing
Relative cell referencing
Absolute cell referencing
