addresses in a formula, the worksheet reads the value inside the cell that you refer. This is a good practice of constructing a formula. Because, if you change any value, the worksheet recalculates it with a new value. After entering a formula the result is display as in Figure .
Figure . Constructing formula in Worksheet . Save, Close and Open the Worksheet: . .
Saving Worksheet The process of saving a worksheet is very similar to saving a document. Steps to save a worksheet are as follows: Step : File Save (or) Ctrl + S (or) Click “Save” icon on the standard tool bar. Step : If the worksheet has not been saved previously, the Save As dialog box will appear. Step : Type the name in “ File Name ” list box.
OpenOffice Calc Spreadsheets are stored with extension .ods by default. Step : Click “Save” button. After clicking the save button, the given file name is displayed in the title bar as shown in Figure . .
File Extension: A file extension or file name extension helps to identify the type of file. Following table gives the file extension of commonly used files. Familiar File Type Extension Text Files .txt Microsoft Word Documents .doc / .docx OpenOffice Documents .odt Microsoft Excel .xls / .xlsx OpenOffice Calc .ods Microsoft PowerPoint .ppt / .pptx OpenOffice Impress .odp Executable Files / Applications .exe Web Pages .htm / .html Portable Document Format .pdf Photos .jpg / .jpeg (Joint P h o t o g r a p h i c Experts Group) Animated Images .gif (Graphic Interchange Format) Audio .mp3 Audio / Video .mp4 N ote: The saved file is stored in the " Documents" folder by default. What is save?
Technically saving is a process of transferring or shifting contents from primary memory (RAM) to Secondary storage medium such as Hard disk, Pen drive, memory chip etc. . . Auto Save: OpenOffice saves a file at regular intervals.
This is called as “Auto Save” feature. The default time interval is minutes. It can be reduced even to one minute.