2018-02-20
594
Microsoft Excel 2007 is an electronic spreadsheet software package that allows you to organize data in a tabular format, perform mathematical calculations, and analyze data. This software includes functions, formulas, and charts. It is commonly used in business, engineering, mathematics, and statistics.
In the upper-left corner of the Excel 2007 window is the Microsoft Office button. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks.
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576. The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources.
Creating a New Workbook
It is easy to create a new workbook! Simply, click on Office Button – New and click on Blank Workbook to create a new workbook.
Creating a New Worksheet
Creating a new worksheet is just as easy. By default, each Excel workbook contains three worksheets. Three tabs displaying Sheet 1, Sheet 2, and Sheet 3 will be displayed at the bottom of the workbook to indicate the separate sheets. To add a new worksheet, simply click on the tab after the tab that says Sheet 3.
The combination of a column coordinate and a row coordinate make up a cell address. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet.. The cell address is visible in the Name Box. Place your cursor in the first cell, A1. The formula bar will display the cell address in the Name Box on the left side of the Formula bar. Notice that the address changes as you move around the sheet. You can easily move from cell to cell by pressing tab or using the arrow keys.
|
|
|
Entering Excel Formulas and Formatting Data
When you enter formulas into your Excel worksheet, the formulas can calculate automatically.
In Microsoft Excel, you can enter numbers and mathematical formulas into cells. Whether you enter a number or a formula, you can reference the cell when you perform mathematical calculations such as addition, subtraction, multiplication, or division. When entering a mathematical formula, precede the formula with an equal sign. Use the following to indicate the type of calculation you wish to perform:
· +: Addition
· -: Subtraction
· *: Multiplication
· /: Division
In the following exercises, you practice some of the methods you can use to move around a worksheet and you learn how to perform mathematical calculations.
AutoSum
You can use the AutoSum button 
on the Home tab to automatically add a column or row of numbers. When you press the AutoSum button , Excel selects the numbers it thinks you want to add. If you then click the check mark on the Formula bar or press the Enter key, Excel adds the numbers. If Excel's guess as to which numbers you want to add is wrong, you can select the cells you want.
