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:

What Your Spreadheet Should Look Like Now

Time to enter some numbers now.

  • For the Monday column, click on cell B4
  • Enter the number 1 then press the Return key on your keyboard
  • Enter the number 7 then press the Return key on your keyboard
  • Enter the number 8 then press the Return key on your keyboard
  • Enter the number 1 then press the Return key on your keyboard
  • Your spreadsheet should now look like this one:

An Excel Spreadsheet

You now need to enter the rest of the numbers. Enter the following figures for the rest of the week:

 
Computer Tutorials List
 
  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:

An Excel Spreadsheet with Numbers

 

 

OK, we can now do some adding up. To see how to enter formulas into a spreadsheet, click the Next Part below.

<-- Back to AutoFill | Move on to Entering Formula -->

<--Back to the Excel Contents Page