Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The steps you will follow for this project are as follows: Review the video and / or the scripted PDF ' s for Windows and

The steps you will follow for this project are as follows:
Review the video and/or the scripted PDF's for Windows and Macs..
Download the Excel data file. (After you download the file, YOU NEED TO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT. If you do not save your assignment, the next time you enter, you may see a different company and set of data.)
Perform the requirements on the data file using the video or pdf's.
Check your work in the Excel file with these check figures.
Use your Excel file to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.)
Resources
A) Information on how to update Excel and Office 365.
B) If you do not have Office 365, click here to learn how to get it for free.
This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor.
Using the data worksheet for Requirement 1 in Kitchen Accessories, what is the gross profit for customer number 291137 on 1/18/2015?(To find customer 291137 in Excel, in the Home ribbon, click on Find & Select and choose the option to Find.)
A. $5,889.38
B. $1,982.40
C. $1,331.71
D. $3,906.98
Using the pivot table you created for Requirement 2 in Kitchen Accessories, what were total sales for 2016 in the Atlantic Northeast region?
A. $18,958,413.57
B. $8,992,565.62
C. $15,270,451.25
D. $14,925,242.98
Using the pivot table you created for Requirement 3 in Kitchen Accessories, what was the gross profit in 2015?
A. $45,346,392.10
B. $55,387,207.02
C. $37,062,004.00
D. $63,170,404,83
Using the pivot table you created for Requirement 4 in Kitchen Accessories, what was the most profitable brand in 2018, as measured by gross profit?
A. Au Courant
B. Classique
Using the pivot table you created for Requirement 5 in Kitchen Accessories, what was the most profitable collection in 2018, for the Classique brand as measured by the gross profit percentage?
A. Key West
B. Syracuse
C. Rochester
D. Aiden
Using the pivot table you created for Requirement 6 in Kitchen Accessories, which region was the most profitable in 2018, as measured by the gross profit percentage?
A. Pacific Northwest
B. Mid Atlantic
C. Intermountain
D. Atlantic Northeast
E. Southwest
F. Gulf Coast
G. Great Plains
H. International
image text in transcribed

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_2

Step: 3

blur-text-image_3

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

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0073379616, 73379611, 978-0697789938

More Books

Students also viewed these Accounting questions