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.
Post a Comment (0)
Previous Post Next Post

ADS 1

ADS 2