Answered step by step
Verified Expert Solution
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 andor the scripted PDFs 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 pdfs
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
B If you do not have Office 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 in Kitchen Accessories, what is the gross profit for customer number on To find customer in Excel, in the Home ribbon, click on Find & Select and choose the option to Find.
A $
B $
C $
D $
Using the pivot table you created for Requirement in Kitchen Accessories, what were total sales for in the Atlantic Northeast region?
A $
B $
C $
D $
Using the pivot table you created for Requirement in Kitchen Accessories, what was the gross profit in
A $
B $
C $
D $
Using the pivot table you created for Requirement in Kitchen Accessories, what was the most profitable brand in as measured by gross profit?
A Au Courant
B Classique
Using the pivot table you created for Requirement in Kitchen Accessories, what was the most profitable collection in 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 in Kitchen Accessories, which region was the most profitable in 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started