Question

For the Introduction to Computers 1 Capstone Assignment, insert a formula in cell H3 that determines the bonus amount.

Select one or more:
a) AVERAGE(H1:H2)
b) IF(H1 > H2, H10.1, H20.05)
c) SUM(H1:H2)
d) MAX(H1, H2)

Answer 1

The correct formula to insert in cell H3 to determine the bonus amount for the Introduction to Computers 1 Capstone Assignment is IF(H1 > H2, H10.1, H20.05), as it computes a conditional bonus based on percentages of the compared values H1 and H2.

Step-by-step explanation:

To determine the bonus amount for the Introduction to Computers 1 Capstone Assignment, it's important to understand how a bonus is typically calculated. If the bonus is based on comparing two values, such as sales targets (H1) and actual sales (H2), and providing a percentage of one of those values as a bonus, then an IF formula would be appropriate. Specifically, the formula in cell H3 should be IF(H1 > H2, H10.1, H20.05). This formula checks if H1 is greater than H2, and if so, gives 10% of H1 as a bonus; if not, it gives 5% of H2 as a bonus. The other options, such as AVERAGE(H1:H2), SUM(H1:H2), or MAX(H1, H2) do not satisfy the requirement of calculating a bonus amount based on a condition. Average would compute the mean of two numbers, Sum would add them together, and Max would simply select the highest value, none of these operations directly result in a calculated bonus amount.