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