[home] Anguilla Library Computer Club

Spreadsheet Lesson #2

In lesson #1 you learned that a spreadsheet is a grid of rows (1,2,3...) and columns ( A,B,C...) that defines a rectangle of cells. Each cell (e.g. C3) can contain a number(100), some text such as "How Much Tax?" or a formula such as (c2*.28) or @sum(c3..c9). You get to the menus by typing a forward slash (/).

ACTIVITY: How Much Tax Would You Pay?

The assignment is to figure out what fraction of his income a hypothetical self employed person in the USA pays in taxes given a bunch of different taxes.

Different values are given as functions of other values. You need to calculate some intermediate values, and put only taxes in column 3 so you can add up that column.

Here are the numbers to plug into the spreadsheet:

Calculate the following: Hints: Computations can start with a left ( and end with a right ). * is multiply and / is divide. @sum(c3..c9) totals cells c3 through c9. @round(c12/12,0) rounds the result to a whole number. F1 key gives help.

Now change the Yearly Income value and see what happens. Advanced work: This spreadsheet would be better if the Federal and State income tax rates adjusted per your income, as in reality. Make Federal 10% above $10,000, 20% and $30,000 and 30% at $50,000. Make State 3% above $10,000, %6 at $30,000 and 13% at $50,000.