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
What is the difference between Notepad and WordPad?is one more adavnced?if so which one or Notepad is the Mac equivalent of Word
Kitty [74]
WordPad is defenitely more advanced.
There is no Mac equivalent.
4 0
3 years ago
100 points !!! Some games fall under more than one category. For example, many racing games allow players to modify the cars the
Ugo [173]

Answer:

game 1: roblox, its not technically a game, however it contains game that could fall under more than one category. Game 2: Dungeons and Dragons could fall under role play and also adventure

Explanation:

7 0
3 years ago
Read 2 more answers
What is the importance of planning before you start your vegetable farm business?
yulyashka [42]

Answer with Explanation:

"Planning" plays a crucial role before starting any business. If you've decided to start a vegetable farm business, <em>then you better plan ahead</em>.

Vegetables are "perishable," which means<em> it is easy for them to get spoiled</em>. Thus, you have to consider many things such as: <u>what kind of crops to sell, where to sell them, what season you're going to sell them and how much you are going to sell them</u>.

Choosing the kind of crop depends on <em>whether you'll be requiring intensive labor or not.</em> Although the former means more profit, <u>it will require more capital.</u> Knowing your target market is essential. For example, if your target are health-conscious people, then you have to go for organic vegetables. Determining the season to sell the vegetables will allow you to price them accordingly. Lastly, you have to know how much you're going to sell your vegetables<u> in order for you to have an idea of the profit you're going to make.</u> This will also allow you to budget your money.

7 0
3 years ago
Eric has a new job as a front-end developer. He has a degree in web design. He knows programming languages such as HTML and CSS.
ryzh [129]

Answer:

B

Explanation:

I will recommend "FLEX" as the advanced technology for front-end development because of the following below:

1. Flex applications are usually Flash Player based.

2. Flex applications developed can run on Android, BlackBerry Tablet OS, and iOS devices.

3. Flex applications built can run on Browsers as well as on Desktop.

In addition, Flex applications are platform independent.

7 0
3 years ago
What was the biggest problem with the earliest version of the internet in the late 1960’s?
posledela

Answer:

Explanation:

1.security issue

2. Computers were too big

3. Not very reliable

4. Networks couldn't talk to each other

5. Only be used in universities, governments, and businesses

8 0
3 years ago
Other questions:
  • Consider a multiprocessor CPU scheduling policy. There are 2 options: 1) a singlecommon ready queue of jobs; when a CPU becomes
    8·1 answer
  • Which one of the following is not possible to view in the debug logs?
    8·1 answer
  • How do Web browsers interact with URL/URIs to navigate the internet
    14·1 answer
  • Convert the following pseudocode to C++ code. Be sure to define the appropriate variables. Store 25 in the speed variable. Store
    5·1 answer
  • 1. Consider a direct-mapped cache that can accommodate 8Mbytes from a main memory, that uses a 32-bit address and 32-byte blocks
    5·1 answer
  • I stole you pokemon cards :o
    6·2 answers
  • The blank provides access to the internet May also be internal ??
    14·1 answer
  • Add (total) all the number in the list (below) using a for loop, but skip over the number at index 3.
    14·1 answer
  • List the components of a typical operating system and summarize the role of each in a single phrase.
    6·1 answer
  • One of the factors that influence the effectiveness of chemical sanitizer works effectively between 13° C and 49° C​
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!