IF Function

A predefined formula that performs calculations using specific values in a particular order.

• Function

• Reference

• Chart

Multiple arguments must be separated by a ______________.

• Space

• Comma

• = Sign

• !

What is the quickest way to enter a function in a cell if you already know the name of the function?

• Search for the function in the Formula tab.

• Use the AutoSum feature.

• Directly enter the function in the cell.

• Use the AutoFill feature.

A(n) _________ is a prewritten formula that is built into EXCEL. 

• function
• problem
• equation
• equal sign

A combination of numbers and symbols used to express a calculation. Always begins with an = sign.

• Cell address
• Worksheet
• Formula

Excel allows you to

• read stories
• work with data
• invent ideas

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column

Which text properly matches the IF function shown?

• If it is at least 60°F, wear jeans. Otherwise, wear shorts.

• If it is at least 60°F, wear shorts. Otherwise, wear jeans.

• If it is over 60°F, wear shorts. Otherwise, wear jeans.

• If it is over 60°F, wear jeans. Otherwise, wear shorts.

Which option matches the IF function shown?

• If the song is bad, skip it. Otherwise, play it.

• If the song is bad, play it. Otherwise, skip it.

• If the sing is good, skip it. Otherwise, play it.

• If the song is good, play it. Otherwise, skip it.

Which text properly matches the IF function shown?

• If you are full, order desert. Otherwise, don't order desert.

• If you are full, don't order desert. Otherwise, do not order desert.

• If you are full, don't order desert. Otherwise, do order desert.

• If you are hungry, order desert. Otherwise, don't order desert.