01-13-2018, 10:56 AM
Computer Proficiency License (CS001)
Assignment # 02
Questions No 01
a) Create a worksheet with the name “Question 1”
b) Create bar chart on data provided in above figure for subject and obtained marks
Questions No 02
Create a worksheet with the name “Question 2”
Solution
Download attached file for complete solution. Open the file in Microsoft Excel(you need that), edit the details in the appropriate columns.
Feel free to ask if you have any questions.
Assignment # 02
Questions No 01
a) Create a worksheet with the name “Question 1”
- Merge Cells for Student DMC title.
- Enter your VU student id and name below the title.
- Create four columns (Subject Code, Subject, Total Marks & Obtained Marks).
- Make the column headers as bold.
- Enter marks for five subjects as shown in above figure.
- At the end merge cells for “Total” and “Percentage”.
- Type formula to calculate total marks obtained by student and his/her percentage.
- Make the “Total” and “Percentage” as bold.
b) Create bar chart on data provided in above figure for subject and obtained marks
Questions No 02
Create a worksheet with the name “Question 2”
- Create four columns with the name (Department, Employee Name, Hire Date & Salary) as shown in above figure.
- Enter sample data as shown in above figure.
- Create a filter on each column name.
Solution
Download attached file for complete solution. Open the file in Microsoft Excel(you need that), edit the details in the appropriate columns.
- You need to add your Student ID in the appropriate column.
- You need to write your Name in the appropriate column.
- If you want, you can change the dummy data so that your solution is different from others.
- Go to Question 2 sheet from the bottom bar(below the sheet at left corner)
- Edit dummy data, change the names or other details so that your data is different from others.
Feel free to ask if you have any questions.