ADDING A FORMULA TO A TABLE
- 13 Mar 2023
- 1 Okunan Dakika
- katkıda
- Yazdır
- karanlıkışık
- Pdf
ADDING A FORMULA TO A TABLE
- Tarihinde güncellendi 13 Mar 2023
- 1 Okunan Dakika
- katkıda
- Yazdır
- karanlıkışık
- Pdf
The content is currently unavailable in Türkçe. You are viewing the default English version.
Makale özeti
Bu özeti faydalı buldunuz mu?
Geri bildiriminiz için teşekkür ederiz
- Start a new document. Click on Table in the menu bar
- Click on Insert – then click on Table.
- Number of Columns - 6.
- Number of Rows - 7. Click OK.
- Click on the vertical line between the 5th and 6th row and move it to the left to shorten up the last column.
- Click on the vertical line between the 4th and 5th row and move it to the left to shorten up the 5th column.
- Shorten the other column columns in the same way. The widest column should be the 1st column.
- Type the chart in the table.
Name | #1 | #2 | #3 | #4 | Total |
Robert Rolf | 74 | 77 | 84 | 83 | |
Jane McKigney | 88 | 93 | 86 | 90 | |
Jesse Keeward | 96 | 95 | 93 | 98 | |
Dawn Palmer | 63 | 78 | 71 | 66 | |
Alicia Gomez | 83 | 83 | 92 | 87 | |
Cherie Lang | 93 | 94 | 84 | 90 |
Calculate the Totals in Each Row
- Click in the first blank cell under Total.
- Click on Table in the menu bar, then click on
Formula. Delete the formula but leave the equals sign. - Click on the down arrow in Paste Function. Select Sum.
Type LEFT between the parentheses.
(It may be there already).
Click OK.- If the formula is showing,
right-click here and choose
Toggle Field Codes.
- Repeat above steps for each row – calculate the total each Row.
Print the Table
Bu makale size yardımcı oldu mu?