Spreadsheet - Advanced Functions and Formulae

The first argument in the CountIF function is range

• True

• False

Fill in the blank

=IF(__________, value_if_true, value_if_false)

• lookup_value

• criteria

• range

• logical_test

The countif function uses two (2) arguments

• False

• True

What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"

• Count

• Countif

• If

• Vlookup

Which of the following is NOT possible with VLOOKUP?

• You can lookup values located in a different worksheet.

• You can lookup values located in a column to the right of the column that contains the lookup value.

• You can lookup values located in a column to the left of the column that contains the lookup value.

• None of the above

The first argument in a VLOOKUP function tells the function __________

• what to look for

• where to look

• to use an approximate or exact match

• the column index number

One of these function is not a valid Countif function

• =countif(A2:A5,"h")

• =countif(A2:B5,"h")

• =countif(A2:A5,"<10")

• =countif(A2:A5,">7")

Which one of these functions gives the result shown in the picture?

• =COUNTIF(D5:D13,"<15")

• =COUNTIF(D5:D13,"=16")

• =COUNTIF(D5:D13,">=10")

• =COUNTIF(D5:D13,">=15")

This function returns the number of cells that meet a condition set forth in a formula

• Count 
• CountA
• CountIf
• List

Which function would display "Yes" if D13 is greater than 0?

• =IF(D13>0, "Yes", "No")

• =IF(D13<0, "Yes", "No")

• =IF(D13>0: "Yes", "No")

• =IF(D13<0: "Yes", "No")