Description

Excel Assignment 4

1. What is the benefit of Microsoft 365?

2. Use two datasets and perform join on specific columns.

3. How to perform string formatting in excel. Demonstrate it with examples.

4. Create an advance expense distributor in excel.
Example: Consider expenses of a person who will be entered in excel at the same time expenses must be evenly distributed among all people with the amount of money each person should return/ receive.

5. Create reports to generate mark sheets of students in excel where percentages and addition of marks should be done using formulas.