StepInstructionsPoint Value1Start Excel. Download and open the file named Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.

0
(0)

StepInstructionsPoint Value1Start Excel. Download and open the file named Exp19_Excel_Ch03_CapAssessment_Movies.xlsx. Grader has automatically added your last name to the beginning of the filename.
02You want to create a pie chart to show the percentage each category contributes to the monthly movie downloads.

Select the ranges A5:A10 and F5:F10. Create a pie chart and move it to a chart sheet named April Pie Chart.
63The chart needs a descriptive title that is easy to read.

Type April 2021 Downloads by Genre as the chart title, apply bold, 18 pt font size, and Black, Text 1 font color.
54Percentage and category data labels will provide identification information for the pie chart.

Add category and percentage data labels in the Inside End position. Remove value data labels and the legend. Apply 14 pt font size and Black, Text 1 font color.
55You want to focus on the comedy movies by exploding it and changing its fill color.

Explode the Comedy slice by 7% and apply Dark Red fill color.

46A best practice is to include Alt Text for accessibility compliance.

Add Alt Text: The pie chart shows percentage of downloads by genre for April 2021. (including the period)
27Next you want to create a combo chart to depict the monthly totals and percentages by category.

Display the Data sheet, select the ranges A4:A10 and F4:G10, and then create a Clustered Column – Line on Secondary Axis combo chart.
48You want to position the chart below the data source.

Cut the chart and paste it in cell A13. Change the height to 3.5″and the width to 6″.
59Change the combo chart title to April 2021 Downloads. Apply Black, Text 1 font color to the chart title.
310Axis titles will help distinguish the number and percentage of downloads.

Add a primary value axis title and type Number of Downloads. Add a secondary value axis title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color to both value axis titles.
611Now that you added an axis title for each vertical axis, you can remove the legend and format the secondary value axis to display whole percentages.

Remove the legend for the combo chart. Display 0 decimal places for the secondary value axis.

112You want to add some color to the plot area for the combo chart.

Apply Light Gradient – Accent 1 gradient fill color for the plot area.
513A best practice is to include Alt Text for accessibility compliance.

Add Alt Text: The combo chart shows the number and percentage of downloads by genre for April 2021. (including the period).
214To provide a visual summary of the weekly totals for each genre, you will insert sparklines. 

Select the range B5:E11. Insert Line Sparklines in the range H5:H11. Apply Black, Sparkline Style Dark #4
1015Displaying the markers helps identify the specific points on the sparklines. You will also change the high point to a different color to stand out.

Show the high point and markers for the sparklines. Change the high point marker color to Red.
516Your last major task is to create a bar chart for weekly downloads.

Select the range A4:E10. Create a stacked bar chart. Move the chart to new chart sheet. Type Weekly Downloads for the sheet name. Apply Style 8 chart style.
1417Add a chart title above the bar chart and type April 2021Weekly Downloads by Genre.
418Increasing the font size will make the chart elements easier to read.

Apply 11 pt font size to the category axis, value axis, and the legend for the bar chart.
619Because the largest value is less than 9,000, you can reduce the maximum bound in the chart. In addition, you want to display the category labels in the same order that they are in the worksheet.

Change the maximum bounds for the value axis to 9000 and set the Major Units to 500 for the bar chart. Use the Axis Options to format the category axis so that the category labels are in reverse order in the bar chart.
520Although the bar chart displays major gridlines, minor gridlines could improve the appearance.

Add primary minor vertical gridlines to the bar chart.
021A best practice is to include Alt Text for accessibility compliance for the bar chart.

Add Alt Text: The stacked bar chart shows downloads by each week for each genre. (including the period).
422Insert a footer with Exploring Series on the left, the sheet name code in the center, and the file name code on the right on all the sheets. Change to Normal view.
423Save and close Exp19_Excel_Ch03_CapAssessment_Movies.xlsx. Exit Excel. Submit the file as directed.
0

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

The information that is gathered every day in healthcare drives

0 (0) The information that is gathered every day in healthcare drives patient care and the improvement of the quality of care. Each staff member within a healthcare institution has a role in improving patient care. In this short paper, complete the following:  Chief of Medicine Managers: Identifies a

Create a nutritional care plan for your client.(old- malnutrition)

0 (0) Create a nutritional care plan for your client.(old- malnutrition) This will include an evaluation of nutritional risk, a list of interventions, and a list of expected outcomes. List the goals of medical nutrition therapy for your patient and suggest an appropriate diet. Does your patient/client require a dietary

Introduction Jones Carolyn Denise is 35 years an old female with

0 (0) Introduction       Jones Carolyn Denise is 35 years an old female with a height of 162.6cm ( 5’4”) and weight of 108kg ( 237 lb ) with a medical condition of acid reflex and Vitamin D deficiency. Mrs. Jones was admitted on February 7, 2023, with a diagnosis of

5 questions to answer separately! All relate to Implementing the ABCDE

0 (0) 5 questions to answer separately! All relate to Implementing the ABCDE Bundle to decrease hospital length of stay in a long-term acute care hospital. You may reference the three primary articles attached – must read them to use them   question 1 Describe the primary quantitative literature upon which

Scientific Study Analysis Prior to beginning work on this assignment,

0 (0) Scientific Study Analysis Prior to beginning work on this assignment, read the article The Relationship Between Multiple Forms of Discrimination, Neighborhood Characteristics, and Depression Among Illicit Drug Users in New York CityLinks to an external site. and address the following questions in a three to four page (excluding title and

How will you use the processes from ARDP 6-22 to improve the ABCT and

0 (0) What is the critical leadership problem facing the 4th ABCT? How will you use the processes from ARDP 6-22 to improve the ABCT and achieve your vision? Clearly and comprehensively explain, defend, and justify your answer. If something is not your original thought, you need to cite your

Early Childhood and Special Education Lesson Plan

0 (0) All materials needed for the lesson must be used or referred to during the PPT presentation including anchor charts, visual supports and manipulatives needed for the presentation. So please take a picture of materials yo used, and also make anchor charts… What you need to do is a

Research the differences in conducting business in the Dominican

0 (0) Research the differences in conducting business in the Dominican Republic as compared to the United States. Consider culture, customs, predominate religions, type of government, natural resources, infrastructure, modes of shipping, stability of economy, currency used internationally, trade relationships/agreements with the United States, living/working conditions, restrictions placed on foreign

Brand Assessment & Shopping Research Paper

0 (0) At the beginning of the assignment due class session, submit a summary of your research compared to your experience in physically visiting and shopping in a retail business. Discuss the business’s strengths and weaknesses in the branding factors you have learned in this course-to-date (class lectures and reading

Nonverbal Research Paper

0 (0) General Instructions Conduct a participant observation of nonverbal communication during a structured period of time (e.g., sitting at a café, during a sports event, while at work, at the gym, etc.). Take field notes throughout the course of your observation. Spend time looking through your field notes and

Marketing – Search Engine Optimization (Footer Writing)

0 (0) Write a Footer for 5 different web pages. Each footer should be approximately 330 words. The footer should briefly describe the Brand and what type of products the brand is selling, and how those products can benefit the customer. There is no specific paper format. Make sure that

a firm/company/store, identifying its product or service, and

0 (0) The project consists of selecting a firm/company/store, identifying its product or service, and analyzing its current market environment. This includes identifying competitors, analyzing nature of the product or service, and examining ease of entry into or exit from the market. It involves examining the market demand and supply,

WNEU ME 322 Spring 2019 Take‐Home Project

0 (0) Find 2 manufacturers within 25 miles of your home town or the town you would like to live in after graduation.  For each manufacturer, gather and compare the following information (as much as is available publicly, or with a little digging – a polite email and/or phone call and/or

Accounting for the iPhone at Apple Inc

0 (0) Please answer 3 case Questions: 1. Compared to the typical point-of-sale accounting method, what are likely effects on income statement, balance sheet, and statement of cash flow of Apple’s choice to use a subscription method for revenue recognition for its iPhone? Also discuss advantages and disadvantages of subscription

IBM Financial Reporting and Analysis

0 (0) Please answer the 19 questions listed below. The questions below are based on the 2017 financial statements of IBM which I provided as a pdf. (Page number references below refer to document page numbers, not .pdf page numbers.) Please only use the financial statements provided to answer the

Proving the Existence of the Traditional Judeo-Christian God

0 (0) You must write about the following 6 items below and defend your thesis. You must explain them all in detail in section 2 of your paper and then critically discuss each of them in section 3 using separate paragraphs. Use paragraphs — at least one for each idea.

Analysis and Presentation of Data

0 (0) Resources: Ch. 15, 16, & 17 of Business Research Methods (all chapters will be attached). Review question four in the “Discussion Questions” of Chapter 15; review question 4 in the “Discussion Questions” of Chapter 16; and review question 10 in the “Discussion Questions” of Chapter 17 of Business

Social and Professional Issues in Computing

0 (0) Select five from the following seven vocations. Which ones do you believe are a true “profession”? Briefly defend your position for each one with facts and references to definitions of a profession from sources such as authors and philosophers. Consider certification, licensing, codes of ethics, education, and enforcement