The data in the spreadsheet can be modified to reflect changes in the reception plans. Fortunately, in Numbers you can quickly add and remove data using intuitive controls that let you adapt your spreadsheet to your needs. In this exercise, you’ll make several changes to your spreadsheet that illustrate how to control tables.
1. | For the Guest List table, click in cell E2 and type 4.
This signifies that the first guest will have four people total in his party.
|
2. | Enter data for the remaining guests according to the following figure:
The Guest List currently totals 23 guests. |
3. | Click the Budget table to switch to it.
Numbers allows you to use multiple tables in a sheet for added flexibility. You can modify this table to adjust for event costs |
4. | Place your pointer over row 3, Band, until the menu arrow appears. From the cell reference pop-up menu, choose Delete Row.
|
5. | Using the same method, delete row 4, “Ceremony location.”
Note
The costs in the Budget table can be easily modified, but because you have already practiced modifying cell content, you’ll use these numbers as is.
|
6. | Remove the yellow comment by clicking the X in the upper right corner.
Note
You can add your own comments to a table by selecting a cell and then clicking the Comment button in the toolbar. If a cell is not selected when you click the Comment button, a floating comment using the sticky note format will be added to your document.
|
7. | Click the Task List table to switch to it.
|
8. | Remove the task “Book ceremony location” using the cell reference pop-up menu as you did earlier in this exercise.
Let’s enlarge the table to include more tasks.
|
9. | In the lower right corner of the table, drag the Column and Row handle to resize the table to 11 rows and 4 columns.
 |
10. | Add information to the table as shown in the following figure:
 |
11. | Click column D (Notes); then, from the pop-up menu, choose Delete Column.
|
12. | Choose File > Save to save your work.
|
