cs001 assignment 3 solution 2021

by
cs001 assignment 3 solution 2021
cs001 assignment 3 solution 2021

cs001 assignment 3 solution 2021

 

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.

See also:

phy101 final term papers 2021

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.

 

 

cs001 assignment 3 solution 2021

[su_button id=”Download” url=”https://www.dropbox.com/scl/fi/4q89dvwtc7nqxc0pkmkt7/CS001-Assignment-SOLUTION.xlsx?dl=0&rlkey=862r3c1hyojyaj6arlzyhpymr” target=”blank” size=”6″ wide=”yes” center=”yes”]Download[/su_button]

About Author: ForStudy

Gravatar Image
Forstudy.info is a broad and wide opportunity for seeking a platform for youth all around the world. To find the latest educational opportunities free of cost. A wide range of international scholarships in the US, UK, Canada, Australia, Europe, Asia, Africa, Scholars is a plate form where I will provide the data that is required of students. I will upload the research papers of MSCS Or MSCS that I prepared during my study duration. I will upload the latest assignments for the students of Virtual University in Pakistan and abroad countries also.