All categories

3 years ago

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

Computers and Technology

2 answers:

Alika [10]3 years ago

8 0

B. Because conditional statements have an IF before stating the condition

lubasha [3.4K]3 years ago

3 0

Answer:

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.

You might be interested in

Powerful IT security systems are needed to defend against what appears to be authorized access to a network or application. Sele

FrozenT [24]

Answer:false

Explanation: why would you need a powerful it security system, if they already have authorized access?

6 0

2 years ago

Code embedded into an HTML page and downloaded by a user; resides on the client and helps process Web form input. Common clients

Stels [109]

Answer:

TRUE

Explanation:

8 0

2 years ago

// Exercise 4.16: Mystery.java

nignag [31]

Answer:

385

Explanation:

There was no question so I simply run the program for you and included the output.

The program seems to calculate: $\sum\limits_{x=1}^{10} x^2$

8 0

2 years ago

write an algorithm that gets the price for item A plus the quantity purchased. The algorithm prints the total cost, including a

I am Lyosha [343]

Answer:

<u>Algorithm() </u>

1. p = Enter the price of item A.

2. c = Enter the number of A’s purchased.

3. Now the price per item with tax is:

t= p+(p*6/100)

4. The total cost of c items:

ct= t * c.

5. Print ct.

In this algorithm, we are taking the price per item and counting it’s cost including tax. Then we are multiplying the price per item with tax with the number of items we purchase, to find the overall cost with tax.

You may calculate the overall cost without tax as (p*c). Then you can find the overall cost with tax as ((p*c)+(p*c*6/100)), as in both way, we will get the same result.

4 0

2 years ago

What does the Autosum feature on excel do?

BabaBlast [244]

The answer is 1. Pressing the Autosum button highlights the ten cells above it so that you can easily add things together. Hope this helps!

8 0

3 years ago