Spreadsheet basics

A spreadsheet program helps you manage personal and business finances. Spreadsheets, or worksheets, are mathematical tables which show figures in rows and columns.

A cell can hold three types of data: text, numbers and formulae.

Formulae are entries that have an equation which calculates the value to display; we can use them to calculate totals, percentages, discounts, etc.

Spreadsheets have many- built-in functions, pre­written instructions that can be carried out by referring to the function by name. For example, =SUM(D2:D7) means add up all the values in the cell range D2 to D7.

The format menu lets you choose font, alignment, borders, etc.