Page 65 - Viva ICSE Computer Studies 7 : E-book

Performing Calculations

Excel is an application used to perform calculations. It provides diff erent types of formulae in
the Formulas tab. Let’s learn to perform a simple calculation using a simple ‘+’ operator.

Follow these steps to perform calculations.

1. Enter data as shown in the screenshot.

Step 1

2. Click on the cell B7 where the result
will be displayed and type = sign.
3. Click on the cell B1. A dashed
border will appear around it.
Step 3
4. The address of cell B1 will appear in
cell B7 and also in the Formula bar. Step 5
5. Type + symbol.
Step 6
6. Repeat the steps till B6 or you can
type = B1 + B2 + B3 + B4 + B5 + B6 Step 2
in the B7 cell.
Step 4

7. Press the Enter key. Cell B7 will display the sum
of all the values.

Step 7

Working with Worksheets

Switching between Worksheets

In Excel, we are given the freedom to add a number of worksheets. But only a few worksheets
are visible on the screen. Press Ctrl + Page Up and Ctrl + Page Down keys to switch between
worksheets.

53