Microsoft Excel 2016: Sub IF Function Quiz

What is the primary purpose of the Sub IF function in Excel?

• To subtract values based on a condition

• To add values based on a condition

• To multiply values based on a condition

• To divide values based on a condition

Which of the following can be used as criteria in the Sub IF function?

• Only text

• Both text and operators

• Only numbers

• Only operators

In the example provided, what is the first step in setting up the Sub IF function?

• Close the brackets

• Type equals and then Sub IF

• Select the sum range

• Type the criteria

What is the purpose of using speech marks in the Sub IF function?

• To indicate a cell reference

• To indicate a number

• To indicate a text string

• To indicate an operator

What does the tutorial encourage viewers to do after learning about the Sub IF function?

• Stop using Excel

• Only use the Sub IF function

• Explore more tutorials and formulas

• Forget about the function