- Name the Sheet
- Understand References
- Enter Information
- Activate a Cell
- Enter Row Headings
- Enter Column Headings
- Make a Column Wider
- Enter Values
- Calculate a Difference
- Calculate a Percent Diff
- Sum Some Values
- Calculate Net Income
- Copy Formulas
- Copy and Paste
- Use the Fill Handle
- Change a Value
- Extra Bits
Name the Sheet p. 24
- As you’ll see in Chapter 8, you can instruct Excel to automatically display a sheet name in a printed report’s header or footer. That’s a good reason to give a sheet an appropriate name.
Activate a Cell p. 27
- When you use the point-andclick method for activating a cell, you must click. If you don’t click, the cell pointer won’t move and the cell you’re pointing to won’t be activated.
Enter Row Headings p. 28
When you enter text in a cell, Excel’s AutoComplete feature may suggest entries based on previous entries in the column.
To accept an entry, press Enter when it appears. Otherwise, just keep typing what you want to enter. The AutoComplete suggestion will eventually go away.
Make a Column Wider p. 30
- You can’t change the width of a single cell. You must change the width of the entire column the cell is in.
Enter Values pp. 31–32
- You can enter any values you like in this step. But if you enter the same values I do, you can later compare the results of your formulas to mine to make sure the formulas you enter in the next step are correct.
- Do not include currency symbols or commas when entering values. Doing so will apply number formatting. I explain how to format cell contents, including values, in Chapter 6.
- If you use the arrow keys to move from one cell to the next, the selection area disappears. Although you can enter values without a selection area, using a selection area makes it easier to move from one cell to another.
- If, after entering values, you discover that one of the values is incorrect, activate the cell with the incorrect value, enter the correct value, and press Enter to save it.
Calculate a Difference p. 33
- In Excel, all formulas begin with an equal sign (=).
- Although you can write a formula that subtracts one number from another, using cell references in the formula ensures that the formula’s results remain correct, even if referenced cells’ values change.
- As our formula is written, if the actual amount is lower than the budgeted amount, the difference appears as a negative number. You can make this appear as a positive number by switching the order of the cell references so the formula is =B3-C3.
Calculate a Percent Diff p. 34
- The number of decimal places that appear in the results of the formula depends on the width of the column the formula is in.
- Don’t worry that the percentages Excel calculates don’t look like percentages. Later, in Chapter 6, we’ll format the worksheet so the numbers look like percentages.
- If the budgeted amount in a cell is 0, the formula for the percent difference will display the error message #DIV/0! Enter
this formula in cell E3 to prevent that error: =IF(ISERR(D3/B3),0,D3/B3)
This rather complex formula uses logic to determine whether the formula results in an error and, if it does, results in 0.
Sum Some Values pp. 35–36
- The SUM function is probably Excel’s most used function. It can be used to add up any range of values.
- Excel is not case-sensitive when evaluating functions. You can type SUM, sum, Sum, or even sUm when you write the formula and Excel will understand.
Copy and Paste p. 39
- The appearance of the Copy button varies depending on your monitor’s screen resolution and the size of the Excel application window. On lower resolution settings or for smaller windows, the button may look like this when you click it:
- The Paste Options button appears when you use the Paste command. Clicking this button displays a menu of options you can use immediately after pasting one or more cells.
Use the Fill Handle pp. 40–42
- The Auto Fill Options button appears when you use the fill handle to copy formulas. Clicking this button displays a menu of options you can use immediately after filling cells.
Change a Value p. 43
- You can use this technique to change any label, value, or formula in a worksheet cell.
- To delete the contents of a cell, activate the cell, press Backspace, and press Enter. Don’t use the Spacebar to delete a cell’s contents; this merely replaces its contents with a space character.
Shortcut Keys for this Chapter