Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the following table, which formula is used for counting cells where the Salary value is less than $40,000? =COUNTIF(D2:D17,
Using the following table, which formula is used for counting cells where the "Salary" value is less than $40,000? =COUNTIF(D2:D17,"<40000") =IF(D2:D17<40000,COUNT(D2:D17)) =COUNTIF(D2:D17,<40000) =COUNT(D2:D17,IF(D2:D17<40000))
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started