PART-B Unit-4 Electronic Spreadsheet-LibreOffice(2025-26)
Chapter-5 Create and Insert Different types of charts in a spreadsheet
A. Fill in the Blanks
1.A _____ represents data in a visual format for easy understanding.
Answer: chart
2._____ uses vertical bars to represent data and is the most frequently used chart for comparing information.
Answer: Column chart
3.In _____, each value is shown as a slice of the pie.
Answer: Pie chart
4.The _____ identifies which data series each colour on the chart represents.
Answer: legend
5.The horizontal axis is also known as the _____.
Answer: x-axis
B. True or False
1.Line chart shows data trends over time.
Answer: True
2.Scatter chart works like a column chart but uses horizontal bars.
Answer: False
3.Pie charts are ideal for showing percentages.
Answer: True
4.Line charts are not suitable for showing trends over time.
Answer: False
5.Chart type can be changed from Chart Type option.
Answer: True
C. Choose the Correct Option
1.Which chart is best for showing trends over time?
A. Pie chart
B. Line chart
C. Bar chart
D. Scatter chart
Answer: B. Line chart
2.Primary purpose of a pie chart:
A. To compare categories
B. To show proportions of a whole
C. To identify relationships
D. To show trends
Answer: B. To show proportions of a whole
3.What does a scatter chart display?
A. Data points showing relationships
B. Proportion of data
C. Vertical bars
D. Filled area
Answer: A. Data points showing relationships
4.Which chart compares categories side-by-side?
A. Line chart
B. Pie chart
C. Bar chart
D. Scatter chart
Answer: C. Bar chart
5.What feature distinguishes an area chart?
A. Bars
B. Data points
C. Slice
D. Filled area below line
Answer: D. Filled area below line
D. Short Answer Questions.
1. Define the term ‘chart’.
Answer:
A chart is a visual or graphical representation of numerical data that helps us understand information more clearly. Instead of reading long tables and numbers, a chart shows the data in the form of bars, lines, or slices, making comparison, analysis, and understanding much easier and quicker.
2. How can you create a chart?
Answer:
To create a chart, first select the data you want to present visually. After selecting the data, go to the Insert menu and choose the Chart option. A list of different chart types will appear. Select the chart type you need, such as column, pie, line, or bar chart. The software will automatically create the chart based on your selected data.
3. What is the difference between a column chart and a pie chart?
Answer:
A column chart uses vertical bars to compare values across different categories. It is useful when you want to show differences or changes between groups.
A pie chart, on the other hand, shows data in the form of slices of a circle. It represents how each part contributes to the total or whole. Pie charts are mainly used to show percentages or proportions.
In short, column charts are best for comparison, while pie charts are best for showing parts of a whole.
4. Can you have both column and line charts in the same chart?
Answer:
Yes, you can have both column and line charts together in one chart. This is called a Combo Chart. A combo chart helps when you want to compare two types of information at the same time—for example, showing sales as bars and profits as a line on the same chart. It makes it easier to analyze two types of data in one place.
5. How can you change the title of a chart?
Answer:
To change the title of a chart, click directly on the current chart title. The text box will become editable. You can then type the new title that better describes your chart. You can also change the title using the Chart Tools or Layout tab where the “Chart Title” option is available. This helps in giving your chart a clear and meaningful heading.
SOME OTHER LINKS YOU MAY LIKE:
No comments:
Post a Comment