- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
enter values
The whole purpose of the worksheet is to compare budgeted to actual amounts. It's time to enter those amounts. Since we need to enter values in two columns, we'll use an entry selection area.
)
Position the mouse pointer over cell B3.
)
)
Press the mouse button down and drag down and to the right to cell C26. All cells between B3 and C26 are enclosed in a selection box, but cell B3 remains the active cell.
)
)
Type 8200. It appears in cell B3.
)
)
Press Enter (Windows) or Return (Mac OS). Cell B4 becomes the active cell.
)
)
Repeat steps 3 and 4 for the remaining values in column B shown here. When a cell that should remain blank becomes active, just press Enter or Return again to make the next cell active. After entering the last value in the column, when you press Enter or Return, cell C3 becomes active.
)
)
Repeat steps 3 and 4 for the values in column C shown here. When a cell that should remain blank becomes active, just press Enter or Return again to make the next cell active. After entering the last value in the column, when you press Return or Enter, cell B3 becomes active again.
)
){kind=link}
)
Click anywhere in the worksheet window to deselect the selected cells.