Spreadsheet Worksheet

1. What is the name of our spreadsheet program ?___Microsoft Excel______________

2. How many columns does it have across?_____256________(number)

3. How many rows does it have down?_ 65536______(number)

4. How many cells (squares) does it have?___16777216_________

5. At the bottom left you can switch to and from different sheets. How many sheets does it have? _____3______(number)

6. What does the Go To feature in the Edit menu do? Use it. It moves you to whichever cell you want to go to, all tyou need to do is type in the cell you want to be in.

7. What is a cell address? Look in the help index. Give an example. Address is the collum then the row, letter then number, tells you where it is on your spredsheet.

8. List 5 similarities with a word-processor.

1. you can type in it

2. make a chart

3. make a table

4. highlight, select

5. insert hyperlink

6. menu bars are pretty well the same

9. Using the toolbar discover how to insert a row and a column. you go "insert", columns or rows.

10. Enter the following table (ignore the first row and column)

What happens when you enter in a number that is different than when you enter in a word?

In Cell A6 enter the following: Total

In Cell B6 enter the following: =b1+b2+b3+b4+b5

this is a formula.

Can you calculate all of the totals? yes

Can you calculate the totals for each person also? (Paul's total is in F1) yes

What problem can you see when trying to add many numbers up? accuracy, time consuming, etc.

Change a number in your spreadsheet. What happened? Does this help you to understand why spreadsheets are called What-if tools? It is called a what-if tool becuase if you change one number when there already is an equation it just adjusts it to the new total.

Back To Index