8. What function and formula was used in cell F6? a. =CONCATENATE(E6, "Available", "Unavailable") b. =IF(E6>0, "Available”, “Unavailable") c. =IF(D6>0, "Available”, “Unavailable") d. =IF_ELSE(E6>0, "Available”, “Unavailable")
Max Function
Statistical function is of many categories. One of them is a MAX function. The MAX function returns the largest value from the list of arguments passed to it. MAX function always ignores the empty cells when performing the calculation.
Power Function
A power function is a type of single-term function. Its definition states that it is a variable containing a base value raised to a constant value acting as an exponent. This variable may also have a coefficient. For instance, the area of a circle can be given as:
8. What function and formula was used in cell F6?
a. =CONCATENATE(E6, "Available", "Unavailable")
b. =IF(E6>0, "Available”, “Unavailable")
c. =IF(D6>0, "Available”, “Unavailable")
d. =IF_ELSE(E6>0, "Available”, “Unavailable")
Trending now
This is a popular solution!
Step by step
Solved in 2 steps