hello quizlet
Home
Subjects
Expert solutions
Create
Study sets, textbooks, questions
Log in
Sign up
Upgrade to remove ads
Only $35.99/year
conditional functions
Flashcards
Learn
Test
Match
Flashcards
Learn
Test
Match
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
philosophy para bukas
47 terms
LITERATURE
90 terms
Practical Research 2
41 terms
inserting graphs and charts
10 terms
Other Quizlet sets
Lesão Celular
35 terms
Real Estate Closing Chapter 17
12 terms
RevisionExamenFinalQ4
14 terms