pixiedust4756 pixiedust4756

06-04-2018
Computers and Technology

contestada

Which function should be used to display a value based on a comparison ?
A-IF
B-COUNT
C-AVERAGE
D-MIN

Respuesta :

pbzepplin pbzepplin

15-04-2018

The only function that allows a comparison among the options given is the IF statement. So for example, if you want to copy all values in column A to column B, but set all negative values in column A to zero: '= if(A1 <0,0,A1)'

Answer Link

Otras preguntas

Which is less ? -55 or -54

Issued by money-centered financial firms, these short- or medium-term insured debt instruments pay higher interest than a regular savings account. They are low-

Newlyweds Bryce & lauren need to rent a truck to move their belongings to their new apartment. They can rent a truck of the size they need from U-Haul for $

If Janet were to fly from Toronto to London, she might have difficulty adjusting to the new time. This is likely because _______. modern planes fly faster than

Abraham was driving home from school when he suddenly came upon a car that was on fire. He stopped, jumped out of his car, and raced to pull the driver out of t

If safeguarding is not possible what must be used instead

client sells $49,000 of various stocks and wishes to use the proceeds to buy a mutual fund that has breakpoints at $10,000 intervals. Which statement is TRUE? A

Zelda's childhood environment was overly controlling and punished her efforts. As a result, she has difficulty feeling secure and attached to others. According

Assume for Brazil that the opportunity cost of each cashew is 100 peanuts. Which of these pairs of points could be on Brazil’s production possibilities frontier

Choose all the answers that apply. Earth's water: is reused and recycled is mostly freshwater is strongly attracted to other materials has a neutral pH value ca