Spreadsheet - Advanced Functions and Formulae

Front

A Lookup function is used to?

Back

compare a cell value to an ARRAY of cells and return a value that matches the location of the value in the array.

Front

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

Back

CountIf

Front

What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"? Options: Count, Countif, If, Vlookup

Back

If

Front

Which function would display "Yes" if D13 is greater than 0? Options: =IF(D13>0, "Yes", "No"), =IF(D13<0, "Yes", "No"), =IF(D13>0: "Yes", "No"), =IF(D13<0: "Yes", "No")

Back

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

Front

You are creating a spreadsheet that contains Community Service Hours goals. Column A lists the number of community service hours. Based on the value in column A, column B indicates if the community service hours goal of 500 hrs. was met. Choose the formula that will calculate if the goal was achieved.

Back

=IF(A1>=500, "Yes","No")

Front

The countif function uses two (2) arguments

Back

True

Front

The first argument in the CountIF function is range

Back

True

Front

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")

Back

=countif(A2:B5,"h")

Front

Which one of these functions gives the result shown in the picture? Options: =COUNTIF(D5:D13,"<15"), =COUNTIF(D5:D13,"=16"), =COUNTIF(D5:D13,">=10"), =COUNTIF(D5:D13,">=15")

Back

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

Front

The IF function makes use of something called __________ which is used to form the logical test

Back

relational operators