## Spreadsheet Note

A

Each

Each

An intersection of a row and column is called a

A

**spread sheet**consists of a series of row and columnsEach

**column**is named with an uppercase letter starting with AEach

**row**is numbered is numbered, starting with 1An intersection of a row and column is called a

**cell**, the cell is given its**name or address**from the letter of column and the number of the row that the intersection occursA

**range**is any rectangular area of the spreadsheet. It can contain parts any number of rows and parts of any number of columns, providing its shape is rectangular.## Numbers

A number is a value that can be operated on by any mathematical operators ( addition, subtraction, division, multiplication etc.)

In a spreadsheet, numbers can be formatted as

In a spreadsheet, numbers can be formatted as

- number
- percent
- scientific
- financial (dollars and cents), no dollar sign, but negative numbers are in parentheses ()
- currency -- contains a $ sign
- date and time

## Literals

A literal is a string, a collection of letters numbers and special characters.

Normally strings are not operated on by mathematical operators

Strings however do have their own set of operators and functions that can operate on them.

Normally strings are not operated on by mathematical operators

Strings however do have their own set of operators and functions that can operate on them.

## Formula

The first character of a formula is the equal sign = followed by any number of operators, functions and cell address.

## Functions

A function is built in to the spreadsheet.

Spreadsheet applications have numeric functions that include:

Spreadsheet applications have numeric functions that include:

**sum**(a list of cell and ranges to add together)**average**(a list of cell and ranges to add together)**minimum**(a list of cell and ranges to add together)**maximum**(count(a list of cell and ranges to add together)

- len(a cell)

## Relative vs Absolute Cell Addressing

By default, cell addresses are relative.

The user must modify a cell's address to make it an absolute cell address.

You tell a cell's address is absolute if it contains one or more dollar signs

When entering a cell's address, the F4 function key will cycle through all possible absolute cell addresses for the cell.

The user must modify a cell's address to make it an absolute cell address.

You tell a cell's address is absolute if it contains one or more dollar signs

When entering a cell's address, the F4 function key will cycle through all possible absolute cell addresses for the cell.