Question

In the Time Card sheet, Cell D30, change the formula to get the SUM of cells D21:D27 and multiply the result by cell D29.

Answer 1

To adjust the formula in Cell D30, enter '=SUM(D21:D27)*D29' to sum the range D21:D27 and multiply by D29, providing the total calculated value.

Step-by-step explanation:

To change the formula in Cell D30 on a Time Card sheet to calculate the total of cells D21 through D27 and then multiply by the value in Cell D29, you would use the following steps:

• Click on Cell D30.
• Type in the formula =SUM(D21:D27)*D29 and press Enter.
• The formula first calculates the sum of D21 to D27 using the SUM function, and then multiplies the result by the value in Cell D29.

This will give you the required total that combines all hours worked (summarized in cells D21 to D27) with the rate or multiplier in Cell D29.