Long Quiz: Spreadsheet

What function is used to count cells that meet a condition?

• SUM

• AVERAGE

• COUNTIF

• VLOOKUP

Which function is used to add numbers in a range based on a condition?

• SUMIF

• COUNTIF

• IF

• AVERAGE

What symbol must always be typed before a formula in Excel?

• *

• =

• /

• -

What is the maximum number of rows in an Excel worksheet?

• 1,048,576

• 256

• 65,536

• 1,024

Which function is used to return the highest value in a range?

• MIN

• AVERAGE

• MAX

• SUM

Which function retrieves data from a specific column based on a lookup value?

• HLOOKUP

• VLOOKUP

• COUNT

• AVERAGEIF

In Excel, what does the function =IF(B2="Yes", "Passed", "Failed") do?

• Adds numbers

• Displays a logical value

• Returns “Passed” if B2 is “Yes”, otherwise “Failed”

• None of the above

Which tab contains the Conditional Formatting button in Excel?

• File

• Data

• Home

• Insert

What is the purpose of the AVERAGE function in Excel?

• To count the number of cells in a range

• To sum numbers

• To find the average of a range of numbers

• To find the maximum value

What function can be used to restrict data entry in Excel?

• COUNTIF

• VLOOKUP

• DATA VALIDATION

• IF