60.1K

Verified Solution

Link Copied!

Hi, I am a bit confused with problem 4, 7 and 8

1. Casey Byron is the owner of Inception Workspace, a collaborative office building where individuals, startups, or small businesses can reserve work spaces. Casey needs to secure a loan to renovate the office, so he is preparing some charts that represent Inception Workspaces finances to use in his loan applications.

Casey wants a chart representing the distribution of average hours per week that members utilized Inception Workspace in 2024. Switch to the Average Usage 2024 worksheet. Select the range A4:B243 and create a Histogram chart. (Hint: Use the Name box to select the range.) Modify the chart as described below:

Resize and reposition the chart so that the upper-left corner is located within cell D4 and the lower-right corner is located within cell K18.

Enter Average Weekly Usage (in Hours) in 2024 as the title of the chart.

Modify the bins used in the chart by setting the Bin Width axis option to 10.

2. Inception Workspace offers a variety of membership packages to fit the needs and budgets of its customers. Casey wants to graphically represent how those packages impacted Inception Workspaces total annual income between 2019 and 2024.

Switch to the Annual Income worksheet. Insert Column sparklines into the range H5:H10 based on the data in the range B5:G10, and then apply the Green, Accent 6, Darker 25% sparkline color.

3. Apply a Solid Fill, Green Data Bar conditional formatting rule into the range I5:I10.

4. Casey wants a pie chart representing how each membership package contributed to the Inception Workspaces total annual income in 2019.

Select the range A5:B9, and then create a 2-D Pie chart. Modify the chart as described below:

Resize and reposition the chart so that the upper-left corner is located within cell K1 and the lower-right corner is located within cell Q13.

Enter 2019 Total Annual Income by Package as the chart title.

Apply the Style 6 chart style.

5. In the 2024 Total Annual Income by Package 3-D pie chart (located in the range K14:Q28), position the chart legend using the Bottom option.

6. In the 3-D pie chart, add data labels to the chart using the following options:

The data labels should display using the Outside End position option.

The data labels should only display the Percentage associated with each slice of the 3-D pie chart. (Hint: You may need to uncheck the Value data label option.)

The data label should use the Percentage number format with 1 decimal place.

7. Update the Total Annual Income: 2019 2024 line chart in the range A11:J26 by editing the Horizontal (Category) Axis labels to display using the values in the range B4:G4.

8. In the line chart, modify the Minimum bounds of the vertical axis to be 150000.

Hi, I am a bit confused with problem 4, 7 and 8

1. Casey Byron is the owner of Inception Workspace, a collaborative office building where individuals, startups, or small businesses can reserve work spaces. Casey needs to secure a loan to renovate the office, so he is preparing some charts that represent Inception Workspaces finances to use in his loan applications.

Casey wants a chart representing the distribution of average hours per week that members utilized Inception Workspace in 2024. Switch to the Average Usage 2024 worksheet. Select the range A4:B243 and create a Histogram chart. (Hint: Use the Name box to select the range.) Modify the chart as described below:

Resize and reposition the chart so that the upper-left corner is located within cell D4 and the lower-right corner is located within cell K18.

Enter Average Weekly Usage (in Hours) in 2024 as the title of the chart.

Modify the bins used in the chart by setting the Bin Width axis option to 10.

2. Inception Workspace offers a variety of membership packages to fit the needs and budgets of its customers. Casey wants to graphically represent how those packages impacted Inception Workspaces total annual income between 2019 and 2024.

Switch to the Annual Income worksheet. Insert Column sparklines into the range H5:H10 based on the data in the range B5:G10, and then apply the Green, Accent 6, Darker 25% sparkline color.

3. Apply a Solid Fill, Green Data Bar conditional formatting rule into the range I5:I10.

4. Casey wants a pie chart representing how each membership package contributed to the Inception Workspaces total annual income in 2019.

Select the range A5:B9, and then create a 2-D Pie chart. Modify the chart as described below:

Resize and reposition the chart so that the upper-left corner is located within cell K1 and the lower-right corner is located within cell Q13.

Enter 2019 Total Annual Income by Package as the chart title.

Apply the Style 6 chart style.

5. In the 2024 Total Annual Income by Package 3-D pie chart (located in the range K14:Q28), position the chart legend using the Bottom option.

6. In the 3-D pie chart, add data labels to the chart using the following options:

The data labels should display using the Outside End position option.

The data labels should only display the Percentage associated with each slice of the 3-D pie chart. (Hint: You may need to uncheck the Value data label option.)

The data label should use the Percentage number format with 1 decimal place.

7. Update the Total Annual Income: 2019 2024 line chart in the range A11:J26 by editing the Horizontal (Category) Axis labels to display using the values in the range B4:G4.

8. In the line chart, modify the Minimum bounds of the vertical axis to be 150000.

fix X 5 G D A B E F J L N O P Inception Workspace 1 Total Annual Income: 2019 -2024 2 3 4 embership Packag 5 Open Desk - Visitor 54,000 6 Open Desk - Regula $ 7 Dedicated Desk 8 Dedicated Office 2019 2024 Trends 2020 2021 2022 2023 Total 67,500 $ 62.640 $ 69,660 $ 65,520 $ 130,500 117,000 145,800 $ 28,125 40,950 42,525 $ 46,800 $ 68,475 158,400 43,313 82,500 78,877 431,565 387.795 759,060 203,513 309,900 $ 86,400 $ $ 120,960 $ 21,600 $ 27,000 $ 43,200 $ -$ 48.600 $ 58,650 73,200 $ 28,800 $ $ $ 190,800 $ 253,800 327,825 328,920 379,785$ 60,000 $ 41,700 $ 9 Meeting Room 10 Total $ 252,427 1,912,695 11 12 Total Annual Income: 2019- 2024 13 $500,000 14 2024 Total Annual Income by Package $450,000 15 $400,000 16 $350,000 17 18. $300,000 19 $250,000 Open Desk -Visi 20 $200,000 Open Desk-Rem 21 $150,000 Dedicated Desk 22 $100,000 23 Dedicated Office $50,000 24 Meeting Room 25 2 26 27 Package Contribution to Annual Income: 2019 - 2024 28 29 MOpen Desk-Vi sitor Dedicated Office Meeting Room Total Open Desk -Regular Dedicated Desk 30 $1,000,000 31 $900,000 32 33 $800,000 34 $700,000 35 $600,000 36 $500,000 37 $400,000 38 $300,000 39 $200,000 40 $100,000 41 42 43 2019 2020 2021 2022 2023 2024 44 Documentation Loan Options Average Usage 2024 Annual Income Income Overview SH fix X 5 G D A B E F J L N O P Inception Workspace 1 Total Annual Income: 2019 -2024 2 3 4 embership Packag 5 Open Desk - Visitor 54,000 6 Open Desk - Regula $ 7 Dedicated Desk 8 Dedicated Office 2019 2024 Trends 2020 2021 2022 2023 Total 67,500 $ 62.640 $ 69,660 $ 65,520 $ 130,500 117,000 145,800 $ 28,125 40,950 42,525 $ 46,800 $ 68,475 158,400 43,313 82,500 78,877 431,565 387.795 759,060 203,513 309,900 $ 86,400 $ $ 120,960 $ 21,600 $ 27,000 $ 43,200 $ -$ 48.600 $ 58,650 73,200 $ 28,800 $ $ $ 190,800 $ 253,800 327,825 328,920 379,785$ 60,000 $ 41,700 $ 9 Meeting Room 10 Total $ 252,427 1,912,695 11 12 Total Annual Income: 2019- 2024 13 $500,000 14 2024 Total Annual Income by Package $450,000 15 $400,000 16 $350,000 17 18. $300,000 19 $250,000 Open Desk -Visi 20 $200,000 Open Desk-Rem 21 $150,000 Dedicated Desk 22 $100,000 23 Dedicated Office $50,000 24 Meeting Room 25 2 26 27 Package Contribution to Annual Income: 2019 - 2024 28 29 MOpen Desk-Vi sitor Dedicated Office Meeting Room Total Open Desk -Regular Dedicated Desk 30 $1,000,000 31 $900,000 32 33 $800,000 34 $700,000 35 $600,000 36 $500,000 37 $400,000 38 $300,000 39 $200,000 40 $100,000 41 42 43 2019 2020 2021 2022 2023 2024 44 Documentation Loan Options Average Usage 2024 Annual Income Income Overview SH

Answer & Explanation Solved by verified expert

See Answer