# PSC HELPER

Public Service Commission Preparation & Blogging

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

## Interviews Preparations

### Tips & Tricks

Based on Experience

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

## Blogging & Wordpress Tutorials, Courses

Tips

Tips

New Strategies

New Strategies

Make Money

Make money

Guide

Guide

For Beginners

For Beginners

Tutorials

Tutorials

How to start?

How to start?

Intermediate

### Wordpress

Intermediate

Q.No. 1. Create the following table in Ms-word and perform the following operations.

SN Month Â Â  Â Income Expenses Â Â  Â Saving
1 January Â Â  Â 12000 Â Â  Â Â  Â  8000
2 February Â Â  Â 18000 Â Â  Â Â Â  Â 12000
3 March Â Â  Â 15000 Â Â  Â Â Â  Â 23000
4 April Â Â  Â 14000 Â Â  Â Â Â  Â 11000
Total
1) Calculate Saving as Income - Expense using Table Formula.
2) Calculate Total Income, Expense and Saving.

Solution:-

To insert Table:-

• Click Insert Tab.
• Click the Table button under the Tables group.
• Click on the Insert Table button from options.
• After that Put the Value 5 at the field of the Number of columns and put 6 at the field of the Number of rows.
• Click the OK button.
• To merge the Total Field.
• Highlight the First and Second columns of the last Cell.Â
• Right- Click and click Merge Cells.
• Put the data information to the table from the question.

1)Â  To calculateÂ Saving:-

• Place cursor at the first cell of Saving Cell.
• Click on the Insert Tab.
• Click on the Quick Parts button under Text group.
• Click on the Field button from the displaying options.
• Choose the Equations and Formulas from the Dialog Box.
• Click on the Formula.
• Type =C2-D2Â
• Click on the OK button.
• Copy the formula also to the others cells of Saving Cell.
• Right-click on the cell in which to calculate Saving Cell.
• Click on the Toggle Field codes button.
• Type the Formula =C3-D4.
• And type the formula for the others cells. Don't forget to update the rows.
• After that Right-Click on every cell of the Saving Column one by one.
• Click on theÂ Update Field button.

2)Â  To calculateÂ Total income, expensive and saving:-

• Place the cursor in the Total income Cell.
• Click on Insert Tab.
• Click on the Quick Parts button under the Text group.
• Click on the Field button from the given options.
• Click on the Equations and Formulas from the Dialog box.
• Type the formula =SUM(ABOVE)
• Click on the OK button.
• Copy the formula to the other cell of Total expensive, total income, and total saving Column in which to calculate.
• Right-Click to the Total cell.
• Click on the Toggle Field codes button.
• Update the formula according to column and row.
• Again right-click on the Total Cell.
• Click on the Update Field button.
• Do the same step to the others cells.