Study sets, textbooks, questions
Upgrade to remove ads
Terms in this set (10)
Which of the following is not a conditional function?
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)?
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'')
Which of the following syntax is the correct representation of COUNTIF function?
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?
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"?
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?
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")))?
Other sets by this creator
philosophy para bukas
Practical Research 2
inserting graphs and charts
Other Quizlet sets
Real Estate Closing Chapter 17