Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

We non-commercial site working hard since 2009 to facilitate learning Read More. We can't keep up without your support. Donate.

CS001 Assignment No 03 Fall 2020 Solution & Discussion Due Date: 08-02-2021

Views: 500

Replies to This Discussion

Share the Assignment Questions & Discuss Here.... 

Stay touched with this discussion, Solution idea will be uploaded as soon as possible in replies here before the due date.

 

CS001-Assignment-3-Solution-Fall-2020.xlsx

 Click on the below link to download the file

CS001-Assignment-3-Solution-Fall-2020.xlsx

#cs001assignment3solutionfall2021 #cs001assignment3solution2020
CS001 Assignment 3 Solution Fall 2021 | CS001 Assignment 3 (2021)

Computer Proficiency License  

(CS001)

Assignment # 03

Total marks = 20

Deadline Date: 8th Feb. 2021

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):

o   Introduction to Microsoft Excel

o   Saving an Excel File

o   Creating Complex Formula

o   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 01                                                                    10 marks

 

Create a worksheet with the name “Sheet 1” with the sample data as shown in the output.

  1. Create a formula in the “Total Sold / Year” column to calculate the total of each type of item sold.
    Total Sold /Year = number sold in Qtr 1 + number sold in Qtr 2 + number sold in Qtr 3 +  number sold in Qtr 4.
  2. Create a formula in the “Sales / Year” column to calculate the sales value of each type of item sold.
    Sales / Year = (Total Sold / Year ) * Unit Price.
  3. In the row Grand Total, create a formula to calculate the total number of items sold in each quarter.
  4. Add two new rows at the bottom of the worksheet and label them maximum item sold and minimum item sold.
    Create formulas in these rows to calculate the Maximum item sold in quarter and the Minimum item sold in quarter. Also calculate the maximum and minimum number of cold drinks sold in overall year.

The desired output must match the following:


CS001 3 F20 fig001

 

Questions No 02                                                                                     10 marks

 

Create a worksheet with the name “Sheet 2” with the flowing data as below:


CS001 3 F20 fig002

  1. Create the following text in the respective cells:

Sex                    F5

Males                F6

Females             F7

Count                G5    

Total Salary      H5

Average Salary I5
High Earners     J5

 

  1. Enter the formulae to find the number of males in cell “G6” and number of females in cell “G7” respectively.
  2. In cells “H6” and “H7”, enter formulae to calculate the total salary for males and females.
  3. In cells “I6” and “I7” calculate the average salaries for males and females using the values calculated in questions 2 and 3.
  4. In cells “J6” and “J7”, calculate the number of males and females which are earning more than 50,000.
  5. Apply border across all cells data as shown in the output.

 

 

 

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

RSS

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service