Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 1 . Bao wants the chart to compare revenue from movies only. Modify the Stacked Column chart to meet his request and make the

11. Bao wants the chart to compare revenue from movies only. Modify the Stacked Column chart to meet his request and make the chart more meaningful.
Remove the TV Shows data series from the chart. Add a Data Table with legend keys to the chart. Use Movie Revenue as the chart title, and remove the legend, which repeats information in the data table.
12. Bao has a text file that describes the types of media the company provides.
Import the data from the file Support_EX365_2021_CT_CS4-7c_Media.txt. Use the first row as headers, and load the data as a table two columns over from and top aligned to the table for 2024 Revenue. Apply the Blue, Table Style Medium 2 table style to the imported table to coordinate with the rest of the worksheet contents. [Mac Hint: Import the data as tab delimited text. Format the text as a table using Blue, Table Style Medium 2.]
13. Bao might want to sort and filter the revenue data as well. Format the data under the cell labeled "2024 Revenue" as a table with headers and using the Blue, Table Style Medium 2 table style.

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

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

Recommended Textbook for

Database Fundamentals Study Guide

Authors: Dr. Sergio Pisano

1st Edition

B09K1WW84J, 979-8985115307

More Books

Students also viewed these Databases questions

Question

Is that RACI chart really necessary?

Answered: 1 week ago