Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Google the 10K (or annual report and 10K) for Fiscal year 2022 for Starbucks 1. In an Excel spreadsheet, set up four column headings: Division;

Google the 10K (or annual report and 10K) for Fiscal year 2022 for Starbucks

1. In an Excel spreadsheet, set up four column headings: Division; Assets; Operating Income; Revenue. Input the 2022 data (use division name abbreviations). (Do not include the total of all divisions.) Expand column widths as needed.

2. Use the Number section of the menu bar to format the data as currency (dollar signs and commas). Use the decimal remove button to delete unnecessary decimals.

3. Use Format as a Table or shading to improve the visual look of your data table. Play around with the different design options and make it look attractive.

4. Next, you will be adding a graph to visually display this data. To do this, highlight the entire table. Then click on the insert tab on the menu bar. Then click on the Column Chart. Choose an appropriate layout from those available. Add a title to your chart. Expand the chart size if needed.

5. Add a textbox (Insert on menu bar; Textbox) and answer the following questions: i. Briefly describe the segments. Give some examples of the products or describe geographical territory. ii. Comment on the graph: What stands out to you?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions