IF Statements

How many choices are possible when using a single if-else statement?

• 1
• 2
• 3
• 4

This function can be written to carry out an action and is a conditional operator. 

• If Statements
• List Functions
• Count Functions
• Lookup Functions

conditional operators are also known as 

• mathematical operators
• if statements
• date functions

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 determines how many overtime hours have occurred

• =IF(D7>40,D7-40)
• =MAX(D1:D7)*1.5
• =OVERTIME(D7*E7)

An absolute reference is designated in a formula by the addition of a _______ sign. 

• %
• $
• &
• #

Unlike _________ references, _________ references do not change when copied or filled. 

• Absolute, Relative
• Relative, Absolute

If you see this code, what do you need to do?
#####

• Check your function syntax
• Re-enter the function formula
• Widen the column
• Use a different function

IF, AND, OR and NOT are all part of which category of functions?

• Math and Trig
• Text
• Logical
• Lookup and Reference

Press this when you are done entering a function or formula

• enter
• backspace
• tab
• shift

Formatting that appears only when the cell value meets certain terms you specify.

• style
• conditional
• specific
• custom