Upgrade to remove ads
Only $35.99/year

conditional functions

Terms in this set (10)

Which of the following is not a conditional function?
BUT
Which logical operator represents "not equal to"?
<>
What do we callIF(logical_expression, value_if_true, value_if_false)IF(logical_expression, value_if_true, value_if_false)?
Syntax
Which of the following statements is not a feature of conditional functions?
it is used to aesthetically design different sets of data
Check the syntax provided below. Which of the following values will give you a "yes" result?Syntax: =IF(A2>50, ''yes'', ''no'')
60
Which of the following syntax is the correct representation of COUNTIF function?
=COUNTIF(A2:A11,B2)
Luis would like to use a spreadsheet program to divide the cost of his materials by their quantity. Which conditional function would he be likely to use?
IFERROR function
Which of the following syntaxes should a teacher use if he wants to mark his students who scored greater than 50 on both exams A and B, "Pass"?
=IF(AND(A2>50,B>50),"Pass","Fail")
AC Company wants to count the number of products their three representatives were able to sell throughout the year. Which conditional function would they be likely to use?
COUNTIF function
If A2 is 53, what will be the given result using the syntax=IF(A2>80,"Excellent",IF(A2>60,"Good",IF(A2>40, "Fair","Poor")))=IF(A2>80,"Excellent",IF(A2>60,"Good",IF(A2>40, "Fair","Poor")))?
good
Other sets by this creator