Basic Excel Module 3

Which function is used to find a value in a table?

• SUM
• VLOOKUP
• AVERAGE
• COUNT

The formula =SUM(10,20) will return 30.

• True
• False

What is the result of =IF(10 > 5, "Yes", "No")?

• Yes
• No
• Error
• 10 > 5

What does the COUNTIF function do?

• Counts all numbers in a range
• Counts cells that meet a specific condition
• Sums cells that meet a specific condition
• Calculates the average of a range

Which of the following is a logical function in Excel?

• SUM
• AVERAGE
• IF
• MAX

The VLOOKUP function can only search for values in the leftmost column of a table.

• True
• False

What will the formula =IF(A1>5, 'Yes', 'No') return if A1 is equal to 3?

• Yes
• No
• Error
• 3