(Solved): 3. Create range names of your choosing for each of the following ranges: - A4 ...

???????

3. Create range names of your choosing for each of the following ranges: - A4:E6, which will be used in a lookup formula - E8:E30 in the Operator ID column - 18:I30 in the Time Spent column - J8.J30 in the Status column 4. In cells I5 and I6, create COUNTIF formulas to count the number of active calls (I5) and the number of closed calls (I6). Use range names in the formulas. 5. Create COUNTIF formulas in cells \( \mathrm{K} 3 \) through \( \mathrm{K} 6 \) to count the calls assigned to operator IDs 1, 2, 3, and 4, respectively. Use range names in the formulas. 6. Create SUMIF formulas in cells \( \mathrm{L} 3 \) through \( \mathrm{L} 6 \) to calculate the total time spent on calls assigned to operator IDs 1, 2, 3, and 4, respectively. Use range names in the formulas. Format the results to display two digits after the decimal point. 7. Create AVERAGEIF formulas in cells \( M 3 \) through \( M 6 \) to find the average time spent on calls assigned to operator IDs 1, 2, 3, and 4, respectively. Use range names in the formulas. Format the results to display two digits after the decimal point. 8. Create the HLOOKUP formula with an exact match in cell G8 to return the last name of the operator assigned to the call. Use the range name for the lookup table in the formula. 9. Create the HLOOKUP formula with an exact match in cell H8 to return the first name of the operator assigned to the call. Use the range name for the lookup table in the formula. 10. Copy the HLOOKUP formulas in the range G8:H8 and paste them into the remaining rows in the list.