Excel Nested IF Quiz

What is the biggest advantage of using nested IF statements in Excel?

• Allows you to classify data based on multiple conditions

• Allows you to perform arithmetic calculations

• Allows you to nest up to 64 IF functions in one formula

• Allows you to check more than one condition and return different values

How many levels of nested IFs are allowed in Excel 2007 and higher?

• 7

• 64

• 10

• Unlimited

In the example given, what score range is classified as 'Good'?

• Under 150

• Over 249

• Between 199 and 150, inclusive

• Between 249 and 200, inclusive

What is the result of the nested IF formula if the score is 170?

• Excellent

• Good

• Satisfactory

• Poor

In the second example, what is the price per unit for a quantity of 50?

• $16

• $20

• $13

• $18

What is the result of the nested IF formula if the quantity is 201?

• $2,412

• Qty. out of range

• $2,016

• $1,300

What is the maximum number of nested IF functions allowed in Excel 2003 and lower?

• 7

• 64

• 10

• Unlimited

What happens if the parentheses in a nested IF formula do not match?

• The formula returns incorrect results

• The formula crashes Excel

• The formula still works correctly

• The formula returns an error

How should text and numbers be treated in logical tests of nested IF formulas?

• Enclose both text and numbers in double quotes

• Enclose text values in double quotes, but not numbers

• Enclose numbers in double quotes, but not text values

• Do not use quotes for either text or numbers

What is a recommended way to make nested IF formulas easier to read?

• Add spaces or line breaks between different IF functions

• Use comments to explain the logic of the formula

• Remove all spaces and line breaks to condense the formula

• Use indentation to visually separate different IF functions