Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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 D8 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 G8 and down. 6-Find the total Sales Revenue using the SUM function in cell D15. 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. 10-Determine the net income in cell I15 (=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. 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 D8 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 G8 and down. 6-Find the total Sales Revenue using the SUM function in cell D15. 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. 10-Determine the net income in cell I15 (=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

Auditing Assurance Services and Ethics in Australia an Integrated Approach

Authors: Alvin A Arens, Peter J. Best, Greg Shailer, Brenton Fiedler

9th edition

978-1442539365, 1442539364

More Books

Students also viewed these Accounting questions