Chapter – 5 Introduction to Calc

Summary
1. Calc is an electronic spreadsheet package from the OpenOffice suits.
2.A spreadsheet allows entering data inrow and column fashion.
3.Getting Started with Calc The first thing you require to know is how to open the Calc. Follow the command sequence . Applications -> Office -> OpenOffice.org
4.A spreadsheet consists of multiple sheets; also called worksheets. By default, a new spreadsheet contains three worksheets, but the number of worksheets can be added or removed as per requirement.
5.Title Bar :- The title bar is located at the top. It shows name (title) of the current spreadsheet.It is
denoted as Untitled X.
6.Menu Bar :- The menu bar contains menus with commands for various tasks. Each menu item represents a separate submenu. This submenu is also called pull down menu.
7. Standard Toolbar :-this toolbar contains most frequently used standard commands from the File and Edit menus.
8.Formatting Toolbar :- The formatting toolbar presents the most frequently used commands for formatting content of a cell. This toolbar allows you to do formatting quickly.
9.Rows, Columns and Cells :- Each worksheet is divided into vertical columns and horizontal rows, forming cells. Both the rows as well as columns are numbered; columns with alphabet.
10.Workspace :- The empty grids of cells form an area where user’s data appears. While entering data, you may directly click on a specific cell (to make it active) and enter data as well as formula.
11.Zoom Tool :- The zoom tool can be used to zoom in/out a worksheet. You may zoom out your worksheet for better view.
12.Scroll Bar :- As the worksheet size is more than the computer screen (monitor) size, the Calc automatically provides you scroll bars on either sides of the sheet.

Multiple Choice Question

(1) Which of the following type of package does Calc refer to ?

(a) Spreadsheet                                                                (b) Multi-sheet 

(c) Double sheet                                                                (d) Cannot be determined

(2) Which of the following applications are not suitable for Calc ?

(a) Balance sheet preparation                                         (b) Result analysis

(c) Presenting an idea about a product                        (d) All of these

(3) Which of the following is the extension of a worksheet created in Calc ?

(a) ods                                                                                (b) odd 

(c) .xls                                                                                 (d) .obj

(4) Which of the following will be inserted in a worksheet if =starcalcteam() is inserted in a Calc cell ?

(a) Stars                                                                              (b) Photograph of Calc developer team

(c) Calc licence information                                             (d) Calc version information

(5) How can one calculate total of values entered in a worksheet in a Calc document ?

(a) By manual entry                                                            (b) By autosum 

(c) By formula                                                                       (d) All of these

(6) If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in formula ?

(a) The cell row and columns are changed at destination

(b) The cell row numbers are changed at destination

(c) The cell column numbers are changed at destination

(d) Nothing will be changed