CBSE Computer-Class-VIII-(Solved Exercise-2):

Solved Exercise:

Chapter-2

A. Multiple choice questions:
1. It contains everything inside the chart window, including all parts of the chart.
a. chart are b. legend c. data area d. line area
Answer: Chart area
2. It is a group of related values such as all the values in a single row in the chart.
a. data series b. chart series c. line series d. legend series
Answer: Data series
3. It shows the data series name corresponding to each data marker.
a. data b. chart c. line d. legend
Answer: Legend
4. It appear when the user selects the cell and tell the user what to enter.
a. data marker b. output message c. input message d. error message
Answer:Input message
5. It means to stop the movement of a particular row or column while scrolling a spreadsheet.
a. sorting b. freeze c. pause d. stop
Answer: Freeze

B. Write 't' for true and 'f' for false statements:
1. A chart can allow us to know the meaning behind our data.
Answer: T
2. An excel workbook can contain a large amount of data.
Answer: T
3. All chart types can plot both single and multiple data series except Pie chart.
Answer: T
4. A data marker can be a bar in a bar chart, a pie in a pie chart, or a line on a line chart.
Answer: T
5. In two-dimensional charts there are two axes the x-axis and the y-axis.
Answer: T

C. Fill in the blanks:
1. A ______________ is a tool in MS excel that is used to communicate our data graphically.
Answer: Chart
2. A ___________________ is a symbol on the chart that represents a single value in the worksheet.
Answer: Data marker
3. ________________ is a line that is used as a major reference for plotting data in a chart.
Answer: Axis
4. ________________ is a powerful feature that is used to set up certain rules to dictate what can be entered into a cell.
Answer: Data validation
5. We can freeze both row and column simultaneously using ______________________ option.
Answer: Freeze panes

D. Match the following:
1. Charts a. To make comparisons much easier.
2. Tick mark b. It is a small line intersecting an axis.
3. Chart text c. It is a label or title that we add to our chart.
4. Legend d. It is a key that identifies patterns, colors, or symbols.
5. Freeze e. It means to make a thing stable or stop the movement.
Answer:
1. -a
2. -b
3. -c
4. -d
5. -e
E. Answer the following questions in short:
1. What is a chart in MS excel?
Answer: A chart is a tool in MS Excel that is used to communicate our data graphically.
2. How to change a chart type?
Answer: Following are the steps to change chart type:
1. Select the chart
2. On the insert tab, in the charts group, choose column, and select clustered column.
3. How to switch row/column?
Answer:
1. Select the chart. We will notice that the chart tools contextual tab is activated.
2. On the design tab, click switch row/column.
4. Write down types of charts in MS Excel.
Answer:
1. Pie chat
2. Column chart
3. Line chart
4. Bar chart
5. Area chart
6. Scatter chart
5. What are data tools?
Answer: Data tools are simply tools which make it easy to manipulate data.
6. How to hide worksheets?
Answer: Steps for hiding worksheet:
1. Select the sheet which we want to hide.
2. Now click hide sheet from hide & unhide options from cell group.
3. Click on hide sheet option from hide and unhide.
F. Answer the following questions in detail:
1. Write down the steps to create a chart in MS excel.
Answer:
1. Select the table for which you want to insert chart.
2. Select chart from chart group on insert tab.
3. Chart will be inserted.
2. Write down the elements of a chart.
Answer: Element of chart:
1. Chart area
2. Data marker
3. Data series
4. Axis
5. Tick mark
6. Plot area
7. Gridlines
8. Legend
3. What is convert text to columns? Write down the steps to convert text to columns.
Answer: Sometimes we need to separate the contents of one excel cell into separate columns. For this we can use the convert text to column wizard.
1. Type the data in our worksheet.
2. Select the range with full names.
3. On the data tab, click text to columns.
4. Choose delimited and click next.
5. Clear all the check boxes.
6. Click finish.
4. What is data validation? How to create a data validation rule?
Answer: In MS Excel data validation is a powerful feature that is used to set up certain rules to dictate what can be entered into a cell.
Steps are:
1. Type the data in our excel worksheet
2. Select cell C2
3. On the data tab, click data validation.
5. How to freeze panes of a worksheet?
Answer:  Steps are:
1. Select a row.
2. On the view tab, click freeze panes.
3. Scroll down to the rest of the worksheet.
G. Define the following:
1. Plot area 2. Grid-lines   3. Tick marks
4. Data validation 5. Chart title 6. Error alert
Answer:
Plot Area:  It is the area where our data is plotted and it includes the axes and all marker that represent data points.
Grid-lines: These are the optional lines extending from the tick marks across the plot area.
Tick marks: It is a small line intersecting an axis.
Data validation: It is a powerful feature that is used to set up certain rules to dictate what can be entered into a cell.
Chart title: Chart title shows the name of the chart.
Error alert: If users ignore the input message and enter a number that is not valid, we can show them an error alert.