You are a Microsoft Office trainer for DeVry University. The training topic for

Question

You are a Microsoft Office trainer for DeVry University. The training topic for the current month is charts using Microsoft Excel. During each training session from different departments or cohorts, the following frequently asked questions were asked and you decide to create a document formalizing answers and suggestions.

1. My supervisor, Sally, likes my charts; however, she instructs me to take more time planning my charts before creating the actual chart itself. Why is planning the creation and development of a chart so important?

2. My supervisor, John, ask me to chart some comparative data but my first attempt with a column chart did not illustrate the data as well as he would have liked. What type of chart is ideal and best to illustrate comparative data of individual items in a data series and why?

3. My supervisor, Jessica, asked me to project future data trends using a chart. Most of the data is associated with sales and depending on the nature of what is sold, data either fluctuates or increases quickly. What chart feature added to a column chart can help project these data trends and why?

4. My supervisor, Thomas, asked me to add some creativity with color and enhancements on all charts used during weekly meetings. What should I consider to avoid being overly creative and why is this important?

Explanation / Answer

1.Planning, creation and development of the chart is very important becasue we have to reflect the most relevant data which gives out maximum information pictorially. For example, a chart showing the percentage of exports to a particular country would be more intutive rather than the total exports per country.

2. A Bar chart would be the best to indicate comparitivr data. For example if we need to compare the performance in sales with respect ro three years, a bar chart showing the sales data would immediately create an impression in the minds of the management of a firm.

3. The best would be to use a scatter plot in this case to plot the already availabe data. Then we can draw a trebdline using excel along the scatter plot to predit future data trends.

4. In the Basic color that catch the eye would be RGB (Red Green and Blue). We need to make sure that the colors are approriately used with not to much strain on the eye and one should not make it vary jassy. it should look professional with use of colour of light shades of Red Green Blue to depeict different data.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.