Question

A Fill in the blanks. 1. (Bar/Column) charts have vertical bars to represent data. 2. (Column/Line) charts are used for showing variation in trend. 3. (Legend/Chart Title) shows the data series and its color that is represented on the chart. 4. Axis titles, data labels and data table are some of the chart (elements/compounds). 5. Chart (Style/Type) are formats that modify the appearance of the chart. B Write T for True or F for False. 1. Area chart is divided into slices to represent numerical proportion. 2. Horizontal axis represents the independent values or categories. 3. By clicking on the chart, shortcut buttons appear which can be used to insert chart elements. 4. Quick Layout changes chart type. . 5. It is not possible to change a Line chart to Column chart or vice versa in MS Excel 2013. C Choose the correct option. 1. Which of the following charts have horizontal bars to represent data? (a) Pie Chart (b) Area Chart (C) Line Chart (d) Bar Chart 2. The arc length of each slice in a pie chart is proportional to (a) number of entries in the data (b) the magnitude of the quantity it represents (c) number of rows in the data (d) Both (a) and (b) 3. Which of the following charts is best suited for representing a comparison? (a) Line (b) Column (c) Pie (d) Area 4. Which of the following are components of a chart that add detail to it? (a) Chart Elements (c) Chart Type (d) Horizontal Axis (b) Chart Styles​

Answer 1

Explanation:

• A Fill in the blanks. 1. (Bar/Column) charts have vertical bars to represent data. 2. (Column/Line) charts are used for showing variation in trend. 3. (Legend/Chart Title) shows the data series and its color that is represented on the chart. 4. Axis titles, data labels and data table are some of the chart (elements/compounds). 5. Chart (Style/Type) are formats that modify the appearance of the chart. B Write T for True or F for False. 1. Area chart is divided into slices to represent numerical proportion. 2. Horizontal axis represents the independent values or categories. 3. By clicking on the chart, shortcut buttons appear which can be used to insert chart elements. 4. Quick Layout changes chart type. . 5. It is not possible to change a Line chart to Column chart or vice versa in MS Excel 2013. C Choose the correct option. 1. Which of the following charts have horizontal bars to represent data? (a) Pie Chart (b) Area Chart (C) Line Chart (d) Bar Chart 2. The arc length of each slice in a pie chart is proportional to (a) number of entries in the data (b) the magnitude of the quantity it represents (c) number of rows in the data (d) Both (a) and (b) 3. Which of the following charts is best suited for representing a comparison? (a) Line (b) Column (c) Pie (d) Area 4. Which of the following are components of a chart that add detail to it? (a) Chart Elements (c) Chart Type (d) Horizontal Axis (b) Chart Styles