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...


6. What function and formula was used in cell E13?
a. =MEAN(E3:E12)
b. =AVERAGE(E3:E12)
c. =SUM(E3:E12)
d. =TOTAL(E3:E12)


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

Extracted text: 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

Jun 06, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?