CS001 Assignment 2 Solution fall 2017

CS001 ASSIGNMENT 2 SOLUTION FALL 2017

Dear VU (Virtual University of Pakistan) Students, here you read and download CS001 (Computer Proficiency) Assignment No.2 SolutionFall–2017. Assignment Total Marks 20. You can download easily Assignment Solution click the download button and get Assignment Solution. Assignment Open Date 12^th January 2018 and Assignment Closing Date 18^thJanuary 2018. You can also like for latest update our Facebook page, YouTubechannel and follow on Google+. (VU KI DUNIYA) Previously shared CS001 (ComputerProficiency) Assignment No.1 Solution Fall–2017.

important instructions

Please carefully read the following instructions before attempting assignment.

Rules for marking:

It should be clear that your assignment would not get any credit if:

• The assignment is submitted after the due date.
• The submitted assignment does not open or file is corrupt.
• Strict action will be taken if submitted solution is copied from any other student or from the internet.
• You should consult the recommended books to clarify your concepts as handouts are not sufficient.
• You are supposed to submit your assignment in xls or xlsx format.
• Any other formats like scan images, doc,docx,PDF, zip, rar, ppt and bmp etc will not be accepted.

Topic Covered:

• Module 4 (Spreadsheets):
• Saving an Excel File
• Creating Complex Formula
• Sorting Data

Note: Create an excel file with two sheets, one for Question 1 and other for Question 2.

Note

No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date.

If you people find any mistake or confusion in assignment (Question statement), please consult with your instructor before the deadline. After the deadline no queries will be entertained in this regard.

For any query, feel free to email at: cs001@vu.edu.pk

Questions No.1:

Create a worksheet with the name “Question 1” as below:

• 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.

Create bar chart on data provided in above figure for subject and obtained marks

Questions No.2:

Create a worksheet with the name “Question 2” as below:

• 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), the final result is shown in below figure:

Note:Create an excel file with two sheets, one for Question 1 and other for Question 2.

DOWNLOAD assignment SOLUTION FILE IN DOC

Download CS001 Assignment Solution by Clicking the Download Button Below in just single Click.

Download

You can Also Download Midterm Solved Past Papers referenceby Moaaz and Waqar Sidhu, Final term Solved Past Papers reference by Moaaz and WaqarSidhu, GDB Solutions, Assignment Solutions, and Solved Quizzes files, PPTSlides, Handouts, Final term Short Notes, Mid Term Short Notes and NTS Guidelines.