MS EXCEL CHARTS



A. Tick (✓) the correct option.



---


1. A chart that compares proportions is:


Options:


a. Column Chart


b. Pie Chart ✅


c. Area Chart


d. Line Chart



✅ Answer: b. Pie Chart


📝 Explanation:

A Pie Chart is used to show proportions or percentages of a whole. It is circular and divided into sectors, each representing a proportion of the total. It visually displays how parts make up a whole.



---


2. A chart that shows the changing trends in data:


Options:


a. Column Chart


b. Pie Chart


c. Area Chart


d. Line Chart ✅



✅ Answer: d. Line Chart


📝 Explanation:

A Line Chart is ideal for showing trends over time. It uses points connected by lines to show changes in values, making it perfect for displaying data that changes continuously (like sales per month, temperatures, etc.).


Here are the questions and answers from the image (Page 49 – ICSE Class 8, Charts in Excel 2019), written clearly and in a student-friendly way:



---


2. Distinguish between the column chart and bar chart.


✅ Answer:


Column Chart Bar Chart


Displays data using vertical bars. Displays data using horizontal bars.

Useful when comparing data over time. Useful when comparing data across categories.

X-axis shows categories, Y-axis shows values. Y-axis shows categories, X-axis shows values.




---


3. What is the difference between the chart area and plot area?


✅ Answer:


Chart Area: It includes the entire chart, such as the plot area, titles, legends, and labels.


Plot Area: It is the part of the chart where the actual graph (bars, lines, or slices) is drawn.




---


4. Write the steps to insert the chart title.


✅ Answer:


1. Click on the chart to select it.



2. Click on the Chart Elements button (➕ sign).



3. Check the Chart Title box.



4. Click on the text box that appears and type your desired title.





---


5. How will you format the plot area background?


✅ Answer:


1. Right-click on the Plot Area of the chart.



2. Click on Format Plot Area.



3. In the Format pane, choose Fill options like Solid Fill, Gradient, or Picture.



4. Select the background color or style you want.





---


6. Write the steps to format the legend.


✅ Answer:


1. Click on the Legend in the chart.



2. Right-click and select Format Legend.



3. Choose the position (top, bottom, left, right).



4. Change the font, size, color, or background as desired.





A. Tick (✓) the correct option



---


3. The ______ tab provides various chart style options.


Options:


a. Formulas


b. Format


c. Design ✅


d. Insert



✅ Answer: c. Design


📝 Explanation:

The Design tab in Excel becomes available when a chart is selected. It provides options to change chart type, layout, style, and move or resize the chart.



---


4. ______ identifies each data series.


Options:


a. Legend ✅


b. Data Label


c. Chart Area


d. Plot Area



✅ Answer: a. Legend


📝 Explanation:

The Legend tells you what each color, pattern, or bar in the chart represents, identifying different data series.



---


5. We can print a chart by clicking on the ______ tab.


Options:


a. Home


b. File ✅


c. Charts


d. Data



✅ Answer: b. File


📝 Explanation:

To print any document or chart in Excel, you go to the File tab, then click on Print.



---


B. Write T for True and F for False statements



---


1. A chart is used to represent data graphically or pictorially.

✅ True (T)



2. In a line chart, the data series is a single line.

✅ True (T)



3. The plot area is the white space around the chart.

❌ False (F)

Explanation: The plot area is where the chart data (bars, lines, etc.) is actually plotted — not the white space around the chart.



4. To make a chart, we first need to enter the data into a worksheet.

✅ True (T)



5. Format tab changes the chart type and the data source of the chart.

❌ False (F)

Explanation: The Design tab (not Format tab) is used to change the chart type and data source. The Format tab is used to style chart elements.





---


C. Fill in the blanks using the words in the box


(x-axis, Chart, y-axis, Plot area, Bar chart)



---


1. It is easier to compare data, understand patterns with the help of a Chart. ✅



2. Bar chart is used to compare pairs of value. ✅



3. The horizontal or category axis is called the x-axis. ✅



4. The vertical or value axis is called the y-axis. ✅



5. The Plot area is the chart’s background, where the gridlines are drawn. ✅





---


D. Subjective Question



---


Q. Explain the different components of a chart.


✅ Answer:


The main components of a chart are:


1. Chart Area – The entire chart, including all elements.



2. Plot Area – The area where data is graphically represented (bars, lines, etc.).



3. X-Axis (Horizontal Axis) – Displays the categories of data.



4. Y-Axis (Vertical Axis) – Displays the values or numbers.



5. Legend – Identifies different data series using colors or patterns.



6. Data Series – The actual data points plotted in the chart.



7. Chart Title – Displays the heading or name of Chart Title


Comments

Post a Comment

Popular posts from this blog

class 8 computer chapter 5

1. Java Keyword 👉 Definition: Keywords are reserved words in Java that have special meaning to the compiler. They cannot be used as identifiers (like variable names). 👉 Example: class , public , static , void , int , if , else public class Example { public static void main(String[] args) { int number = 10; // 'int' is a keyword if(number > 5) { // 'if' is a keyword System.out.println("Number is greater than 5"); } } } 2. Java Token 👉 Definition: A token is the smallest unit in a Java program. 👉 Types of Tokens: Keywords Identifiers Literals (numbers, characters, strings) Operators ( + , - , * , / ) Separators ( ; , {} , () ) 👉 Example: int a = 10; // Tokens: int, a, =, 10, ; 3. Java Data Types 👉 Definition: Data types define the type of data a variable can store. Two categories: Primitive Data Types (8 types) byte → 1 byte (e.g. byte b = 100; ) short → 2 bytes (e.g...
Read more

CLASS 8 COMPUTER

  Questions & Answers 1. A step-by-step procedure to solve a particular problem. Answer: b. Algorithm Explanation: An algorithm is a set of ordered steps or instructions designed to perform a specific task or solve a problem. Flowcharts and programs are based on algorithms. 2. Pictorial representation of steps to solve a specific problem. Answer: d. Flowchart Explanation: A flowchart uses symbols and arrows to represent the sequence of steps visually, making it easier to understand the process. 3. A shape used to connect different shapes in a flowchart. Answer: a. Arrow Explanation: Arrows indicate the flow of control or sequence between steps in a flowchart. 4. A rounded shape in a flowchart is used to show the: Answer: d. Start and Stop Explanation: Ovals (or terminals) in flowcharts represent the starting and ending points of the process. Part A: MCQ Q5. Which of the following is true about pseudocode? Options: a. It...
Read more

Class 5 computer chapter 4

   A. Multiple Choice Questions Which of the following actions cannot be performed on the shapes? Answer: d. Crop ✅ Rajan wants to rotate an image, which handle should he use after selecting the image? Answer: a. Rounded arrow shaped handle ✅ Which of the following is not an example of Illustration? Answer: b. Image ✅ Which of the following is not a video playback setting? Answer: b. Video Border ✅ ___ creates a graphical illustration while ___ is artistic text. Answer: a. SmartArt, WordArt ✅ Table can be inserted in the slide using Answer: d. All of these ✅ B. Fill in the blanks (Options: Chart, Eyedropper, Trimming, Layout, SmartArt) Inserting/deleting rows/columns in a table can be done using Layout. ✅ To insert Chart you need to enter the data. ✅ Trimming removes unwanted starting and ending part of an audio or a video. ✅ List, Process, Cycle – these are the categories of SmartArt. ✅ Eyedropper picks a colour from another part of the slide. ✅ C. Answer the following How wi...
Read more