Ask Question
Computers & TechnologyComputers & Technology
17 December, 18:25

When working in excel online, which of the following is considered a conditional formula?

A) A1+F1-H1

B) If (A1>1, true, false)

C) = sum (A1:J1)

D) = sum (A1:A9) - A10

+1
Answers (2)
  1. 17 December, 21:09
    0
    If (A1>1, true, false)

    Explanation:

    A conditional formula always contains keyword "if". The output value is dependent on whether the condition defined in the if statement is met or not.

    In the given statement If (A1>1, true, false), the Excel will check if A1 bigger than 1, it will result in true value otherwise false value. This is consider a simple example of conditional formula that only handles two conditions. In some complex cases that need to handle more than two conditions, we have to extend the formula with additional if statement.
  2. 17 December, 21:41
    0
    B. Because conditional statements have an IF before stating the condition
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “When working in excel online, which of the following is considered a conditional formula? A) A1+F1-H1 B) If (A1>1, true, false) C) = sum ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
The southwest of the U. S. has its own regional identity composed of what three cultural groups
Answers (1)
if you play creative destruction and if u have a mic and if u play it 24/7 and would like to form a team tell me your name or your ID number
Answers (1)
Define a function PyramidVolume with double parameters baseLength, baseWidth, and pyramidHeight, that returns as a double the volume of a pyramid with a rectangular base.
Answers (1)
A motherboard has four DIMM slots; three slots are gray and the fourth is black. What type of memory is this board designed to use?
Answers (1)
John's father specifically asked him to get a magnetic disk from the store in his neighborhood. What should John buy?
Answers (1)
New Questions in Computers & Technology
What is the difference between a learner's license and a driver's license? Name the written test a potential driver must pass and list the minimum required score to earn a learner's license.
Answers (1)
Are websites required to keep logs of visitors by law?
Answers (1)
Recall when you built your binary message sending device. Why did we decide to send a message as a sequence of states (A and B) rather than modifying our devices to represent more states (State C, State D, State E, ...)
Answers (1)
Public-key cryptography can be used for encryption (ElGamal for instance) and key exchange. Furthermore, it has some properties (such as nonrepudiation) which are not offered by secret key cryptography.
Answers (2)
What kind of heat we feel from the sun
Answers (2)
Home » Computers & Technology » When working in excel online, which of the following is considered a conditional formula? A) A1+F1-H1 B) If (A1>1, true, false) C) = sum (A1:J1) D) = sum (A1:A9) - A10
Sign Up Forgot Password?