Q1. How do you insert a formula into a table cell in MS Word?
a) Go to the “Table Tools Layout” tab and click “Formula”
b) Use the “Insert” tab and select “Equation”
c) Right-click on the cell and choose “Insert Formula”
d) Use the “Design” tab and select “Table Formula”
Answer: a) Go to the “Table Tools Layout” tab and click “Formula”
Q2. What is the default formula used for summing numbers in a table cell in MS Word?
a) =SUM(ABOVE)
b) =ADD(ABOVE)
c) =TOTAL(ABOVE)
d) =SUM(BELOW)
Answer: a) =SUM(ABOVE)
Q3. How can you calculate the average of numbers in a table using a formula in MS Word?
a) Use the formula =AVERAGE(ABOVE)
b) Use the formula =MEAN(ABOVE)
c) Use the formula =AVG(ABOVE)
d) Use the formula =MEDIAN(ABOVE)
Answer: a) Use the formula =AVERAGE(ABOVE)
Q4. Which formula would you use to find the maximum value in a column of a table in MS Word?
a) =MAX(ABOVE)
b) =MAXIMUM(ABOVE)
c) =LARGEST(ABOVE)
d) =BIGGEST(ABOVE)
Answer: a) =MAX(ABOVE)
Q5. To multiply the values of two cells in a table in MS Word, which formula should you use?
a) =A1*B1
b) =PRODUCT(A1,B1)
c) =MULTIPLY(A1,B1)
d) =A1*B1
Answer: a) =A1*B1
Q6. How can you update the results of a formula after changing the data in a table cell in MS Word?
a) Press F9 to update the field
b) Use the “Update Field” option in the “References” tab
c) Click “Refresh” in the “Table Tools Design” tab
d) Re-enter the formula manually
Answer: a) Press F9 to update the field
Q7. What does the formula =SUM(LEFT) do in a table cell?
a) Sums the numbers in the cells to the left of the current cell
b) Sums the numbers in the cells to the right of the current cell
c) Sums all cells in the current row
d) Sums all cells in the current column
Answer: a) Sums the numbers in the cells to the left of the current cell
Q8. How can you insert a formula that calculates the result of a division in a table cell in MS Word?
a) Use the formula =A1/B1
b) Use the formula =DIVIDE(A1,B1)
c) Use the formula =QUOTIENT(A1,B1)
d) Use the formula =A1 / B1
Answer: d) Use the formula =A1 / B1
Q9. Which formula would you use to count the number of cells with numeric data in a table column in MS Word?
a) =COUNT(ABOVE)
b) =NUMERIC(ABOVE)
c) =TOTAL(ABOVE)
d) =COUNTA(ABOVE)
Answer: a) =COUNT(ABOVE)
Q10. To perform a calculation based on cells in a table that are not directly adjacent, which approach should you use?
a) Use multiple formulas in different cells and combine the results
b) Use a single formula with cell references to non-adjacent cells
c) Copy the data into a new table and perform calculations there
d) Use the “Data” tab to calculate values
Answer: b) Use a single formula with cell references to non-adjacent cells