CS001 Assignment 2 Solution Fall 2017
Computer Proficiency License  (CS001)
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.
Create a custom sort which will first sort the above data by “Department” in ascending order, then by Employee Name(ascending) and finally by “Salary “ (Largest to smallest).


Download attached file for complete solution. Open the file in Microsoft Excel(you need that), edit the details in the appropriate columns.

  1. You need to add your Student ID in the appropriate column.
  2. You need to write your Name in the appropriate column.
  3. If you want, you can change the dummy data so that your solution is different from others.
  4. Go to Question 2 sheet from the bottom bar(below the sheet at left corner)
  5. Edit dummy data, change the names or other details so that your data is different from others.
Save the file and submit your solution.

Feel free to ask if you have any questions. 

Attached Files
.xlsx   CS001 Assignment 2 Solution.xlsx (Size: 16.99 KB / Downloads: 80)

Possibly Related Threads…
Thread Author Replies Views Last Post
  CS712 Assignment Solution 1 2018 Fall Mishi Khan 0 2,840 12-12-2018, 11:21 PM
Last Post: Mishi Khan
  CS301 - Data Structures Assignment No. 1 Solution Fall 2018 mustansar hussain 0 3,627 12-05-2018, 03:07 PM
Last Post: mustansar hussain
  CS304 - Object Oriented Programming Assignment No. 1 Solution Fall 2018 mustansar hussain 1 3,557 12-04-2018, 10:44 AM
Last Post: Pakistani
  CS001 GDB Solution Fall 2017 Admin 0 1,912 01-31-2018, 02:48 PM
Last Post: Admin
  cs601 assignment 2 fall 2017 fahadmukhtar 8 4,235 01-23-2018, 08:59 PM
Last Post: Admin
  cs001 Farooqi Brothers 4 2,555 01-19-2018, 09:51 PM
Last Post: Usman Shafi
  CS001 Assignment 1 Solution Fall 2017 Pakistani 0 2,138 10-31-2017, 03:03 PM
Last Post: Pakistani

Users browsing this thread:
1 Guest(s)