WorksheetsSpreadsheet If Statements
Total questions: 22
Worksheet time: 16mins
#####
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)
=MAX(D1:D7)*1.5
=OVERTIME(D7*E7)
=IF(D7<40),1.5*E7
What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales in a month?
COUNT
IF
NOW
DAYS360
Ernie uses a spreadsheet to maintain inventory at his store. He wants to use a formula that will automatically reorder the items when they reach a certain quantity. Which function should he use?
IF
MAX
LOOKUP
MIN
Which function will display the word "Yes" when the value of Cell A1 is greater than the value in Cell B1 and "No" when otherwise?
IF
DAYS360
Lookup
MAX
Click the statement that BEST describes an IF Statement:
it is a conditional operator
results are returned IF the data specified in an equation meets conditions set by the formula
IF statements can be written to carry out an action, such as: IF a value in a cell is greater than or equal to another value, insert the word "Pass" in a cell
all of the options
Select the IF statement that will calculate the amount of overtime hours worked.
=IF(Hours Worked<40,Hours Worked+40,0)
=IF(Hours Worked>40,Hours Worked-40,0)
=IF(Hours Worked=40,Hours Worked-40,0)
none
Select the IF Statement that BEST fits the following statement:
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")
=IF(G1=90,"Proficient","Not Mastered")
=IF(G1<89,"Proficient","Not Mastered")
=IF(G1>90,"Proficient","Not Mastered")
What function will produce the results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"?
DATE
COUNT
IF
DAYS360
James has a spreadsheet with daily predicted temperatures. He would like a function to return the label "snow" if the temperature drops below 32 degrees. Which function should he use?
IF
COUNT
DAYS360
NOW
What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?
COUNT
COUNTA
VLOOKUP
IF
What function will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" when otherwise?
IF
LOOKUP
MAX
MIN
What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"?
COUNT
LOOKUP
IF
DAYS360
