Skip to main content

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:

     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.

Labels:

Comments

Post a Comment

Popular posts from this blog

Beginners PHP  -This is a complete and free PHP programming course for beginners. It's assumed that you already have some HTML skills. But you don't need to be a guru, by any means. If you need a refresher on HTML, then click the link for the Web Design course on the left of this page. Everything you need to get started with this PHP course is set out in section one below. Good luck! Home Page > PHP Section One - An Introduction to PHP 1. What is PHP and Why do I need it? 2. What you need to get started 3. Installing and testing Wampserver 4. Troubleshooting > PHP Two - Getting Started With Variables 1. What is a Variable? 2. Putting text into variables 3. Variables - some practice 4. More variable practice 5. Joining direct text and variable data 6. Adding up in PHP 7. Subtraction 8. Multiplication 9. Division 10. Floating point numbers > PHP Three - Conditional Logic 1. If Statements 2. Using If Statements 3....
Post a Comment
Read more

PRATYUSHA HOME

Hi interesting readers, Prathysha NGO, Chennai. Bala gurukul orphange, chennai. Pratyusha support, Hyderbad. Krr oldage home, Vizag. Disa foundation.......................................................... so on..................... Join hands with us for a good cause. Thank you all. Contact  us on our  whatsapp no:  8939374254    for the more details. You can pay through Paytm scanner. for each donor we will give an online PDF book as a gift. Thank you Pratyusha Home
Post a Comment
Read more
Visual Basic .NET Contents Page   -This computer course is an introduction to Visual Basic.NET programming for beginners. This course assumes that you have no programming experience whatsoever. It's a lot easier than you think, and can be a very rewarding hobby! You don't need to buy any software for this course! You can use the new FREE Visual Basic Express Edition from Microsoft. To see which version you need, click below: Getting the free Visual Studio Express - Which version do I need? > VB .NET One - Getting Started   1. Getting started with VB.NET 2. Visual Basic .NET Forms 3. Adding Controls using the Toolbox Home Page 4. Adding a Textbox to the Form 5. Visual Basic .NET and Properties 6. The Text Property 7. Adding a splash of colour 8. Saving your work 9. Create a New Project >   VB .NET Two - Write your first .NET code   1. What is a Variable? 2. Add a coding button to the Form 3. Writing y...
Post a Comment
Read more