Which Excel function is commonly used to retrieve a value from a table based on a lookup value?

• INDEX

• MATCH

• VLOOKUP

• SUM

What does the formula =IF(A1="", "Missing", A1) do?

• Returns A1 if it is empty

• Returns 'Missing' if A1 is empty

• Returns TRUE if A1 is not empty

• Returns FALSE if A1 is empty

Which feature allows you to change the cell color based on its value?

• Data Validation

• Conditional Formatting

• Cell Linking

• Pivot Table

What is the purpose of Data Validation in Excel?

• To format cells

• To restrict data entry

• To calculate values

• To link cells

Which function calculates the average of a range of numbers?

• SUM

• COUNT

• AVERAGE

• MAX

What does the formula =VLOOKUP(85, TransmuteTable, 2, TRUE) return?

• The exact match for 85

• The closest match for 85

• The second column value for 85

• An error if 85 is not found

Which Excel feature allows you to link data from one sheet to another?

• Cell Linking

• Conditional Formatting

• Data Validation

• Sorting

What does the formula =IF(B2>75, "Pass", "Fail") do?

• Returns Pass if B2 is less than 75

• Returns Fail if B2 is greater than 75

• Returns Pass if B2 is greater than 75

• Returns Fail if B2 is empty

Which function returns the number of cells that contain numbers?

• COUNT

• COUNTA

• COUNTIF

• SUM

What is the result of =ROUND(89.456, 1)?

• 89.4

• 89.5

• 89.45

• 90