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
Which of the following is not a valid FICO Credit score?
kumpel [21]

Answer: C 475

Explanation:  These choices are A. 375, B. 276, and D. 575. so that wolde mean it would be C 475.

8 0
3 years ago
Read 2 more answers
Your friend just noticed his smartphone's battery is running low. Unfortunately, your friend isn't very knowledgeable about comp
AlekseyPX

Answer:

Lightning

Explanation:

<em>Apple Inc. designed and developed the Lightning computer bus and power connection. Apple mobile devices such as iPhones, iPads, and iPods use the Lightning connection to connect to host computers, external displays, cameras, USB battery chargers, and other accessories. Lightning is substantially smaller than its predecessor, with only 8 pins instead of 30.</em>

3 0
2 years ago
What are 4 ratios equal to 60%?
Elza [17]
6:10
3:5
9:15
12:20

These are all equal to 60%
3 0
3 years ago
Read 2 more answers
Which 4 frame types are found in Adobe InDesign? (Choose 4.)
Ugo [173]

Answer:

InDesign has three kinds of frames: text frames, graphic frames, and unassigned frames. Graphic Frames: When you use one of the Frame tools (those are the ones with an “X” in the middle of them), InDesign creates a graphic frame.

Explanation:

4 0
3 years ago
Read the following scenario:
mote1985 [20]
C - the test feedback is quicker at the online school than at the bricks-and-mortar school :)
6 0
2 years ago
Read 2 more answers
Other questions:
  • Natalie wants to create a database to collect information about sales transactions. She would like to use the database to look u
    7·1 answer
  • When employees are hired, they agree to only use cell phones during breaks. How would you classify this?
    13·2 answers
  • How can an individual find career data?
    13·1 answer
  • Josh wants to convey his best wishes to johnathin for a meeting schedualed later diring the day. Which business documented would
    7·1 answer
  • 20 points
    6·2 answers
  • Which components exist in the contextual tab for tables called Design? Check all that apply. Table Styles Export Table Data Prop
    11·2 answers
  • A rocket always rotates about its___?
    9·2 answers
  • Which statement best describes the difference between a spreadsheet and a database?
    9·2 answers
  • Who here has a crush on jk from bts but feels more mature than him
    10·2 answers
  • Why is a salt added to a password that is being stored in a database?
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!