Page 57 - Computer Class 07

column C: =SUM(C3:C8)

column D: =SUM(D3:D8)

column E: =SUM(E3:E8)

column F: =SUM(F3:F8)

column G: =SUM(G3:G8)

Practical Window

Create Excel 2016 worksheet with marks of students in five subjects. Then, find the total of the
five subjects by entering a formula.

Editing a Formula

If we want to make changes or edit the formula. There are 3 ways of editing the

formula which is as follows.

Let’s
Let’s Learn...
Learn...

To edit a formula.

1. Double-click on the cell
containing the formula to be

changed.

The formula appears in the cell.
Excel outlines each cell used in

the formula with a different
colour.

2. Press the arrow key to move the flashing insertion point to where you want to
remove or add characters.

Computer-7 57