1. In PowerPoint, which of the following is the correct way to enter a formula in a table cell?
A) Click on the cell and type “=” followed by the formula
B) Click on the cell, then select “Formulas” from the “Table Tools” tab
C) Click on the cell, go to the “Layout” tab, and choose “Formula”
D) Right-click the cell and select “Insert Formula”
Answer: C) Click on the cell, go to the “Layout” tab, and choose “Formula”
2. Which function would you use in a PowerPoint table formula to calculate the sum of the numbers in a column?
A) =AVERAGE()
B) =COUNT()
C) =SUM()
D) =PRODUCT()
Answer: C) =SUM()
3. To calculate the average of values in a PowerPoint table, which formula would you use?
A) =SUM(A1
)/COUNT(A1
)
B) =AVERAGE()
C) =TOTAL()
D) =MEAN()
Answer: B) =AVERAGE()
4. When using a formula in a PowerPoint table, which of the following is a valid example of referencing cells?
A) A1+B1
B) Table1[Cell1]
C) [A1]+[B1]
D) Table1!A1+B1
Answer: A) A1+B1
5. If you want to display the result of a formula in a specific format, such as currency, how can you do it in PowerPoint?
A) Apply the format directly in the formula
B) Use the “Format Cells” option under “Table Tools”
C) Change the format in the “Design” tab
D) Formatting is not available for formula results in PowerPoint
Answer: B) Use the “Format Cells” option under “Table Tools”
6. How do you update the result of a formula after changing the data in a PowerPoint table?
A) Formulas in PowerPoint automatically update
B) Re-enter the formula
C) Manually recalculate the formula using the “Calculate Now” option
D) Reopen the PowerPoint file
Answer: A) Formulas in PowerPoint automatically update