Calculation in M.S. Word

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

S.N.	Month	Income	Expenses	Saving
1	Baishakh	15000	7000	?
2	Jestha	16000	9000	?
3	Asadh	12000	7000	?
4	Shrawan	18000	12000	?
	Total	?	?	?

QUESTIONS:
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.