Class IX Chapter 14 Advanced Features of a Spreadsheet

Chapter 14- Advanced Features of a Spreadsheet

Fill in the blanks:

1. Sort

2. Conditional

3. Filter

4. Charts

5. Pie

Multiple choice questions:

1. Design Tab

2. Add Level

3. Doughnut

4. Chart label

5. All of these

Very short answer questions:

1. Convert to range

2. Either Delhi or Mumbai

3. Legend

4. Design, Layout, Format

5. Move chart

Short answer questions:

1. Sorting arranges the given data, which may be textual, numerical, or alphanumerical in a specified order.

   Filtering is a quick and easy way to find and work with parts of data in a range.The filter feature selectively blocks out the data you do not want to see.

2. Custom filtering is the process of filtering data on specific conditions.

    Click on Clear Filter option to remove custom filtering.

3. Conditional formatting is a feature in MS Excel that sets a cell's format according to the conditions that are specified. This feature can be used to display numbers in cells in a particular colour, depending on whether they are greater than, equal to, or less than a certain number.

4. Line chart-Page 327 (with diagram) , Area chart- Page 328 (with diagram)

5. Data series, X-axis, Y-axis, Chart title, Axis title, Chart area, Plot area, Legend, Grid lines, Data Label.

Long answer questions:

1. Page 319-write all 5 steps.

2. Sorting data on one column- page 321- all 4 steps.

    Sorting on more than one column- page 322- all 8 steps.

3. A pictorial representation of data is chart.Charts make it easier to understand large amounts of data.It helps to 'see' the relationship between different parts of the data.

Steps to create a chart- page 330- all 5 points.

4. Scatter chart- page 327 & 328 - with diagram

5. Page 331- changing the design of a chart- write first 2 points ( point 1 and 2)

Application based questions:

1.

   (a) Logical ability-filtered records- roll 4- chetna

        GK - filtered records- Roll 2- Ashish, Roll 3- Beena, Roll 6- Reema, Roll 8- Yogesh

   (b) Beena, Chetna, Yogesh, Bijoy, Reema, Biswas, Anu, Ashish

   (c) Beena, Chetna, Yogesh, Bijoy, Ashish, Biswas, Reema, Anu

   (d) Nil

   (e) Beena,Bijoy,Biswas

2.

   (a) Bar chart

   (b) Top-centre

   (c) X-axis-> Number of medals, Y-axis-> Country Name

   (d) USA

   (e) Japan and France

3.

  (a) Line chart

  (b) Bottom

  (c) Comparison of Profit

  (d) Company B

  (e) (i) Line chart

       (ii) Column or bar chart

4.

  (a) Column chart

  (b) Literacy rate in different states(in %)

  (c) X-axis-> States

       Y-axis-> Literacy (in %)

  (d) Yes, on right-hand side.

  (e) Highest-> Kerala, Lowest-> Tamil Nadu

  (f) Goa

5.

 (a) Pie

 (b) and (c) Not Attempted ( Image is not clear)