Chapter 7 activity 5

rk: 1.00/1.00 Question text Use the _____ dialog box to help you write a formula containing an IF function.

function arguments

Question text Use the _____ function to create a logical test that performs a particular action if the answer is true and another action if the answer is false.

IF

To display the Function Arguments dialog box, click the _____ tab, click the _____ button in the Function Library group, and then click IF at the drop-down list.

c. Formulas; Logical

Question text Use a(n) _____ to separate the condition and the action when writing a formula with an IF function.

comma

When you write a formula with an IF statement using the Format Arguments dialog box, Excel automatically inserts quotation marks when you type text in a cell and then press the _____ key.

enter

Question text If you write a formula with an IF statement and want text to be inserted in a cell rather than a value, put _____ around the text.

quotation marks