Page 35 - Computer - 6

3. On the Table Tools Layout tab, click the Formula button in the
Data group.
The Formula dialog box opens with the formula = SUM(ABOVE)
in the Formula text box.

4

4. Click the OK button.
The sum of values is displayed in the cell.

Knowledge Discovery Subject Enrichment

If you change any value in the group of values that the formula uses, select the cell containing the formula
and press the F9 key to update the formula result.

Life Skills
Health Tip

Sitting for long hours on a chair in front of the computer can cause cramps in the leg
muscles. Prolonged cramps can weaken the muscles too. The simple Quadriceps Stretch
exercise can be done easily and anytime to relax the leg muscles.
1. Stand straight and hold the back of the chair.
2. Slowly pull the ankle of the left leg up until you feel the thigh muscles stretch.
3. Hold the ankle up with the left hand in this position for 5-10 seconds.
4. Repeat with the other leg.
5. Repeat the exercise 5 times, alternating between the two legs.

Database Subject Enrichment

Tables provide a way to share the same data between a Word document and an
Excel spreadsheet. Excel provides more formatting features for numerical data than
Word. Thus, to apply similar formatting on data in Word, convert the data into a
table. Copy and paste the table into an Excel spreadsheet. Format the data in Excel
as required. Now, copy the data and paste it back to Word and merge the formatting.
The formatted data will be inserted in the Word document.

Post-Processing  



 A table is an arrangement of text in the form of vertical columns and horizontal rows.
 The options under the Table command to insert a table in a document are - Table grid, Insert
table, Quick Tables, Draw Table, and Convert Text to Table.
 The Table Design and Layout tabs provide options to change the appearance and structure of a
table.

33