|
Free
computer Tutorials
|
![]() |
HOME
|
Stay at Home and Learn | |||||
Entering Data into an Excel Spreadsheet
So we've got a heading at the top of our spreadsheet, and some days of the week headings. We can now enter the chocolate bars. So click on cell A4 and type in the text "Mars Bars" (without the quote marks). Next enter Twix, Bounty and Others. In cell A9, enter the text "Day Totals". Your spreadsheet should now look like the one below: Time to enter some numbers now.
You now need to enter the rest of the numbers. Enter the following figures for the rest of the week: |
||||||
|
||||||
| Tuesday: | 2, 5, 3, 2 | |||||
| Wednesday: | 1, 3, 2, 2 | |||||
| Thursday: | 3, 2, 3, 2 | |||||
| Friday: | 3, 4, 4, 2 | |||||
| Saturday: | 2, 2, 1, 1 | |||||
| Sunday: | 5, 4, 4, 1 | |||||
|
When you've finished entering all the numbers, your spreadsheet will look like the one below:
OK, we can now do some adding up. To see how to enter formulas into a spreadsheet, click the Next Part below. |
||||||