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.
Practical question haru pdf ma rakhi dinu paryo.
ReplyDeleteOk, I will upload PDF File of Practical Questions so that easily available to you and others.
Delete