Excel Charts

What is the importance of charts and graphics in providing information?

• They make the data easier to understand

• They make the data visually appealing

• All of the above

• They help in analyzing trends and patterns

Briefly explain any five different components of a chart?

• Title, Legend, Data Labels, Grid Lines, Tick Marks

• Chart Title, X-Axis Title, Y-Axis Title, X-Axis Category, Y-Axis Value

• X-Axis Title, Y-Axis Title, Data Labels, Legends, Grid Lines

• Chart Title, X-Axis Title, Y-Axis Title, Data Labels, Legends

Explain the process of creating a chart using Chart Wizard dialog box.

• Select the data, click on Insert tab, choose the chart type, and follow the steps in the Chart Wizard

• Select the data, click on Chart Wizard, choose the chart type, and the chart will be created automatically

• Select the data, click on Chart Wizard, choose the chart type, and follow the steps in the Chart Wizard

• Select the data, click on Insert tab, choose the chart type, and the chart will be created automatically

Briefly explain the following: a) Bar charts, b) Pie charts

• a) Used to show comparisons between individual items, b) Used to display continuous data over time

• a) Used to compare values across categories, b) Used to show the relative proportions or contributions to a whole

• a) Used to compare values across categories, b) Used to display continuous data over time

• a) Used to highlight the degree of a change over time, b) Used to compare values across categories

List any four features of Chart Formatting toolbar.

• Layout, Format, Design, Arrange

• Title, Legend, Data Labels, Grid Lines

• Chart Title, X-Axis Title, Y-Axis Title, Data Labels

• Tick Marks, Grid Lines, Data Labels, Legends

How do you copy a chart to Word created in Excel 2007?

• Select the chart, click Cut, open Word, and click Paste

• Select the chart, click Copy, open Word, and click Paste

• Select the chart, click Paste, open Word, and click Copy

• Select the chart, click Copy, open Word, and click Cut

List any five categories of AutoShapes in Excel.

• Lines, Connectors, Basic Shapes, Block Arrows, Flow Chart

• Lines, Connectors, Basic Shapes, Stars and Banners, Call Outs

• Lines, Connectors, Basic Shapes, Stars and Banners, Smart Art Graphics

• Lines, Connectors, Basic Shapes, Flow Chart, Smart Art Graphics

You are asked to prepare a flow chart. What kind of AutoShapes you would like to use?

• Flow Chart, Smart Art Graphics, Block Arrows

• Lines, Connectors, Basic Shapes

• Lines, Connectors, Flow Chart, Smart Art Graphics

• Stars and Banners, Call Outs, Smart Art Graphics

Explain the steps in adding a Clip Art to your worksheet?

• Click on Insert Tab, Click Clip Art, Select a Collection, Click on a clip from the collection, Click Insert

• Click on Insert Tab, Click Picture, Select a Collection, Click on a clip from the collection

• Click on Insert Tab, Click Clip Art, Select a Collection, Click on a clip from the collection

• Click on Insert Tab, Click Picture, Select a Collection, Click on a clip from the collection, Click Insert

How do you add a photo or graphic to your worksheet from existing file?

• Click on Insert Tab, Click Picture, Select the photo, Click Insert

• Click on Insert Tab, Click Clip Art, Select the photo, Click Insert

• Click on Insert Tab, Click Picture, Select the photo from the location, Click Insert

• Click on Insert Tab, Click Clip Art, Select the photo from the location, Click Insert