1. What are functions in StarOffice Calc?

Functions are predefined formulae that are available in StarOffice Calc. These functions are available in StarOffice Calc in the pull down menu of Function Wizard window as shown in the figure. The functions available are divided into different categories. The categories are listed in the category pull down menu.

2. Give the steps for selecting a function in worksheet?

To select a function, go to Insert menu and Select the Function option. The Function Wizard dialog box appears. A list of all functions is displayed in the Function box when All is selected in the Category box. If a category is selected (e.g. Mathematical) the functions related to that category alone will be displayed in the function box. To select a function:
Select the category in the Category box.

Scroll down the list to find the function that wants. Click once on the function name to see a short description of that function on the right side of the window. Double – click on it to insert it into the worksheet.
The Function Wizard shortcut icon on the formula bar can also be used to select and insert functions.

3. How dates are calculated in the worksheet?

In spreadsheets, date calculations become very simple. Here, a number can be added to a date and arrive at a new date, find the difference between two dates and use a wide variety of function and formats to get that we wants.

For example, enter a date 03/04/05 in a cell, say A2. Remember that while entering dates the month always comes first. To calculate the date 79 days after this date, enter the formula= A2 + 79, in another cell, say A4. The date 05/22/05 appears in the cell.

4. Mention some of the formatting options available in StarOffice Calc.

Some of the formatting options available in StarOffice Calc are the following:

Bold: The Bold icon is used to display data in bold. To use this icon, highlight the cells and click on the icon.

Italics: This icon is used to display the data in italics.

Underline: This is used to underline the data in highlighted cells.

Change Font: This icon displays list of fonts that can be used. Select the font by clicking on it.

Font size: This icon is used to change the font size of the data. To do so, select the data and click on this icon.

Font Color: This can be used to change the font color.

Alignment: These are the Align Left, Align Center, Align Right and Justify icons. They are used to align the contents of cells.

Number Format-Currency icon: This icon will display the contents of the selected cells in currency format, that is with a $ in front and with two decimal digits.

Number Format-Percent icon: This icon will display the current contents in percentage format. Note that it multiplies the contents of the cell by 100 and displays the result with 2 decimals.

Number Format-Standard icon: This icon will display the contents of the selected cells in default format.

Number Format-Add Decimal and Number Format-Delete Decimal icons: They are used to increase or decrease the number of decimal digits that are to be displayed in the selected cells.

5. What is the use of auto format sheet facility of StarOffice Calc?

The AutoFormat Sheet facility of StarOffice Calc helps to format the worksheet with different predefined styles and colors. For example, the marks worksheet can be formatted as detailed below:

• In the Marks worksheet, select the cell from A1 to H7.

• Click on the AutoFormat option on the Format menu.

• The AutoFormat dialog box appears, displaying various predefined format styles. A preview for each style is also displayed in the box.

Select the Default format. The formatted worksheet is shown below.

6. How can you change the column width and row height of the worksheet?

To change the column width, select the column whose width that wants to change. Click on Format -> Column -> Width and type the new column width in the dialog box, which appears. Click on OK.

Another way to change the column width is to point to the line separating the column whose width wants to change from the next column. The mouse pointer becomes a double – headed arrow. Click and drag this pointer to the left to decrease the width and to the right to increase the width.
To change the row height, select the row whose height is to change. Right click on the selected row and select Height from the menu that appears. Type the new height and click on OK.

The row height of a particular row can be changed by clicking and dragging the line separating that row from the next.

7. Give the procedure to insert an empty cell or an empty row or a column in a worksheet.

To insert an empty cell or an empty row or a column in a worksheet already created, follow the procedure given below:
Click the Insert Cell from View -> Toolbar menu. A floating toolbar with four icons appears. These icons are Insert Cells Down, Insert Cells Right, Insert Rows and Insert Columns icons.
In order to insert an empty cell in a column and move the existing cells down, place the cursor in the cell that wants to insert the new cell and click on the Insert Cells Down icon.
          
In order to shift the content of a cell to the right and to create an empty cell, select the cell and click the Insert Cells Right icon.
     
In order to insert an empty row in a worksheet, select the row that wants to insert the new row and click the Insert Rows icon.
      
In order to insert a column, select the column where the column has to insert and click the Insert Columns icon.
         
8. Explain the procedure for deleting a cell, row or a column.

The procedure for deleting a cell (s), row or a column is given below:

Delete the contents specify that the contents to be deleted from a cell or cell range. Before deleting, first select the cell or range. Contents are only deleted from the selected cells or active cell. Similarly, if several sheets are selected, only the active one will be affected. To access this command choose Edit->Delete Contents.   

Click on the Delete all checkbox and click OK. To delete all contents from the selected cell range, select Delete Cells from the same menu. Select an option from the appeared window which specifies how the sheets are displayed after deleting cells. Shift cells up fill the space produced by the deleted cells with the cells underneath it. Shift cells left fills the resulting space by the cells to the right of the deleted cells.

If an entire row or column has to delete, then choose Edit -> Delete Cells. The Delete Cells dialog box will display Delete entire Row(s) or Delete entire Column(s). Clicking Ok will delete the row or column.

9. How can be inserting the pictures or special characters into the worksheet?

For inserting a picture or a special character in a worksheet follow the procedure given below:
Place the cell pointer in any cell, say B2.

Choose Insert -> Picture -> From File. The Insert Picture dialog box appears. In the File name combo box, type the path of the file that contains the picture or select the desired file directly from the gallery directory of StarOffice. After selecting the picture file click Open.

For inserting special characters, click the Insert →Special characters from the menu bar and select the desired special characters from the Special Character dialog box. For example, select ² from the Special Character dialog box and click the OK button.
 
10. Explain how drawing toolbar is using in StarOffice Calc.

StarOffice Calc provides the facilities for drawing lines, circles, ellipse, square, rectangle, etc. within a worksheet. For this purpose, click the Show Draw Functions icon in the Standard toolbar. The Draw Functions bar appears as shown below:

Any tool can be selected from this toolbar according to the requirement by following the procedure given below:

• Click on a tool. For example, to draw an ellipse in the worksheet, click the Ellipse tool. Keep the pointer (cursor) in the worksheet area at the desired location and drag it till the desired shape and size can get. The resultant screen is shown in the following figure.

11. Explain the icons available for inserting the objects in StarOffice Calc.

StarOffice Calc provides tools for inserting objects like charts, images from image editor, formula, etc. in a worksheet. For this purpose, click on the Insert Object from View -> Toolbar. A floating toolbar appears with the following icons:

Insert Chart Icon: This icon is used for presenting the data in the worksheet in form of charts of different kinds such as Bar Chart, Pie Chart, Lines, XY plot, etc.

Insert Formula Icon: This icon is used for inserting a formula in the worksheet for performing calculations.

Insert Floating Frame Icon:  This icon provides to generate a scrolling screen within a worksheet.

Insert Movie and Sound Icon: This icon is used to insert sound or video files into the current worksheet.

Insert OLE Object Icon: This icon is used to insert objects from other application into a worksheet.

Insert Applet Icon: This icon is used to import Applets written in Java programming language into the worksheet.

12. What is the purpose of chart and explain the procedure to draw a chart in the worksheet?

The purpose of chart is to visually present the data for easy understanding. To draw a chart, follow the procedure given below:

Select the data that wants to include in the chart.

Click on Insert → Chart or click on the Insert Chart icon.

The cursor becomes a + sign with a small picture of the graph. Place this cursor where the chart has to insert and click. The Autoformat Chart window appears.

It prompts to enter the area in the worksheet to be charted. Enter the range as C3 : F7 and click Next.
The next window, which appears will display the different types of charts that can be created along with a preview of each. Select the type of chart in which the data wants to present. The preview Window shows the chart. Click on Next. Click the Show text elements in preview check box if it is not selected.

For each type of the chart (say Pie, Bar, Column, etc.), there are different formats available. These formats are displayed in the next window. A preview of the each format is also displayed. Here, select the desired format. Click on Next.

In the next window, there is a provision to give a Title for the chart, Titles for X and Y axes and legends.

Click on Create. Now, the worksheet will look as shown below.

13. How can be working with multiple sheets in StarOffice Calc?

In StarOffice Calc, a spreadsheet contains multiple sheets. Each sheet has its own name and a list of sheets appears as tabs at the bottom of the window. To select a different sheet, click the tab with the sheet’s name. The tab of the selected sheet appears in white.

14. How the multiple sheets are dependent on each other?

Each sheet of a spreadsheet can be used entirely independently of the other sheets. To make them dependent on each other refer the data in another sheet or using the data from another sheet in calculations.
For example, enter the data in Sheet 1 and Sheet 2 and can do the calculations in Sheet 2. Then calculate the sum of the numbers in the cell A1 of Sheet 1 and A1 of Sheet 2 and store the result in A3 of Sheet 2. To do this, type the 3-D formula as = SUM (Sheet 1.A1; Sheet 2.A1).

15. Explain the procedure to print a worksheet in StarOffice Calc.

If the Print icon on the function bar (Standard toolbar) is clicked then all the data in all the sheets of the document will be printed. To print a part of the worksheet, select the range to be printed and click on Format -> Print Ranges -> Edit and select the print range. Now, if click on the Print icon then only the selected range will be printed. To remove the print range setting click on Format → Print Ranges -> Delete.

16. How can you print the worksheet using the print option under the File menu?

The Print option under the File menu can be used to print the worksheet. The Print dialog box appears. In the Print dialog box, under Print range choose the option All to print all the sheets in the document. Select the option Pages to specify the pages, which are to be printed. The Selection option allows printing only the selected area in a worksheet. The Page View option on the File menu can be used to preview a worksheet before printing.
           
17. How the worksheet can be printed with grids?

In order to print with the grids select the Page option from the Format menu. Click on the Sheet tab in the dialog box, which appears. Click the Grid check box to print the worksheet with gridlines.