Solve the given Questions. 3 45 6 B 1 Excel Spreadsheet Assignment 2 Following is the sales's

Solve the given Questions.

Transcribed Image Text:

3 45 6 B 1 Excel Spreadsheet Assignment 2 Following is the sales's report for City Electornics Company 13 Play Station 14 7 Items sold Quantity Sales Price Sales Revenue 8 iPhone 800 40000 9 iPad 300 9000 10 Tablet 500 12500 11 Laptop 900 27000 12 Desktop 600 12000 700 10500 15 16 D 50 30 25 30 20 15 E 111000 Unit Cost City Electronics Company Sales Report for the month of June 600 200 350 650 425 450 F 7-Find the total COGS using the SUM function in cell F15. 8-Determine the Gross Profit in cell G15 (=Sales Revenue - COGS) 9-Enter the total expenses of $16,000 in H15. G 30000 6000 8750 19500 8500 6750 25 26 27 28 10-Determine the net income in cell 115 (=Gross Profit - Total Expenses) 29 11-Find the product that gives the highest Gross Profit using an Excel function. 30 12 Find the product that gives the lowest Gross Profit using an Excel function. 31 13-Find the average Gross Profit for all products using an Excel function. 32 Save the spreadsheet as: yourname.xlsx.com, and submit it. H COGS Gross Profit Total Expenses Net Income 10000 3000 3750 7500 3500 3750 I 17 18 Answer the following questions: (2 points for each question) 1-Merge and center "City Electronics Company" across D to F. 2-Merge and Center "Sales Report for the month of June" across columns D to F. 19 20 21 3-Determine the sales revenue for (=Quantity* Sales Price) for each item starting with iPhone in cell D8 and down. 22 4-Determine the COGS for each item item (=Quantity* Unit Cost) starting with iPhone in cell F8 and down. 23 5-Determine the gross profit for each item item (=Sales Revenue - COGS) starting with iPhone in cell G8 and down. 24 6-Find the total Sales Revenue using the SUM function in cell D15. J 3 45 6 B 1 Excel Spreadsheet Assignment 2 Following is the sales's report for City Electornics Company 13 Play Station 14 7 Items sold Quantity Sales Price Sales Revenue 8 iPhone 800 40000 9 iPad 300 9000 10 Tablet 500 12500 11 Laptop 900 27000 12 Desktop 600 12000 700 10500 15 16 D 50 30 25 30 20 15 E 111000 Unit Cost City Electronics Company Sales Report for the month of June 600 200 350 650 425 450 F 7-Find the total COGS using the SUM function in cell F15. 8-Determine the Gross Profit in cell G15 (=Sales Revenue - COGS) 9-Enter the total expenses of $16,000 in H15. G 30000 6000 8750 19500 8500 6750 25 26 27 28 10-Determine the net income in cell 115 (=Gross Profit - Total Expenses) 29 11-Find the product that gives the highest Gross Profit using an Excel function. 30 12 Find the product that gives the lowest Gross Profit using an Excel function. 31 13-Find the average Gross Profit for all products using an Excel function. 32 Save the spreadsheet as: yourname.xlsx.com, and submit it. H COGS Gross Profit Total Expenses Net Income 10000 3000 3750 7500 3500 3750 I 17 18 Answer the following questions: (2 points for each question) 1-Merge and center "City Electronics Company" across D to F. 2-Merge and Center "Sales Report for the month of June" across columns D to F. 19 20 21 3-Determine the sales revenue for (=Quantity* Sales Price) for each item starting with iPhone in cell D8 and down. 22 4-Determine the COGS for each item item (=Quantity* Unit Cost) starting with iPhone in cell F8 and down. 23 5-Determine the gross profit for each item item (=Sales Revenue - COGS) starting with iPhone in cell G8 and down. 24 6-Find the total Sales Revenue using the SUM function in cell D15. J

Answer rating: 100% (QA)

Excel Spreadsheet Assignment Following is the sales report for Ci... View the full answer