Chapter 7 activity 5

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

Chapter 5 & 6 Health Infectious and Noninfectious Disease

View Set

(Chemistry H) Benchmarks & Finals: Quarter 3 Benchmark

View Set

Past simple and past participle irregular verbs

View Set

Іспит 📚 Бази Даних

View Set

Factors that will affect insurance cost and basic coverage terms

View Set

NFA 201: Unit 2 SmartBook- Nutrition Information Fact or Fiction?

View Set

Foundations of Western Culture14-27

View Set