The Green($) for Green
Spreadsheet Exploration
- Open your spreadsheet program, on your computer.
Are you new at using spreadsheet software? Here’s some background information:<
- Cells are the boxes in the spreadsheet
- In a cell you can enter a numerical value, written labels and formulas
- Similar to a chart, the cells are arranged into columns and rows
- To refer to a cell by its name, use the letter for the column and the number for the
row that meet at that cell (e.g. “B3” is where column B and row 3 meet at a cell)
- Create the following spreadsheet, using your company name and address.
| |
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
| 1 |
Name |
|
|
|
|
|
|
|
|
|
invoice |
| 2 |
Street |
Address |
|
|
|
|
|
|
|
|
24310 |
| 3 |
City, |
Province |
|
|
|
|
|
|
|
|
|
| 4 |
postal |
code |
|
|
|
|
|
|
|
|
|
| 5 |
|
|
|
|
|
|
|
|
|
|
|
| 6 |
|
|
|
|
|
|
|
|
|
|
|
| 7 |
plant |
name |
|
Common |
Name |
|
Unit |
price |
Quantity |
|
Total |
| 8 |
|
|
|
|
|
|
|
|
|
|
|
| 9 |
|
|
|
|
|
|
|
|
|
|
|
| 10 |
|
|
|
|
|
|
|
|
|
|
|
| 11 |
|
|
|
|
|
|
|
|
subtotal |
|
|
| 12 |
|
|
|
|
|
|
|
|
PST |
|
|
| 13 |
|
|
|
|
|
|
|
|
GST |
|
|
| 14 |
|
|
|
|
|
|
|
|
Labour |
|
|
| 15 |
|
|
|
|
|
|
|
|
|
|
|
| 16 |
|
|
|
|
|
|
|
|
Total |
Cost |
|