Chapter - 3 Charts in Excel

 Exercise Answers

Multiple choice questions:- 

1. Data series is basically:

a. Shows the value of plotted Data-points

b. Shows the category of plotted Data-points

c. Gives us an idea about the title of the chart

d. A group of related values like all data values in a row or a column of the data sheet. 

Ans. d. A group of related values like all data values in a row or a column of the data sheet

2. Which axis is also known as category axis? 

a. Y-axis

b. X-axis

c. Z-axis

d. Circular axis

Ans. b. X-axis

3. Which charts are useful for showing data changes over a period of time or for illustrating comparisons among items? 

a. Pie chart

b. Area chart

c. Column chart

d. Scatter chart

Ans. c. Column chart

4. Which option from the drop down will first resize the chart and then as a title above the chart area? 

a. None

b. Centred Overlay Title

c. Above Chart

d. Below chart

Ans. c. Above Chart

5. Which chart shows trends in data at equal intervals?

a. Line chart

b. Pie chart

c. Bar chart

d. Column chart

Ans. a. Line chart

6. What is used to represent Data series?

a. Chart Title

b. Legends

c. X-axis

d. Y-axis

Ans. b. Legends

7. What tells us about the title of the chart?

a. Chart title

b. Legends

c. Data series

d. Pie chart

Ans. a. Chart title

State the following statements are true or false.

1. Y-axis is also called the category axis. 

False

2. A category Axis becomes a title scale axis when the Axis Type is set to date axis.

True

3. The Y-axis shows the value of the plotted data points. 

True

4. The Data series is a group of related values, like all data values in row or a column of the Data sheet. 

True

5. Legends are used to represent the data series. 

True

6. A Sparkline is a large chart in a worksheet cell. 

False

Fill in the blanks.

1. ________ charts are useful for showing data changes over a period of time or for illustrating comparisons among items. 

Ans. Column

2. A _______ chart shows trend in data at equal intervals. 

Ans. Line

3. A _______ chart shows the proportional size of items included in single data series. 

Ans. Pie

4. The _______ is also called the category axis.

Ans. X-axis

5. The _______ is also called the value axis. 

Ans. Y-axis

6. The _______ gives you an idea about the topic of the chart. 

Ans. Chart title

Match the following:

Ans. 

1. e

2. g

3. c

4. a

5. d

6. b

7. f

Answer in one word/sentence.

1. What can we use in Microsoft Excel to represent the data in graphical way?

Ans. We can use charts in Microsoft Excel to represent the data in graphical way. 

2. What is the group of related values, like all data in a row or column of a Datasheet called?

Ans. The data series is the group of related values, like all data in a row or column of the data sheet.

3. Which Axis generally shows the category of plotted Data points and is also known as category axis?

Ans. X-axis generally shows the category of plotted data points and is also known as category axis. 

4. Which Axis shows the value of plotted data points?

Ans. Y-axis shows the value of plotting data points. 

5. What does a pie chart represents?

Ans. A pie chart is generally used when you want to find out and graphically represent how much share each value of data series occupies in the whole.

6. Which tab in excel will you use to create a chart?

Ans. We will use insert tab to create a chart in Excel. 

7. What is contextual tab?

Ans. The contextual tab contain information or options related to the selected object only. 

8. What is Sparkline and its use?

Ans. A Sparkline is a tiny chart in a worksheet cell that provides a visual representation of a data. 

Next>> "4 Learning HTML"