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
makvit [3.9K]
3 years ago
7

Miranda has used a conditional formula to indicate if it's time to order more items. For the produce items, she has a formula se

t up in column D to have the word "No" appear if there are 15 or more items, and the word "Yes" to appear if there are less than 15 items. What is the formula that Miranda used in cell D9?
=?

Please answer quickly! ^‿^
Computers and Technology
1 answer:
ValentinkaMS [17]3 years ago
4 0

According to the given scenario, we need to use both “IF” conditional statement and we require to use the built-in function called “Count()”.

The “Count()” accepts an argument which is list of range where it “counts the number of values”. This value is passed to the” if” condition to check whether it has reached the value of 15. If it is greater than 15 then we print “Yes” using true statement and “No” using false statement block.

Since the range of cell is not provided, the below formula has a text called “range”.

D9 = If(count(range)>15, “Yes”, “No”)

You might be interested in
Explain Organizational approach to System Analysis and Design
9966 [12]

Answer:

The major goal of systems analysis and design is to improve organizational systems. Often this process involves developing or acquiring application software and training employees to use it. Application software, also called a system, is designed to support a specific organizational function or process, such as inventory management, payroll, or market analysis. The goal of application software is to turn data into information. For example, software developed for the inventory department at a bookstore may keep track of the number of books in stock of the latest best seller. Software for the payroll department may keep track of the changing pay rates of employees. A variety of off-the-shelf application software can be purchased, including WordPerfect, Excel, and PowerPoint. However, off-the-shelf software may not fit the needs of a particular organization, and so the organization must develop its own product.

Explanation:

Information systems analysis and design is a method used by companies ranging from IBM to PepsiCo to Sony to create and maintain information systems that perform basic business functions such as keeping track of customer names and addresses, processing orders, and paying employees. The main goal of systems analysis and design is to improve organizational systems, typically through applying software that can help employees accomplish key business tasks more easily and efficiently. As a systems analyst, you will be at the center of developing this software. The analysis and design of information systems are based on:

Your understanding of the organization’s objectives, structure, and processes

Your knowledge of how to exploit information technology for advantage

7 0
3 years ago
The general case in a recursive function is the case for which the solution is obtained directly.
Reika [66]

Answer: False.

Explanation:

The general case of recursive function is when the solution is obtained recursively by simplification at each step.

However, it is the base case in a recursive function when the solution is obtained directly.

The general case must be reducible to base to arrive at a solution else the recursion would be a infinite recursion.

4 0
3 years ago
In a wireless ____ network, devices broadcast directly to each other.
Softa [21]
In a wireless Broadband network
5 0
3 years ago
This assignment involves writing a program that models a dog. A dog has a name, a breed (which may be unknown), a gender (male o
Vinil7 [7]

Answer:

This is very complex for our users please shorten this question. Thank You

Explanation:

3 0
4 years ago
âin order to aid a forensics investigation, a hardware or software ______________ can be utilized to capture keystrokes remotely
faltersainse [42]
(keystroke) logger. I'm hoping this is what you wanted.
5 0
4 years ago
Other questions:
  • How many people assume the product owner role in the Scrum framework?
    15·2 answers
  • Create a class called Home that contains 4 pieces of information as instance variables: county (datatype string), street (dataty
    5·1 answer
  • __________ are hosted on dedicated computers known as 'web servers'.​
    8·2 answers
  • true or false then EXPLAIN why. Since many forms of money do not earn interest, people's demand for money is unaffected by chang
    14·2 answers
  • After reviewing device security you learn that a malicious user in an airport
    14·1 answer
  • All of the following are examples of software, except:
    5·2 answers
  • Which two things can a user view in the Reading pane?
    6·2 answers
  • Any idea how to make my simple python projects such as guess the number, mad libs, etc. even better?
    15·2 answers
  • Execute and explain this program using // in Layman's language. Thank you!
    7·1 answer
  • For which of the four game elements will you give a detailed description about the challenges that the player will face, such as
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!