Change the number format.

Jane wants to calculate the percentage each type of gift contributed to the total amount of gifts. To

avoid a divide by zero error in the calculation, she wants to make the calculation using the IFERROR

function, which she has already entered. Complete the formula as follows:

a$.$ In cell C$5,$ before the comma in the IFERROR function, create a formula without using a function

that divides the amount of cash gifts $($cell $B5)$ by the total amount of gifts $($cell B$11).$

b$.$ Use an absolute reference to cell B$11$ in the formula.

c$.$ Use the Fill Handle to fill the ranae C$6$:C$10$ with the formula in cell C$5.$

Create a formula using a function.

In the Quarter $3$ Gifts worksheet, the formula in cell C$5$ should contain the IFERROR function.

X Copy a formula into a range.

In the Quarter $3$ Gifts worksheet, cell C$5$ contains an incorrect formula.