Making Decisions

Card 1 of 22 0 got it 0 still learning

Question

TapClick or press space to see the answer

Answer

All 22 cards in this set

In an IF function, what is the correct order of the three parts?: The test, then the value if true, then the value if false
Cell A1 holds 15 and cell B1 holds 15. Which test is true?: A1=B1
A pass is given only when a value is more than 10. Cell A1 holds 10. Is a pass given?: No, because 10 is not greater than 10
The snack shop reorders an item when its stock in B2 falls below 5. Which test should the IF statement use?: B2<5
The discount rule uses =IF(C2>10,D2*0.9,D2). Cell C2 holds 12 and cell D2 holds 30. What is shown?: 27
A travel agent bonus uses the IF statement =IF(Q7>7,1,0). What does cell Q7 hold?: The average rating of the agents
A quiz marks the answer typed in B2. It shows 1 when the answer is 7 and 0 for anything else. Which IF statement should be used?: =IF(B2=7,1,0)
A student types =IF(A1>10,Pass,Fail) and the spreadsheet shows an error. What is the mistake?: The text values are missing their speech marks
A shop's spreadsheet lists only the quantity sold and the price of each product. What should be added before deciding which products are best sellers?: A column that calculates the total sales for each product
Cell A3 contains the word White. What does the formula =IF(A3='White','Yes','No') show?: Yes
The snack shop puts =IF(D2>20,'Yes','No') in cell E2 and copies it down to E13. What does this do?: Checks each row's sales total against 20
A spreadsheet checks whether two customer numbers match with =IF(B2=C2,'Match','No match'). B2 holds 145 and C2 holds 146. What is shown?: No match
A shop manager wants the spreadsheet to work out which products to reorder. Why is an IF function useful here?: It applies the same reorder rule to every product
Which term describes the spreadsheet feature that checks a condition and then shows one of two different results?: IF function
What is meant by the test in an IF function?: The condition that the spreadsheet checks
What is meant by a comparison symbol in an IF function?: A symbol such as =, > or < that is used to compare two values
Which term describes the result that a spreadsheet shows when the condition it is checking is met?: Value if true
What is meant by the value if false in an IF function?: The result a cell shows when the test it is given is false
In the structure =IF(test, value if true, value if false), which symbol separates the three parts?: Comma
In an IF function, what can the value if true and the value if false be?: Text, numbers or a calculation
In an IF function, which values are written inside speech marks?: Text values such as Yes
A student types IF(D2>20,'Yes','No') into a cell and no decision is worked out. What is missing from the formula?: An equals sign at the start

Making Decisions

Round complete