please solve the highlight task

table in the formulas. Copy the formulas down to the rema Greete LOOKUP formula in cells G9 to return the first name for the operator assigned to the cll Use the range mame and cell reference the lookup table in the formulas. Copy the formulas down to the rema Pows in the list. In cell 19 create a logical formula to display the word "Overtime the Status of the all is Active and the Type of Call is Software. Otherwise, insert a question mark (?). Use range names in the formula Copy the formula down to the remaining rows in the list. Part 2 Total Marks Instructions Version B