Page 29 - Viva ICSE Computer Studies 8 : E-book

Cell Reference to Another Worksheet

Excel provides the facility to use cell reference of
one worksheet in another worksheet.

Let’s learn this concept with an example.
1. Enter the data in Sheet 1 as shown. We will
be using the cell address ‘D6’ of Sheet 1 in
Sheet 2. Step 1

2. Enter the data in Sheet 2 as shown. Select an
empty cell in Sheet 2 and type = sheet 1! D6.
Press the Enter key and the value of D6 from
Sheet 1 will be displayed in the desired cell.
Step 2

Error Result

You might get errors while performing calculations in Excel as the formulae entered can have
some problems. Some of the common error results are discussed here.

# N/A: Data is not available.

# VALUE!: The formula contains an invalid
operation.

# DIV/0!: Division by zero is being performed.

####: The column is not enough to display the
number.

#NAME?: Excel does not recognise the text in a
formula.

17