CBSE Computer-Science Class-VIII Exercise-4(2022-23):

Computer Science

Class-VIII

Chapter-4 Creating Charts in MS Excel

A. Fill in the blanks:

1. A ________ chart shows trends in data at equal intervals.

Answer: Bar

2. ______ are the pictorial representation of data.

Answer: Charts

3. The XY chart is sometimes referred to as a _______ chart.

Answer: Scatter

4. A bar chart can be called a _______ chart drawn sideways.

Answer: Column

5. Before you print, you must finalize the _____ of the page.

Answer: Format

6. _______ gridlines help to display gridlines at major intervals.

Answer: Major

B. Write whether true or false:

1. A radar chart plots data in circles.

Answer: True

2. The Axes tab specifies the type of scale you want to use.

Answer: True

3. The page setup is an option of the Edit menu.

Answer: False

4. The Print Preview option displays the current page of the worksheet.

Answer: True

5. Margins can also be adjusted through the preview window.

Answer: True

C. Tick the correct option:

1. The numerical information used as a basis for reasoning, discussion or calculation.

a. Data                        b. Chart

Answer: Data

2. Which chart shows data change over a period of time or illustrates comparison among items?

a. Line chart              b. Column chart

Answer: Column chart

3. Which chat is used to plot data for a single data series?

a. Area chart            b. Pie chart

Answer: Pie chart

4. Which of them is an example of the 3-D surface chart?

a. Cylinder                b. Topographic map

Answer: Topographic map

5. It shows the relationship of parts to a whole.

a. Area chart            b. Doughnut chart

Answer: Doughnut chart

6. It allows you to choose page size, margins, headers, footers and print options.

a. Page setup            b. Print Preview

Answer: Page setup

D. Answer the following questions:

1. Explain the different types of charts possible in MS-Excel.

Answer: Different types of charts in MS-Excel:

1. Column Chart: This chart shows data change over a period of time.

2. Bar Chart: This chart also illustrates comparisons among individual items.

3. Line Chart: This chart are useful for depicting the change in a value over a period of time.

4. Scatter Chart: This chart plots each point with a marker and connects the points in each series with a line.

5. Pie Chart: This chart is used to plot data for a single data series.

2. What is the way to create a chart?

Answer: Steps to create a chart:

1. Select the range of data for which you want to make a chart.

2. Select the chart option from the Insert menu.

3. Choose the chart best suited for your data.

4. Click on Next button to display the chart source data dialog box. In this dialog box you can change the data labels for the chart.

3. What do you know about the elements of chart formatting toolbar?

Answer: The chart formatting toolbar has the following elements:

Chart objects List: To select an object on the chart to format, click the object on the chart or select the object from the chart objects list and click the format button.

Chart Type: Click the arrow head on the chart type button to select a different type of chart.

Legend Toggle: Show or hide the chart legend by clicking this toggle button.

Data Table view: Display the data table instead of the chart by clicking the data table toggle button.

4. How can you print worksheets?

Answer: To print worksheet follow the steps:

1. Click the print button on the standard toolbar to print the currently active worksheet.

2. To print only a range of data, select the range before clicking the print button. Before you print, you must finalize the format of the page. 

5. How can you use the Page setup option? Explain.

Answer: Page setup allows you to choose page size, margins, headers, footers and print options.

1. Choose the page setup option from the file menu.

2. MS excel offers you the following options to solve the problem:

* You can change the orientation of the page to Landscape.

* You can use the scaling option and reduce the print size in such a way that all the columns fit in the page.

* You can select to fit the page or pages within a certain number.

* You can also change the size of your paper.

3. Click on the OK button to apply.

You may Like:

CBSE Computer-Science Class-VIII Exercise-1(2022-23):

CBSE Computer-Science Class-VIII Exercise-2(2022-23):

CBSE Computer-Science Class-VIII Exercise-3(2022-23):