We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

# CS001 Assignment No 03 Fall 2019 Solution & Discussion Due Date: 23-01-2020

CS001 Assignment No 03 Fall 2019 Solution & Discussion Due Date: 23-01-2020

CS001 Computer Proficiency License Assignment 3 Solution & Discussion Fall 2019

Questions No 01                                                                                10 marks

Create a worksheet in excel with the name “Question 1” with the following data as shown below:

Then, perform the following tasks in the worksheet for the given data:

1. Create a formula in the Quantity column to calculate the total quantity of each type of Paper Goods sold from September to January. In simple words,

Quantity = Total number of goods sold for each type from September to January

1. Create a formula in the Sales column to calculate the total price of quantity sold from September to January for each type of goods.

Total Price of Goods Sold = Quantity * Unit Price

1. In the row Grand Total, create a formula to calculate the total number of goods of all types sold per month.

Grand Total = Total number of goods sold for all paper types in each month

1. Create a new row with label Mod Sale Item under the row Grand Total. In Mod Sale Item row, for each respective cell of month column, create a formula to find the Maximum quantity of goods sold for any type. For example, in month of September, Toilet papers were sold the most which were 115. So, our formula in Mod Sale row should display 115. You should calculate the same for each month.
2. Create a new row with label Mode Sale Goods at the end of the worksheet. In this row, you will create a formula to calculate the mode value for quantities of each goods type sold during a particular month and then displays the name of the goods representing the mode value.

Questions No 02                                                                                  10 marks

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

1. Enter the formula to find the number of Computer science scholars in cell “G8” and number of Management scholars in cell “G9” respectively.
2. In cells “H8” and “H9”, enter formula to calculate the total pay for Computer science scholars and Management scholars.
3. In cells “I8” and “I9” calculate the average pay for Computer science scholars and Management scholars using the values given in Pay column (column D).
4. In cells “J8” and “J9”, calculate the number of Computer science scholars and Management scholars having pay more than 50,000.

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

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Views: 411

### Replies to This Discussion

CS001 Assignment No 03 Solution Fall 2019

CS001_Assignmnet_03_Solution_Fall_2019_vustudents.ning.com.xlsx

## Latest Activity

36 minutes ago
40 minutes ago
41 minutes ago
Zohaib Hassan liked Zoey D's discussion ゜゜・ Bara Dushwar Lgta Hei ・゜゜
47 minutes ago
54 minutes ago
55 minutes ago
58 minutes ago
1 hour ago

1

2

3

## HELP SUPPORT

This is a member-supported website. Your contribution is greatly appreciated!