Use the range Q3:U3092 to determine if the loan applicant has the Job Title entered into Q1 and is from the State listed in each of the cells from the range Q2:U2. Put a 1 (one) in the corresponding cell if the criteria is met and a 0 (zero) if the criteria is not met. (Hint: you have multiple logical tests occurring here.). Write one formula that is then copy/pasted to the entire range.