Excel adds cell A1 to cell A2 and displays the result in cell A4.
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. Use the following to indicate the type of calculation you wish When entering a mathematical formula, precede the formula with an equal Whether you enter a number or a formula, you can reference the cell when you perform mathematicalĬalculations such as addition, subtraction, multiplication, or division. In Microsoft Excel, you can enter numbers and mathematical formulas
You can use the Direction box in the Excel Options pane to set the cursor to move up, down, In the exercises that follow, the cursor must move down one cell when you press Enter.
In Microsoft Excel, you can specify the direction the cursor moves In this lesson, you learn how to performīasic mathematical calculations and how to format text and numerical data. A major strength of Excel is that you can perform mathematical calculations and format your data. Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. Lesson 2: Entering Excel Formulas and Formatting Data