Spreadsheets-grade-10

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