FND 013 Majan College Personal Budget Excel Sheet Excel sheet the student should answers the following: 1. Insert appropriate blank rows (1 Row) on top an

FND 013 Majan College Personal Budget Excel Sheet Excel sheet the student should answers the following:

1. Insert appropriate blank rows (1 Row) on top and type the suitable title for your sheet

2. Format the table as Follows: The title should have the following:

3. Font type: Algerian

4. Font size: 28

5. Fill Color: Purple

6. Font Color: Yellow

7. Merge and Center, Bold

8. Dashed Border with border color – Dark Red

9. Change the Column Width of all columns to ‘15’.

10. Change the Row height of all rows to ‘20’.

11. Select the appropriate border (outline: double line & Inside: dotted) and canter alignment for the cells.

12. Create your own formula by using a label for that in F2 and the Result in F3 Use any of the main operators ( * , / , + , – ) Copy the formula to find the result for others columns .

13. Find the Sum label on A13, result in B13 . Copy the formula to find the Sum of other columns.

14. Find the Average label in A 14, result in B14. Copy the formula to find the Average of other columns.

15. Find the Maximum label in A15, result in B15. Copy the formula to find the Maximum of other columns.