The exercises below are to introduce concepts and features of a spreadsheet program such as Excel. Please note that there are alternative ways of creating a solution and your solution may be different from others.
Single argument and user developed functions
The table lists some functions that are commonly used in basic spreadsheet applications

function | purpose | =sum(B12:B18) | Add contents of range in B12 to B18 | =average((B12:B18) | Average the range | =count((B12:B18) | Count non zero values | =max(B12:B18) | Display the largest value | =min(B12:B18) | Display the smallest value | =B4*C4 | Multiplies the values | This is not an exhaustive list. See Excel menu command fx for a complete list of functions | User created | (…)+-*/^ | Mathematic operations brackets sum, subtract, multiplydivideexponentiation (power)=(3*(A5+B5)-C5)/2+D5^1.5 |
Exercise 1

Using appropriate formulae, complete the table below in Excel.

Item Name | price | Commission | Camera | $150.00 | $ 15.00 | Omega | $120.00 | | Kodak | $130.00 | | Sony | $140.00 | | F | $95.00 | | Canon | $150.00 | | JVC | $210.00 | | Total | $845.00 | | | | | Commission Rate: | 10% | |

Exercise 2
Complete the personal budget worksheet for the period indicated. Add your own figures where there are spaces. Extend the table to include a full calendar year.

Personal Budget | | | | Monthly Expenses | Jan | Feb | Mar | Rent | $850.00 | $850.00 | $850.00 | Groceries | $691.00 | $527.00 | $709.00 | Electricity | $85.00 | $54.00 | $73.00 | Water | $33.00 | $33.00 | $33.00 | Clothing | $250.00 | $75.00 | $163.00 | Transport | $85.00 | $95.00 | $140.00 | Entertainment | $125.00 | | | Totals | $2,119.00 | | | Fixed Income | $3,500.00 | | | Savings | | | |

Exercise 3
The table shows green