Basic Excel 2003: Developing Your First Spreadsheet - Developing your first worksheet can be an exciting time but there are a few things you need to be aware of. When entering data into a cell, the data is normally going to be text, numbers or a formula. If you enter a text or numeric value into the cell, the value isn’t going to change. These values are known as Constant Values.
|
|
Business Related Topics...
Computer Related Topics...
Entertainment, Recreation & Sports Related Topics...
Health & Fitness Related Topics...
Home & Family Related Topics...
Shopping Related Topics...
Would you like to submit articles to our site? Have a question or a problem?
You are here: DIME Home > Business > Basic Excel 2003: Developing Your First Spreadsheet
Developing your first worksheet can be an exciting time but there are a few things you need to be aware of. When entering data into a cell, the data is normally going to be text, numbers or a formula. If you enter a text or numeric value into the cell, the value isn’t going to change. These values are known as Constant Values.
If you enter a formula in a cell, the values in that cell may change. For example the formula may contain references to cell addresses and if you change the value in one of those cell addresses it will change the result because Excel will recalculate the value.
Author: Amit Malhotra
Date: Aug 6, 2009 - 6:55:26 AM
Developing your first worksheet can be an exciting time but there are a few things you need to be aware of. When entering data into a cell, the data is normally going to be text, numbers or a formula. If you enter a text or numeric value into the cell, the value isn’t going to change. These values are known as Constant Values.
If you enter a formula in a cell, the values in that cell may change. For example the formula may contain references to cell addresses and if you change the value in one of those cell addresses it will change the result because Excel will recalculate the value.
Entering Data
The golden rule in using Microsoft Excel is that before you enter a value into a cell you must make the cell active. Once you have done that, you can enter the data required.
Once you have completed entering the information into the cells you must tell Excel that you are happy with your entry. There are a few ways to achieve this:
1. Click on the Enter Button on the Formula Bar
2. Press the Enter Key
3. Click on another cell
4. Press an Arrow Key
One thing to note is that when you press the Enter key to complete the data entry, the cell below the cell you entered data in will be selected. This is the default way the Enter key works in Microsoft Excel however you can tell Excel to move to the left, right and up. To achieve this you select the Tools menu, then select the Options command and the Options dialogue box will be visible.
Select the Edit menu and change the value in the drop down box to the value you require. If you want to turn this feature off de-select the Move selection after Enter check box.
Entering Text
Entering text is a straightforward process, select the cell and then type the text. Now text is considered to be letters, numbers and any other characters that you can print using your printer.
There are a number of issues that must be understood when utilising Text in combination with numbers. If you type in text with a number eg 89 Albert Street or Target Budget 2004, Microsoft Excel will treat the data as text regardless. It should also be noted that some characters are treated as numbers such as the decimal place, comma and dollar sign.
You will find that as you enter text, the cells are not long enough to fit the data in. If there is no data in the cell next to it, then the text will flow over to the next cell. However if the cell isn’t empty it will show you as much text as possible and then store the rest of the data.
There will be occasions when you want to have numbers treated as text such as phone numbers, mobile numbers, postcodes or part numbers. If you were to type in a Mobile Number such as 0417772544 into an Excel cell, Excel would drop the zero at the start of the number to treat the number as text. To over come this, you place a single quote at the start of the number. You will notice in the cell itself you don’t see the single quote but in the formula bar’s entry area you will see the single quote.
Are You Staying Cool At Work?Jul 13, 2011 - 8:15:40 AM |
Business Productivity Apps That Will Save the DayJun 15, 2011 - 7:02:15 PM There are no limits to productivity. Every small business owner will tell you that productivity is the one thing they are constantly trying to improve – because it has no bounds and reaps huge benefits. Especially with the use of technology, efficiency can grow in leaps and bounds. With computers getting smaller and phones being more than phones, the office is now truly mobile. Let's take a look at some mobile apps that will help you continue to push the boundaries of productivity in your business.... [Read the full story] |
Importance and Benefits of B2B MarketplaceMay 7, 2011 - 7:07:24 AM In today’s world, the competition in each and every field is increasing day by day. So, it is becoming a big problem for every business person to survive in this tough market. But still here is term for every businessman known as B2B that is giving an opportunity to all of them to expand their business all over the world as soon as possible.... [Read the full story] |
Business orphans in the digital era?May 4, 2011 - 3:33:05 AM Web and digital media form the roots of the globalization age. They facilitate real-time contact and information sharing, access and transmission among multiple users trespassing time and geographic boundaries. Does this really mean that communication has become easier, quicker and more effective? Which roles do language and translation play in this virtual and globalize world?... [Read the full story] |
Search for articles: |
Latest Articles in All Categories |
Putting Up a Small Commercial Printing Business |
So You Might Be Unemployed And Desire To Become A San Francisco Real Estate Investor Now |
Meditation and Mindfulness: Dealing With Emotion |
CPA Websites: Five Essential Ideas for Composing Convincing Articles |
Set Goals In Order to Come Up With Your Action Plan |
Is the Air in Your Home Safe to Breathe? |
Coarse Fishing Tackle Review: The JW Young 13ft Trotter Rod |
Section 1031 Exchanges For San Diego Real Estate Investors |
Phoenix Real Estate Investing For Highest Possible Earnings |
Legendary are the Volk Racing TE37 Wheels |
Developing the Next Generation Wall Station (ChaseDesk™) for Healthcare - A Case Study |
What are step down transformers? |
Introducing Sharehype, the Revolutionary Tool for Online Marketers |
Rewards To Shopping For Austin Real Estate On The Web |
Hydroponics for Beginners |
Would you like submit your articles and have them approved on a priority status? Find out more about how you can become a Priority author for pennies a day! Click here.
Dime-co.com Home |
|
|
|
|
|
|
|
|
|
|
|
|
|
Disclaimer: Dime-Co.Com is an online information article and video article network. All articles, video articles, comments, and other features herein are for informational purposes only and are provided "as is" without warranties, representations or guarantees of any kind. The views and opinions expressed in an article, comments, links or blogs are the author's own, and not necessarily those of dime-co.com's owners. For full disclaimer, please read our TOS.