MARISSA JONES ONLY!!!!
jermaineb1979
EnterLabelsandValuesandUsetheAutoSumButton4.docxEnter Labels and Values and Use the AutoSum Button
Learning Outcomes
· Build formulas with the AutoSum button
· Copy formulas with the fill handle
To enter content in a cell, you can type in the formula bar or directly in the cell itself. When entering content in a worksheet, you should start by entering all the labels first. Labels are entries that contain text and numerical information not used in calculations, such as “2019 Sales” or “Travel Expenses”. Labels help you identify data in worksheet rows and columns, making your worksheet easier to understand. Values are numbers, formulas, and functions that can be used in calculations. To enter a calculation, you type an equal sign (=) plus the formula for the calculation; some examples of an Excel calculation are “=2+2” and “=C5+C6”. Functions are built-in formulas; you learn more about them in the next module. You want to enter some information in the Project Leader Payroll Calculator workbook and use a very simple function to total a range of cells.
Steps
1. 1
Click cell A15, then click in the formula bar
Notice that the mode indicator on the status bar now reads “Edit,” indicating you are in Edit mode. You are in Edit mode any time you are entering or changing the contents of a cell.
Quick Tip
If you change your mind and want to cancel an entry in the formula bar, click the Cancel button on the formula bar.
2. 2
Type Totals, then click the Enter button on the formula bar
Clicking the Enter button accepts the entry. The new text is left-aligned in the cell. Labels are left-aligned by default, and values are right-aligned by default. Excel recognizes an entry as a value if it is a number or it begins with one of these symbols: +, −, =, @, #, or $. When a cell contains both text and numbers, Excel recognizes it as a label.
3. 3
Click cell B15
You want this cell to total the hours worked by all the trip advisors. You might think you need to create a formula that looks like this: =B5+B6+B7+B8+B9+B10+B11+B12+B13+B14. However, there’s an easier way to achieve this result.
Quick Tip
The AutoSum button is also referred to as the Sum button because clicking it inserts the SUM function.
4. 4
Click the AutoSum button in the Editing group on the Home tab on the Ribbon
The SUM function is inserted in the cell, and a suggested range appears in parentheses, as shown in Figure 1-7 . A function is a built-in formula; it includes the arguments (the information necessary to calculate an answer) as well as cell references and other unique information. Clicking the AutoSum button sums the adjacent range (that is, the cells next to the active cell) above or to the left, although you can adjust the range if necessary by selecting a different range before accepting the cell entry. Using the SUM function is quicker than entering a formula, and using the range B5:B14 is more efficient than entering individual cell references.
Figure 1-7Creating a Formula Using the AutoSum Button
Quick Tip
You can create formulas in a cell even before you enter the values to be calculated.
5. 5
Click on the formula bar
Excel calculates the total contained in cells B5:B14 and displays the result, 378, in cell B15. The cell actually contains the formula =SUM(B5:B14), and the result is displayed.
6. 6
Click cell C13, type 6, then press [Enter]
The number 6 replaces the cell’s contents, the cell pointer moves to cell C14, and the value in cell F13 changes.
Quick Tip
You can also press [Tab] to complete a cell entry and move the cell pointer to the right.
7. 7
Click cell C18, type Average Gross Pay, then press [Enter]
The new label is entered in cell C18. The contents appear to spill into the empty cells to the right.
8. 8
Click cell B15, position the pointer on the lower-right corner of the cell (the fill handle) so that the pointer changes to , drag to cell G15, then release the mouse button
Dragging the fill handle across a range of cells copies the contents of the first cell into the other cells in the range. In the range B15:G15, each filled cell now contains a function that sums the range of cells above, as shown in Figure 1-8 .
Figure 1-8Results of Copied SUM Functions
9. 9
Navigating a Worksheet
With over a million cells available in a worksheet, it is important to know how to move around in, or navigate, a worksheet. You can use the arrow keys on the keyboard , , , or to move one cell at a time, or press [Page Up] or [Page Down] to move one screen at a time. To move one screen to the left, press [Alt][Page Up]; to move one screen to the right, press [Alt][Page Down]. You can also use the mouse pointer to click the desired cell. If the desired cell is not visible in the worksheet window, use the scroll bars or use the Go To command by clicking the Find & Select button in the Editing group on the Home tab on the Ribbon. To quickly jump to the first cell in a worksheet, press [Ctrl][Home]; to jump to the last cell, press [Ctrl][End].
