Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. $3,906.98 B. $1,982.40 C. $1,331.71 D. $5,889.38 Using the pivot table you created for Requirement 2 in Kitchen Accessories, what were total sales for 2016 in the International region? A. $12,684,022.13 B. $1,982,322.11 C. $19,427,495.57 D. $21,271,784.69 Using the pivot table you created for Requirement 3 in Kitchen Accessories, what was the gross profit in 2015? A. $37,062,004.00 B. $63,170,404.83 C. $45,346,392.10 D. $55,387,207.02 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. Classique B. Au Courant 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. Syracuse B. Key West 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. Atlantic Northeast B. Pacific Northwest C. Great Plains D. Mid Atlantic E. Southwest F. International G. Intermountain H. Gulf Coast 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. $3,906.98 B. $1,982.40 C. $1,331.71 D. $5,889.38 Using the pivot table you created for Requirement 2 in Kitchen Accessories, what were total sales for 2016 in the International region? A. $12,684,022.13 B. $1,982,322.11 C. $19,427,495.57 D. $21,271,784.69 Using the pivot table you created for Requirement 3 in Kitchen Accessories, what was the gross profit in 2015? A. $37,062,004.00 B. $63,170,404.83 C. $45,346,392.10 D. $55,387,207.02 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. Classique B. Au Courant 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. Syracuse B. Key West 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. Atlantic Northeast B. Pacific Northwest C. Great Plains D. Mid Atlantic E. Southwest F. International G. Intermountain H. Gulf Coast
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