| A | B |
|---|
| If a student (Cell G1) earns a 90 or better on the quiz, that is considered proficient, all other scores indicate the topic is not mastered. | =IF(G1>89,"Proficient","Not Mastered") |
| Select the IF statement that will calculate the amount of overtime hours worked. | =IF(Hours Worked>40,Hours Worked-40,0) |
| The number of hours worked is recorded in cell D7, Hourly rate is recorded in cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which function correctly determined how many overtime hours have occurred? | =IF(D7>40,D7-40) |
| This function can be written to carry out an action and is a conditional operator. | If Statements |
| IF A2 is equal to “Feline”, write “Cat” in B2, otherwise, write “Amphibian” | =IF(A2=”Feline”,”Cat”,”Amphibian”) |
| IF A5 is equal to “Carrot”, write “Vegetable” in B5, otherwise, write “Mineral” | =IF(A5="Carrot","Vegetable","Mineral") |
| IF A8 is equal to “Explorer”, write “SUV”, otherwise, write “Sedan” | =IF(A8="Explorer","SUV","Sedan") |
| IF A11 is equal to “Deli”, copy the contents of A11, otherwise, enter 0 | =IF(A11="Deli",A11,0) |
| IF A14 is greater than 0, multiply A14 by 8, otherwise, enter 0 | =IF(A14>0,A14*8,0) |
| IF A17 is equal to 1, enter “True”, otherwise, enter “False” | =IF(A17=1,"True","False") |
| IF A20 is equal to 0, enter “Off”, otherwise, enter “On” | =IF(A20=0,"Off","On") |
| IF A23 is greater than 0, multiply A23 by 15, otherwise, enter 0 | =IF(A23>0,A23*15,0) |
| IF A26 is equal to “Adult”, multiply B26 by 8.50, otherwise, multiply B26 by 5 | =IF(A26="Adult",B26*8.5,B25*5) |
| In H4, (Overtime Hours) enter an IF statement that will calculate the amount of overtime hours worked and copy the formula to the remaining cells in the column | =IF(Hours Worked>40,Hours Worked-40,0) |
| In G4, (Regular Hours) enter an IF statement that will calculate the amount of regular hours worked and copy the formula to the remaining cells in the column. | =IF(Hours Worked<=40,Hours Worked,40) |
| This is added to a cell to make it an Absolute Reference | $ |
| Conditional operators are also known as | if statements |
| An example of a mixed reference | B$1 or $B1 |
| An example of an absolute reference | $B$1 or $A$2 |
| combination of an absolute and a relative cell | mixed reference |
| cell value remains static when copied to other locations | absolute reference |
| refers to a group of adjacent cells | cell range |
| shortcut for a formula | function |
| instructs the software to perform a calculation | formula |
| ALL formulas begin with | an equal sign |
