1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
AnnZ [28]
3 years ago
13

Suppose that cells B1 through B100 of an Excel spreadsheet contain the quantity of units ordered on each of 100 different days.

The Excel function that would count the number of cells that contain quantities of at least 50 is a. =COUNTIF(B1:B100,">=50") b. =COUNTIF(B1:B100,>=50) c. =COUNTIF(B1:B100,>50) d. =COUNTIF(B1:B100,">50")
Computers and Technology
1 answer:
11111nata11111 [884]3 years ago
7 0

Answer:

The "a" Option is correct.

Explanation:

The "COUNTIF" function counts every cell that, given a condition (value), suits into it. As you want to know the number of cells that contain a value of at least 50, the condition must be properly written to get the correct answer. Unless it is a cell value (e.g. B3), the condition must always be written with quotes (""). So, the options b and c are automatically discarded.

The d option appears to be correct, but it's not. If the condition is written ">50", the function will count every cell with a value above 50. But we're searching values at least (including) 50. So the correct answer is the a option.

You might be interested in
general electric always includes an owner registration form with its products. it asks customers for their names, addresses, pho
Marysya12 [62]

The registration, general electric can then sell the information and use it for its own buyer directory. Thus option (A) is correct.

<h3>What is information?</h3>

Information is a general term for everything with the capacity to inform. Information is most fundamentally concerned with the interpretation of what may be sensed. Any naturally occurring process that is not entirely random, as well as any discernible pattern in any medium, can be said to convey some level of information.

An international business based in America is called The General Electric Company (GE). GE has created the technology that will shape the industry for more than 125 years. For its work in the power, renewable energy, aviation, and healthcare sectors, GE is best known today.

Therefore, Thus option (A) is correct.

Learn more about the information here:

brainly.com/question/13629038

#SPJ1

8 0
1 year ago
Which routine is configured to execute first when the program runs?
tester [92]
It's D because of ok
4 0
3 years ago
Brendan is examining a report using the Design view. Which section in the Design view is going to appear only once on the first
goldenfox [79]

Report header section is the section in the Design view is going to appear only once on the first page and could contain logos and title information.

<u>Explanation:</u>

In the Design view, the Create tab is used to create a report within a simple click. Report Wizard is also used in creating reports with various options.

Once you started creating a report, you will notice that it consists of various sections. You have to decide which data used in each section.

Report Header Section will appear at the first page's top also only once throughout the report creation. It consists of contents such as Logo, Report title and Current Date.

3 0
4 years ago
In Black friday 2019 how much percentage of a cut did asus or msi did on gaming laptops did they do 50% off or?
astraxan [27]

Answer:

yes they do 50% off

Explanation:

7 0
3 years ago
What does a close observation of the painting reveal? the people's enjoyment of fishing as a pastime the people's reliance on th
Lana71 [14]
The peoples reliance on the sea industry
6 0
4 years ago
Read 2 more answers
Other questions:
  • What is one important feature of an AUP?
    14·1 answer
  • You are angry at a friend who forgot to meet you for lunch, and you decide to write an e-mail about how it made you feel. What s
    11·2 answers
  • The ________ is a consortium of organizations that develops web protocols and sets standards.
    7·1 answer
  • You are the IT security manager for a retail merchant organization that is just going online with an e-commerce website. You are
    14·1 answer
  • Which firewall monitors traffic from the DMZ to the LAN?
    11·1 answer
  • Sadie helman runs a web site for amateur snowboarders. she likes to post videos and music related to snowboarding on her site as
    12·1 answer
  • Use the drop-down menus to match each description to the correct term.
    13·2 answers
  • 3. Using your knowledge of how an ATM is used, develop a set of use cases that could serve as a basis for understanding the requ
    9·1 answer
  • In which situation is coauthoring of presentations primarily utilized?
    9·1 answer
  • This activity will help you meet these educational goals:
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!