STD IX Ch. 4. Question Answers

Ch. 4. ICT SOFT TOOLS Spreadsheet        

Q.1.Fill in the Blanks:

1.    ______ is software in Office pack which is specifically used for accounts maintenance.

2.    _____ chart in Excel is used for Scientific data analysis.

3.    In Excel ________ facility is used to complete one entry at a time.

4.    In excel cells are formed by _________& columns.

5.    To add the values in a selected row, columns or cells ________option is used in Excel.

6.    Calculations become much simpler when we arrange our data in the form of a________.

7.    ________ can transform the worksheet data to show comparisons, patterns and trends.

8.    The three parts of the Ribbon are_______, _________ and ___________.

9.    We can change the format of the displayed date in ________.

10.  A Command is a button, a menu or a box where we can enter ____________.

Ans. (1) EXCEL 2007, (2) Histogram, (3)form, (4) rows, (5) F2, (6) spreadsheet, (7) Chart,

(8) Tabs, Groups, Commands, (9) Excel, (10) information.

Q.2.State whether the following statements are TRUE or FALSE.

1.    Simple cell is the one in which information is being entered.

2.    In excel, if the text is too long, it is displayed in the right side of the cell as if they are empty.

3.    By default, Excel enters time as AM.

4.    Excel 2007 considers leading plus sign.

5.    In excel, when we select Wrap text option, all the text in a single cell is displayed on multiple lines.

6.    All the calculations can be performed automatically and accurately every time the data is changed.

7.    We cannot rely on electronic spreadsheet software programs to record, organize and analyze.

8.    Worksheet is customizable visual system of tools and commands, made up of rows and columns.

9.    Excel is fantastic to work with numbers and mathematics.

10.  In Ribbon, Commands are organized in logical groups, which are collected together under tabs.

Ans. (1) True, (2) True, (3) False, (4) True, (5) True, (6) True, (7) False,(8) True,

(9) True, (10) True.

Q.3. Match the Following:

(A)                                                       (B)

(1) Spreadsheet                      (a) Sum of all the numbers

(2) Cell                                    (b) Stored in a workbook

(3) Clipboard Group                          (c) Pictorial presentation

(4) L button                            (d) Box in the grid

(5) Worksheet                        (e) Copy, Paste & Command

Ans. (1 - c), (2 - d), (3 - e), (4 - a), (5 - b).

Q.4. Answer the following:

1.  How one can get help on any topic in Exce12007?

Ans: PRESS Fl.

2. List the system requirements to install Excel 2007 on your computer.

Ans: • Computer and processor: 500 megahertz (MHz) processor or higher.

• Memory: 256 megabyte (MB) RAM or higher.

• Hard disk: 2 gigabyte (GB); a portion of this disk space will be freed after installation if the original download package is removed from the hard drive.

• Drive: CD-ROM or DVD drive.

• Display: 1024x768 or higher resolution monitor

• Operating system: Microsoft Windows XP with Service Pack (SP) 2, Windows Server 2003 with SPI, or later operating system 2.

1.    List various uses of Excel 2007.

Ans: The various uses of Excel 2007 are as follows :

(i) With the help of suitable formulae, all the calculations can be performed automatically and accurately every time the data is changed.

(ii) There is no wastage of time whenever we need to redo the same calculation again and again just by changing values in one of the cells.

(iii) The pictorial representation of the data in the form of various types of charts is possible with electronic spreadsheet programs.