Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. 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

image text in transcribed
8. 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. 3-Determine the sales revenue for ("Quantity * Sales Price) for each item starting with iPhone in cell DS and down. 4-Determine the COGS for each item item ("Quantity * Unit Cost) starting with iphone in cell F8 and down. 5-Determine the gross profit for each item item (-Sales Revenue - COGS) starting with iphone in cell Gs and down. 6-Find the total Sales Revenue using the SUM function in cell D1S. 7.Find the total COGS using the SUM function in cell F15. B-Determine the Gross Profit in cell G15 (-5ales Revenue-COGS) 9-Enter the total expenses of $16,000 in H15. 10-Determine the net income in cell 115 (=Gross Profit - Total Expenses) 11-Find the product that gives the highest Gross Profit using an Excel function, 12 Find the product that gives the lowest Gross Profit using an Excel function. 13-Find the average Gross Profit for all products using an Excel function

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting

Authors: M.Y. Khan, P.K. Jain

2nd Edition

9339203445, 9789339203443

More Books

Students also viewed these Accounting questions