Final answer:
To calculate a salary raise in Excel, use the formula =C4 * D4 in cell E4, multiplying the Salary by the Raise Percent. For a $10 hourly wage with a 20% raise, the calculation would be 10 * 0.20, resulting in a $2 increase per hour.
Step-by-step explanation:
The student is tasked with creating a formula in Microsoft Excel.
To calculate the new salary including the raise, you would use the following structured reference formula in cell E4: =C4 * D4. This formula multiplies the Salary in cell C4 by the Raise Percent in cell D4.
Assuming that the Salary is $10 per hour (as in the provided reference information) and the Raise Percent is 20% (or 0.20 as a decimal), the resulting formula would be =10 * 0.20, which equals 2. This means a $2 raise per hour based on the original $10 per hour salary. The percentage change calculation is an important concept here, which is illustrated by the raise example: Percentage change = (Change in quantity) / Quantity, which in the context of a raise, translates to a $2 raise per $10 of original hourly wage.