Spreadsheet - Advanced Functions and Formulae

A Lookup function is used to?

• compare a cell value to an ARRAY of cells and return a value that matches the location of the value in the array.
• when you want to locate something in a long list
• calculate the date
• Validate the time

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

• Count 
• CountA
• CountIf
• List

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

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.

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

• A. =IF(A1>=500,[Yes", "No"])

• A. =IF(A1>=500,(Yes), (No))

• A. =IF[A1>=500, Yes, No]

The countif function uses two (2) arguments

• False

• True

The first argument in the CountIF function is range

• True

• False

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

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

• functional operators

• relational operators

• relational database

• absolute reference