Visualizing Data with Charts

Select the correct navigational path to add a chart to an Excel worksheet. Select the range of cells. Click the ______ tab on the ribbon and look in the Tables Illustrations Add-ins ______ group. Click the dialog box launcher and then the _______ tab. The charts are then listed by category. Select the one you wish to use. Click OK.

1. Insert 2. Charts 3. All charts

Where would you locate the Select Data Source dialog box? A) Design tab, Select Data B) Design tab, Chart Layouts C) Format tab, Insert Shapes D) Format tab, Format Selection

A) Design tab, Select Data

Which types of charts are examples found in Excel? Check all that apply. A) columns B) bar C) medical D) histogram E) pie F) scatterplot

A) columns B) bar D) histogram E) pie F) scatterplot

How would you access the Format Trendline task pane? A) clicking the Insert tab and Trendline group B) double-clicking on the trendline after it's added C) adding the Chart Element called Trendline D) clicking the Format contextual tab and Format Selection

B) double-clicking on the trendline after it's added

On the Format tab, which group allows you to select a different font for a chart? A) Arrange B) Current Selection C) Insert Shapes D) WordArt Styles

D) WordArt Styles