A teacher is compiling data and needs to find the number of B grades. A B grade is any score greater than 79 and less than 90. If the data is listed in B1 through B210, which function would count the grades correctly?   a. =COUNTIFS(B1:B210,>79,B1:B210,<90)   b. =COUNTIF(B1:B210,">79")   c. =COUNTIFS(B1:B210,">79",B1:B210,"<90")   d. =COUNTIFS(B1:B210,">79","<90")

C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter6: User-defined Functions
Section: Chapter Questions
Problem 19PE
icon
Related questions
Question
A teacher is compiling data and needs to find the number of B grades. A B grade is any score greater than 79 and less than 90. If the data is listed in B1 through B210, which function would count the grades correctly?
  a.
=COUNTIFS(B1:B210,>79,B1:B210,<90)
  b.
=COUNTIF(B1:B210,">79")
  c.
=COUNTIFS(B1:B210,">79",B1:B210,"<90")
  d.
=COUNTIFS(B1:B210,">79","<90")
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Datatypes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr