Technical English

Navigation

Introduction
Spreadsheets
Spreadsheets p.2
Databases
Databases p.2
Vocabulary
Summary
Tasks
Questions
Test
Literature
Download

08 Spreadsheet, databases

Spreadsheets

Mathematic operations

Symbol	Meaning
+	plus
-	minus
*	multiplied by, times
/	divided by
=	equals, is equal to
:	to
%	per cent

Spreadsheets have many built-in functions that can be carried out by referring to the function by name. For example, =SUM(A1:A5) means: add up the values in the cell range A1 to A5.

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

Most spreadsheets programs can also generate graphics representations, such as line graphs, bar charts, pie charts, etc.

Typical applications of spreadsheets:

Calculating and managing accounts and other financial information
Performing calculations on data collected in experiments and surveys
Producing data from which graphs can be drawn
Income and expenditure
Sales forecasting
Staff hours, rates to pay and tax
Mortgage payments and interest rates
Number statistics