Mastering Excel Formulas and Functions

Which of the following is a basic Excel function used to calculate the average of a range of cells?

• SUM

• AVERAGE

• COUNT

• MAX

What is the purpose of conditional formatting in Excel?

• To change the font of the text

• To apply different formats to cells based on specific conditions

• To sort data in ascending order

• To create a chart

In an IF statement, what does the syntax `=IF(A1>10, "High", "Low")` do?

• It checks if A1 is less than 10 and returns "High" if true, otherwise "Low"

• It checks if A1 is greater than 10 and returns "High" if true, otherwise "Low"

• It checks if A1 is equal to 10 and returns "High" if true, otherwise "Low"

• It checks if A1 is not equal to 10 and returns "High" if true, otherwise "Low"

What is the result of the formula `=SUM(2, 3, 5)` in Excel?

• 10

• 8

• 15

• 5

Explain how absolute referencing works in excel

What does the formula `=IF(B2="Yes", "Approved", "Denied")` do?

• It checks if B2 is "No" and returns "Approved" if true, otherwise "Denied"

• It checks if B2 is "Yes" and returns "Approved" if true, otherwise "Denied"

• It checks if B2 is "Yes" and returns "Denied" if true, otherwise "Approved"

• It checks if B2 is "No" and returns "Denied" if true, otherwise "Approved"

Which of the following is an example of a relative reference in Excel?

• A$1

• $A1

• A1

Write a Vlookup formula that looks for the value in A1 from a list in C2 to D10 and returns the value from the D column. This list is unsorted and the formula should be draggable in column A without breaking. E.g. change A1 to A2 etc.