$1$: What does VLOOKUP do in Excel and how is it used?

$2$: What are the key components of the VLOOKUP function and how do you construct it$?$

$3$: What is the difference between absolute and relative cell references in Excel formulas?

$4$: What is the purpose of the IF function in Excel, and how is it used?

$5$: How can you concatenate $($join$)$ text from multiple cells into one cell in Excel?

$6$: How can you calculate the average of a range of numbers in Excel?

$7$: What does the COUNT function do in Excel, and how is it useful?