IFS-Charts

1. What is the correct syntax of the IF function in Excel?

• IF(condition, value_if_true, value_if_false)

• IF(condition; value_if_true; value_if_false)

• 
  
  
  IF(condition: value_if_true: value_if_false)
  

• IF(value_if_true, value_if_false, condition)

What will =IF(5>3, "Yes", "No") return?

• 5

• Yes

• No

• Error

What does this formula do? =IF(A1>10, "High", "Low")

• Displays "High" if A1 is less than 10
  

• Displays "Low" if A1 is greater than 10
  

• Displays "High" if A1 is greater than 10, otherwise "Low"
  

• Always displays "High"

Which of the following formulas correctly uses nested IFs?

• =IF(A1>90, "A", IF(A1>80, "B", "C"))
  

• =IF(A1>90 "A" IF(A1>80 "B" "C"))
  

• =IF((A1>90, "A"), (A1>80, "B", "C"))
  

• =IF A1>90, "A", IF A1>80, "B", "C"

What is the role of the AND function in an IF formula?

• Checks if any condition is true
  

• Returns the first false condition
  

• Checks if all conditions are true
  

• Sorts data

What will this formula return if A1 = "Yes" and B1 = 80?

=IF(AND(A1="Yes", B1>=75), "Approved", "Denied")

• Approved
  

• Denied
  

• Error
  

• Nothing

Which chart is most suitable for showing trends over time?

• A) Bar Chart
  

• B) Line Chart
  

• C) Pie Chart
  

• D) Doughnut Chart

What is a scatter chart used for?

• Comparing values
  

• Displaying trends
  

• Showing relationships between two numeric variables
  

• Representing text data

You have monthly sales data for 12 months. Which chart type would best show the trend over the year?

• A) Column Chart
  

• B) Pie Chart
  

• C) Line Chart
  

• D) Scatter Chart