Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Formulas, Functions, and Relative and Absolute Addressing
CHAPTER 3
Formulas, Functions, and Relative
and Absolute Addressing
This chapter explains formulas, functions, and the addressing features or issues in
Excel. I will show simple and advanced ways to create formulas and functions
more efficiently. The focus is on speed, accuracy, and the ability to duplicate and
repeat the functions and the formulas
saving valuable time and effort.
In Figure 3.1, you can see a simple payroll example that you can find in the Excel
workbook for Chapter 3. The sheet is named Simple Payroll Before. To calculate the
salary, Hours worked
(equal) sign first; then click on cell
C3, type *, and click on cell D3. When you press the Enter key, the formula will cal-
culate the result. Note how the cursor will skip down to cell E4. Once you are in cell E4
and you want to duplicate the result for all other employees, you have to select E3
again. This is an extra step. In order to save this additional step you can do one of two
things: after entering the formula, rather than pressing the Enter key, either you click
on the green check sign
Rate in cell E3: Type the
¼
×
(to the left of the formula bar)
O
or use CTRL
þ
Enter. The cursor will remain in the selected cell. See Figure 3.1.
FIGURE 3.1 Use CTRL
þ
Enter to Save a Step
 
Search JabSto ::




Custom Search