RECALCULATING A TABLE
- 13 Mar 2023
- 1 Minute To Read
- Contributors
- Print
- Dark modeLight
- PDF
RECALCULATING A TABLE
- Updated On 13 Mar 2023
- 1 Minute To Read
- Contributors
- Print
- Dark modeLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
- Open the file: Recalculating a Table
- The figures in the Expenses column have changed. Change the table so that the figures in the Expenses column are the same as the table below.
Centennial Construction | |||
Year | Income | Expenses | Net Profit |
2000 | $6,445,145.30 | $4,456,633.43 | |
2001 | 5,545,428.68 | 4,522,457.43 | |
2002 | 5,674,387.12 | 4,635,355.36 | |
2003 | 6,122,144.54 | 4,844.367.45 | |
- Click once in cell D3 (the cell right below Net Profit). Press the F9 key (this key is in the top row of the keyboard). This will recalculate the cells.
- Click once in cell D4. Press F9.
- Click once in cell D5. Press F9.
- Click once in cell D6. Press F9.
- The figures in the Net Profit column have be recalculated as shown in the table below.
Coleman Corporation | |||
Year | Income | Expenses | Net Profit |
1997 | $6,445,145.30 | $4,456,633.43 | $1,988,511.87 |
1998 | 5,545,428.68 | 4,522,457.43 | 1,022,971.25 |
1999 | 5,674,387.12 | 4,635,355.36 | 1,039,031.76 |
2000 | 6,122,144.54 | 4,844,367.45 | 1,277,777.09 |
Print the table.
Was this article helpful?
