# cs001 assignment 3 solution 2021

by 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 