Performing Calculations in Microsoft Office Excel 2003
Performing Calculations in Microsoft Office Excel 2003
Microsoft Office Excel is a spreadsheet program. It is used by many people for computation purposes. Microsoft Office Excel 2003 comprises of many functions that can be used to solve hundreds of mathematical problems.
The best thing with 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 the file that you are going to create in Excel. To do this go to:-
- 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:-
- 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
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 on 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 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
Performing Calculations In Excel
Performing calculations in Microsoft Office Excel is easy. Procedure:-
- Click on where the answer will appear
- Go to Insert > Function. The Insert Function dialog box opens
- 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.
- After selecting the function you want to use click okay.
- 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.
- 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
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.
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
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 border line
- 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 work sheet.
Are you comfortable making calculations in Excel?See results without voting
© 2012 Patrick Kamau
More by this Author
The Home Tab of Microsoft Excel 2007 with its seven groups has very important commands necessary for formatting your document. The commands are discussed here in details.
The edit menu provides important editing commands for making changes to an Excel document. Mastering the usage of these tools is important so as to enable you work fast on your worksheet.
The motherboard includes components crucial to the functioning of a computer. Among them, the Central Processing Unit and Random Access Memory. Learn more about the parts and their functions.
No comments yet.