Spreadsheet Note
A spread sheet consists of a series of row and columns
Each column is named with an uppercase letter starting with A
Each row is numbered is numbered, starting with 1
An 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 occurs
A 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.
Each column is named with an uppercase letter starting with A
Each row is numbered is numbered, starting with 1
An 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 occurs
A 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.