4. What function and formula was used in cell F5?a. =CONCATENATE(E5, "Available", "Unavailable")b. =IF(E5>0, "Available”, “Unavailable")c. =IF(D5>0, "Available”, “Unavailable")d. =IF_ELSE(E5>0, "Available”, “Unavailable") AEFLIST OF PRODUCTSItem No.Item Name1001 Ice Cream1002 Cake1003 Chocolate1004 Pizza1005 Soap1006 ShampoO1007 Toothpaste1008 Toothbrush1009 Cologne1010 Ballpen10PricesPhp50.00StocksStatus100 AvailableOUnavailable200 Available4 Available250 AvailableOUnavailableo Unavailable100 AvailableO Unavailable300 Available95423Php395.00Php40.00Php350.00Php38.00Php7.00Php75.00Php120.00Php900.00Php78.0010 Php2,053.0045710111213 Total:1415 Number of Available Items:16 Number of Unavailable Items:17 Search the price of item 1002:4Php395.001001 | Ice Cream, Php 50| Available 10018

IF function in Excel: The IF function performs the logical operation to evaluate the specified…

Answered: What function and formula was used in…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

4. What function and formula was used in cell F5?
a. =CONCATENATE(E5, "Available", "Unavailable")
b. =IF(E5>0, "Available”, “Unavailable")
c. =IF(D5>0, "Available”, “Unavailable")
d. =IF_ELSE(E5>0, "Available”, “Unavailable")

A
E
F
LIST OF PRODUCTS
Item No.
Item Name
1001 Ice Cream
1002 Cake
1003 Chocolate
1004 Pizza
1005 Soap
1006 ShampoO
1007 Toothpaste
1008 Toothbrush
1009 Cologne
1010 Ballpen
10
Prices
Php50.00
Stocks
Status
100 Available
OUnavailable
200 Available
4 Available
250 Available
OUnavailable
o Unavailable
100 Available
O Unavailable
300 Available
954
2
3
Php395.00
Php40.00
Php350.00
Php38.00
Php7.00
Php75.00
Php120.00
Php900.00
Php78.00
10 Php2,053.00
4
5
7
10
11
12
13 Total:
14
15 Number of Available Items:
16 Number of Unavailable Items:
17 Search the price of item 1002:
4
Php395.00
1001 | Ice Cream, Php 50| Available 100
18

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions