answer.
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
Nezavi [6.7K]
2 years ago
12

Give the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value

of the function in the string is YES; if not, it is a blank space. If cell B7 does not equal 12, then the value of the function is 7
Computers and Technology
1 answer:
ASHA 777 [7]2 years ago
5 0

Answer:

=IF( B7 = 12, ( IF( B10 = 10,"YES", "")), 7) and PRESS ENTER

Explanation:

the above logical if function checks the following

-IF cell B7 is 12, if true, check the value of cell B10, IF cell B10 contains 10 the function should produce YES as output to whatever cell selected, IF B10 is not 10 output of the function should be an empty string, IF B7 is not equal to 12 the the output of the function should be 7.

You might be interested in
The Gas-N-Clean Service Station sells gasoline and has a car wash. Fees for the car wash are $1.25 with a gasoline purchase of $
beks73 [17]

Answer:

d = {"R":2.89,"P":3.09, "S":3.39, "N":0}

noofgallons = input("Enter number of Gallons:")

gastype = input("Enter Gas type/; R,P,S,N")

cwr = input("Is Car Was Requieed")

if(gastype == "R"):

   gal == nooffgallons * d['R']

   if (cwr=="y" and gal<10):

       gal+=3.00;

       elif(cwr=="y" and gal>=10):

           gal+=1.25

           elif(cwr=="n"):

               gal=gal

   elif(gastype==P):

       gal== nooffgallons * d['P']

       if(cwr="y" and gal<10):

           gal+=3.00;

           elif(cwr=="y"and gal>=10):

           gal+=1.25

           elif(cwr=="n"):

               gal=gal

       elif(gastype ==S):

           gal=noofgallons *d['S']

           if(cwr="y" and gal<10):

               gal+=3.00;

               elif(cwr=="y"and gal>=10):

                   gal+=1.25

                   elif(cwr=="n"):

                       gal=gal

                       

                       

print("tptal cost paid"+ gal)

The above program uses a dictionary for storing gasoline types and their cost, and dictionary is always constant, and hence its fulfilled the requirement of keeping it constant. And car wash is treated accordingly. And if elif else ladder has been used to calculate the total number of gallons.

Rest part is self explanatory.

Explanation:

The code is self explanatory.

7 0
2 years ago
Janis needs to select all the text in a single bullet point. Which action describes the easiest method to perform this task?
olganol [36]

Answer:

Triple-click the text in the bullet item is the easiest  way to select all text

Explanation:

5 0
2 years ago
If the__________ is/are out of balance, the driver will feel a pounding or shaking through the steering wheel.
RUDIKE [14]
If the VEHICLE(S) is/are out of balance, the driver will feel a pounding or shaking through the steering wheel.
This pounding <span>shortens the life of all the suspension components and hence</span> <span>produce an uneven tire wear and  which eventually </span>will<span> increase fuel consumption.</span>

4 0
2 years ago
Read 2 more answers
What is illustrated in the cells to the right of the Fourth Quarter column?
beks73 [17]
Photosynthesis is illustrated in the cells to the right of the fourth column
5 0
2 years ago
Read 2 more answers
Jane is designing a print brochure for a retail company. She’s having trouble deciding on the page margin. Which best practice w
8090 [49]

I think the answer will be C

7 0
2 years ago
Read 2 more answers
Other questions:
  • Data Analysis The Iris Plants Database contains 3 classes of 50 instances each, where each class refers to a type of Iris plant.
    15·1 answer
  • Write a method named lastFirst that accepts a string as its parameter representing a person's first and last name. The method sh
    13·1 answer
  • Describe a situation involving making a copy of a computer program or an entertainment file of some sort for which you think it
    7·1 answer
  • Write a program that prints the U.S. presidential election years from 1792 to present day, knowing that such elections occur eve
    9·1 answer
  • Your network administrator finds a virus has been successfully inserted into the network software. The virus itself is now consi
    10·2 answers
  • Write measurable performance objectives.Suppose that a trainer has identified as a generalgoal for a training module,"Able to fo
    13·1 answer
  • Which OS function does a CLI fulfill? A User interface B Running applications C Hardware interface D Booting
    8·1 answer
  • All of the following are true of functions except: Group of answer choices They define specific tasks that can be used at many p
    5·1 answer
  • Even though Wordpress is basically free, what is the company trying to accomplish?
    11·1 answer
  • 1.erros can easily be ____ 2.work is done in an ____ no mess environment 3.colors do not _____ and brushes are never ______ 4.st
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!