Class IX Chapter 12 ( Introduction to Spreadsheet)

Class IX (CH - 12 Introduction To Spreadsheet)

I. Objective Type questions

A. Fill in the blanks:

1. 3

2. AB

3. Formula

4.all

5. Auto Filled

B. Multiple Choice Question:

1. Active Cell

2. Name Box

3. F8

4.Merge and Center

5. Top

Descriptive:

A. Very short answers:

1. MS Excel.

2. Insert

3. E7

4. A1:E5

5. Auto fill

B. Short question answers:

1. Workbook is a collection of worksheets.

    Worksheets : Each page of the workbook containing a grid of rectangular cells made up of rows    and columns.

2. Numbers, Text, Formulae

3. It is used to cancel the data entry without pressing the DELETE key.

4. It refers to the position at which data is placed within the boundary of a cell.Numbers are always right-aligned and text is always left-aligned.

5. two ways are- in the CUSTOM Lists dialog box or by importing a list.

C. Long question answer:

1. A range is a rectangular block of contiguous cells, i.e. , cells that touch each other, especially along a line. The two methods of selecting a range of cells are;

      (i) Using Extend selection mode(Page 277 -write all 4 steps)

     (ii) Using Go To Command (Page 277 - write all 6 steps.)

2. Two ways of Editing cells are :

      (i) By overwriting (Page 278-Write the complete paragraph )

      (ii) By Partial Modification(Page 278- Write the complete paragraph)

3.  Page 281- Changing row height and column width- write all 4 steps.

4.  A custom list is list that has a series or a list already stored and can be used just like the Autofill    feature as and whenever necessary.

 Method of creating a custom list: Page 287- write 1st three steps(To add a list in custom list)

5. Page 286- first 2 steps.

Application based questions:

1

   (a) Centre Alignment

   (b) Merge and Centre

   (c)  Left

   (d) Fill colour

   (e) Bold

 

   (f) All borders

2.

   (a) A3- 5

        A4- 6

        A5- 7

    (b) B2-Mon, B3-Tue, B4-Wed, B5-Thus, B6-Fri, B7-Sat

    (c) C3-July, C4-Oct

3. Shift key, range of cells, last cell, shift key, activate, arrow

4.

   (a) Cut or copy

   

   (b) Either click outside the cell or click on 'Undo' or press 'Ctrl+Z'

   (c) Delete entire row

   (d) Ctrl+Z or Undo

5.

   (a) By dragging the column line

 

   (b) Formula Bar

   (c) Merge and centre