After reading the 3 Excel tutorial articles and hearing the class lecture, answer the following questions: 1. You need to reference cell Q57 in a formula. Give the relative reference for this cell, the absolute reference for this cell, and the two mixed references for this cell. 2. Explain the difference in behavior between using a relative reference, absolute reference, and mixed references in a formula 3. If cell R10 contains the formula =R1+R2, which is then copied to cell S20, what formula is entered in cell S202 4. If cell W5 contains the formula $T$14+$T$15, which is then copied into cell Y10, what formula is entered in cell Y107 5. If cell V10 contains the formula AVERAGE(SUTSUS), which is then copied to cell W20, what formula is entered in cell W202 6. Describe the purpose of the IF function in Excel. 7. What is the syntax of the IF formula? 8. If cell Q3 is greater than cell 04, you want to display the text "OK"; otherwise you want to display the text "RETRY". Write the formula that accomplishes this. 9. Search for a built-in formula that finds the date of the workday a given number of days from a certain date. (Example, what is the date 30 workdays after November 1"?) Hint: it should NOT include custom weekend parameters. What is the syntax of this formula? 10. Write a formula to find the date four workdays after the date value stored in cell B10. There are no holidays. 9. Search for a built-in formula that finds the date of the workday a given number of days Trond tenant . (LUMIO what is the date 30 workdays after November 1"?) Hint: it should NOT include custom weekend parameters. What is the syntax of this formula? 10. Write a formula to find the date four workdays after the date value stored in cell B10. There are no holidays. 11. Describe the purpose of the VLOOKUP function in Excel. 12. What is the syntax of the VLOOKUP formula? 13. What are the possible values that can be used for the Range Lookup? When would you use each? 14. What conditions must be met in VLOOKUP in order to set the Range Lookup to TRUE? 15. Provide the formula to do an exact match lookup with the lookup value from cell G5 using a lookup table located in the range A1:F50. Return the value from the third column of the table. You expect to find an bxact match to the value in G5 16. Provide the formula to do a lookup with the lookup value from cell D7 using a lookup table located in the range B15:30. Return the value from the fifth column of the table. You want to find the closest match to the value in D7, not necessarily an exact match. After reading the 3 Excel tutorial articles and hearing the class lecture, answer the following questions: 1. You need to reference cell Q57 in a formula. Give the relative reference for this cell, the absolute reference for this cell, and the two mixed references for this cell. 2. Explain the difference in behavior between using a relative reference, absolute reference, and mixed references in a formula 3. If cell R10 contains the formula =R1+R2, which is then copied to cell S20, what formula is entered in cell S202 4. If cell W5 contains the formula $T$14+$T$15, which is then copied into cell Y10, what formula is entered in cell Y107 5. If cell V10 contains the formula AVERAGE(SUTSUS), which is then copied to cell W20, what formula is entered in cell W202 6. Describe the purpose of the IF function in Excel. 7. What is the syntax of the IF formula? 8. If cell Q3 is greater than cell 04, you want to display the text "OK"; otherwise you want to display the text "RETRY". Write the formula that accomplishes this. 9. Search for a built-in formula that finds the date of the workday a given number of days from a certain date. (Example, what is the date 30 workdays after November 1"?) Hint: it should NOT include custom weekend parameters. What is the syntax of this formula? 10. Write a formula to find the date four workdays after the date value stored in cell B10. There are no holidays. 9. Search for a built-in formula that finds the date of the workday a given number of days Trond tenant . (LUMIO what is the date 30 workdays after November 1"?) Hint: it should NOT include custom weekend parameters. What is the syntax of this formula? 10. Write a formula to find the date four workdays after the date value stored in cell B10. There are no holidays. 11. Describe the purpose of the VLOOKUP function in Excel. 12. What is the syntax of the VLOOKUP formula? 13. What are the possible values that can be used for the Range Lookup? When would you use each? 14. What conditions must be met in VLOOKUP in order to set the Range Lookup to TRUE? 15. Provide the formula to do an exact match lookup with the lookup value from cell G5 using a lookup table located in the range A1:F50. Return the value from the third column of the table. You expect to find an bxact match to the value in G5 16. Provide the formula to do a lookup with the lookup value from cell D7 using a lookup table located in the range B15:30. Return the value from the fifth column of the table. You want to find the closest match to the value in D7, not necessarily an exact match