Question

Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has started compiling information on students who are interested in helping run student organizations at Valerian State, and she needs your help completing the workbook. Switch to the Student Representatives worksheet. In cell E2, enter a formula using the HLOOKUP function as follows to determine a student's potential base hourly rate (which is based on the number of years of post-secondary education.

Answer 1

To determine a student's base hourly rate with HLOOKUP in Excel, set up the HLOOKUP formula with the correct table range, reference the number of years of education, and output the corresponding hourly rate.

Step-by-step explanation:

To determine a student's potential base hourly rate using the HLOOKUP function in Excel, follow these steps:

1. Identify the table range where the hourly rates are located, along with the row that indicates the number of years of post-secondary education.
2. In cell E2, enter the HLOOKUP formula. For example, if the years of education are listed in the first row of your table (say A1:E1) and the corresponding hourly rates are in the second row (A2:E2), and the student's years of education are in cell B2, the formula would look like: =HLOOKUP(B2, A1:E2, 2, FALSE).
3. Press Enter to complete the formula. The cell will now display the potential base hourly rate for the student based on their years of education.

Remember to replace A1:E2 with the actual range of your data and B2 with the cell that contains the student's number of years of post-secondary education.