ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Performing Calculations in Microsoft Office Excel 2003

Updated on August 14, 2018
Patkay profile image

Patrick, a Computer Technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

Performing Calculations in Microsoft Office Excel 2003

How to Perform Calculations in Excel

Microsoft Office Excel is a spreadsheet program. It is used by many people for computation purposes. Microsoft Office Excel 2003 comprises many functions that can be used to solve hundreds of mathematical problems.

The best thing about Microsoft Office Excel is that it is not you doing the computations, it is the computer. Your work is only to supply the correct function (formula) and bingo! You get your results instantly. There is a tool called auto fill that you will fall in love with as it will make your work so easy. Performing calculations in Excel is so easy as you will come to realize.

Creating an Excel Workbook

A workbook is a file that you are going to create in Excel. This file will carry your data. To do this go to:-

  • Start
  • All Programs
  • Microsoft Office
  • Microsoft Office Excel

When the Excel window opens, at the top (title bar) you will see the name Book 1 or something like that. You are supposed to save your workbook immediately so as to give it a name before you start entering your data. Go to:-

  • File
  • Save as
  • Type the file name of your workbook and select the location where you want to save it.
  • Then click on save.

Labelled Excel Window

Detailed features of Excel window
Detailed features of Excel window | Source

Entering Data in MS Excel

Before you even learn how to compute using excel, you can decide to go through an introduction to Microsoft Office Excel 2003. The main title or heading of your work should be typed on cell A1 while the subheadings should be typed in row two. Data is entered on the individual cells. By clicking on a cell, you make it active and ready to accept any input. While entering your data, you can use the arrow keys for navigation; they are more efficient rather than using the mouse. Remember to often keep saving your work to avoid loss of data if the power goes off.

This can be done by going to File > Save or simply pressing the Ctrl + S keys on your keyboard.

Formatting Your Excel Document

If you are familiar with word document formatting, then this one will be almost the same. Highlight your heading (simply click on cell A1) and go to Format > Cells > Font. The Font dialog box appears where you are going to select the font, font style, size, underline style, font colour and special effects that you want to apply to your document. Format the rest of your document the same way.

Format Cells Dialog Box

Formatting an Excel document
Formatting an Excel document | Source

Performing Calculations In Excel

Performing calculations in Microsoft Office Excel is easy. Procedure:-

  1. Click on where the answer will appear
  2. Go to Insert > Function. The Insert Function dialog box opens
  3. Select the function (a formula with arguments) you want. If you do not find the function you want, change where it is written or select a category from most recently used to All category. This option lists all the functions used in Excel.
  4. After selecting the function you want to use click okay.
  5. The next dialog box that appears is the one you supply the function arguments. For instance, if you are finding the minimum of some numbers, highlight the cells you are finding the minimum of.
  6. Click okay and the results will be displayed on the cell you had clicked.

Whichever function you want to use, the procedure will be as above.

The Insert Function

How to use the insert function
How to use the insert function | Source

Centering and Merging Your Heading

To center and merge the heading, highlight the cells it will occupy up to the end of your work. Go to Format > Cells and click on the Alignment tab. On the horizontal text alignment select center and on the text control, tick on merge cells button.

Aligning Your Subtitles to a Specific Degree

Highlight the subtitles you want to orient. Go to Format > Cells and click on the Alignment tab. Set the orientation degree and click on okay.

Wrapping Text

You can make your text to occupy several lines within a single cell. Highlight the cells which you want to wrap text their contents. Click on Format > Cells and click on the Alignment tab and then on the text control option, click on wrap text.

Performing Calculations in Excel

Performing calculations in Excel
Performing calculations in Excel | Source

Applying Borders to Your Work

You can set outside borders and inside borders to your work. Procedure:-

  • Highlight the area you want to set borders
  • Go to Format > Cells and click on the Border tab
  • Select the line style you wish to use for your outline border
  • Below the line style, set the colour of your borderline
  • Then click on the outline preset. Observe what happens to your preview window
  • Now for the inside borders, select line style
  • Set the colour you want
  • Click on the inside borders from the presets and check on the preview. Click okay.

Copying and Pasting Your Work to Another Place or Worksheet

Highlight the work to be copied, go to edit and click on copy. Then click on where you want to paste your data and go to edit and click paste. Shortcuts also apply for instance Ctrl + C for copy and Ctrl + V for paste, or you can right click and access the copy and paste options.

Renaming a Worksheet

Go down to the worksheet tab and right click on where it is written sheet1, then select rename. Type the new name of your worksheet.

Are you comfortable making calculations in Excel?

See results

© 2012 Patrick Kamau

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)