Spreadsheets Review 1-3

Match the following Boolean operator to each comparison

• <

• Equal To

• >

• Greater Than

• =

• Not Equal To

• >=

• Less Than

• <>

• Greater Than or Equal To

Which function is used to count the number of cells in a selected range that contain text or numbers?

• =COUNTIF

• =COUNTA

• =COUNT

• =IF

Which function is used to count the number of cells in a selected range that meet a specific criterion?

• =COUNTIF

• =COUNTA

• =COUNT

• =IF

There are three elements that must be included inside the brackets of an IF function. The first is the...

• Logical Test
• Value if True

• Value if False

There are three elements that must be included inside the brackets of an IF function. The second is the...

• Logical Test
• Value if True

• Value if False

There are three elements that must be included inside the brackets of an IF function. The last is the...

• Logical Test
• Value if True

• Value if False

Which function is used to find the average of the values in a range of cells?

• =MAX

• =MIN

• =AVERAGE

• =SUM

Which function is used to find the largest of the values in a range of cells?

• =MAX

• =MIN

• =AVERAGE

• =SUM

Which function is used to find the smallest of the values in a range of cells?

• =MAX

• =MIN

• =AVERAGE

• =SUM

Which function is used to find the total value of a range of cells?

• =MAX

• =MIN

• =AVERAGE

• =SUM