Using Formulas and Functions

Getting Started with OpenOffice 4

Chapter 4: Getting Started with Calc

< Previous Section

Next Section >

• What is Calc
• Parts of the main Calc window
• Open and Save CSV files
• Navigating within spreadsheets
  • Going to a particular cell
  • Moving from cell to cell
  • Moving from sheet to sheet
• Selecting items in a sheet or a spreadsheet
  • Selecting Cells
  • Selecting Columns and Rows
  • Selecting Sheets
• Working with Columns and Rows
• Working with Sheets
• Viewing Calc
• Entering data using the keyboard
• Speeding up data entry
• Validating cell contents
• Editing data
• Formatting data
• Auto-formatting cells and sheets
• Formatting spreadsheets using themes
• Using conditional formatting
• Hiding and showing data
• Sorting records
• Using formulas and functions
• Analyzing data
• Printing from Calc
  • Using Print Ranges
  • Selecting the Page Order, Details, and Scale
  • Page Breaks
  • Headers and Footers

< Previous Page

Next Page >

Using Formulas and Functions

You may need more than numbers and text on your spreadsheet. Often the contents of one cell depend on the contents of other cells. Formulas are equations using numbers and variables to get a result. The variables are cell locations that hold the data you require for the equation.

A function is a predefined calculation entered into a cell to help you analyze or manipulate data. All you have to do is add the arguments, and the calculation is automatically made for you. Functions help you create the formulas needed to get the results that you are looking for.

Refer to Chapter 7 in the Calc Guide for more information.