- Click the Sales tab.
- In cell A1, type:Frog SalesMake this text Arial, 12 point, bold:
- In cell A3, type:January
- In cell B3, type:February
- In cell C3, type:March
- Highlight cells A3 through C3.
- Place the cursor on the Fill Handle.It should turn into a black cross:
- Drag the cursor to cell L3.
-
The months should fill in consecutively:
- In cell A4, type:10
- In cell B4, type:20
- Highlight cells A4 and B4, then place the cursor on the Fill Handle.
- Drag it to cell L4.The numbers should fill in, in increments of 10:
- In cell N3, type:Total
- Click cell N4, then click the icon.
- Drag over all the cells with numbers in them.They should be surrounded by "marching ants":
- Press ENTER.The yearly total of 780 frogs sold should appear:
- Save the workbook.
-
Sorry,Could not adjust the width properly,just kept this for concept purpose :)
ReplyDelete