Write the formulas you input into excel to find the following based on the data
ID: 2808098 • Letter: W
Question
Write the formulas you input into excel to find the following based on the data above: must be excel formula format ( =SUM... etc)
C) Number of Transactions that has sales higher than $100 and number of items less than 5
A) Date that has highest number of transactions B) Number of Transactions that has sales higher than $100C) Number of Transactions that has sales higher than $100 and number of items less than 5
Retail Transactions This Week Transaction Transaction Department Number of Amount 3 10345839 4 10349307 5 10352810 6 10356348 7 10359922 810363531 9 10367176 10 10370857 11 10374576 12 10378332 13 10382125 14 10385956 15 10389825 16 10393733 17 10397681 18 10401667 19 10405694 20 10409761 21 10413868 22 10418017 23 10422207 24 10426439 25 10430713 26 10435030 27 10439390 28 10443794 29 10448242 30 10452734 31 10457271 32 10461854 33 10466482 34 10471157 35 10475879 36 10480647 37 10485464 38 10490328 3910495241 40 10500204 1 10505215 42 10510277 43 10515390 4 10520554 5 10525769 46 10531037 7 10536357 8 10541731 4910547159 50 10552638 51 10547158 52 10552639 S30.45 S40.15 $40.65 $165.60 $125.00 $250.50 $28.50 00004 1/8/18 1/8/18 1/8/13 1/8/13 $40.45 00004 $462.50 $75.00 $80.30 S40.65 $496.80 $250.50 00004 1/8/18 1/9/18 1/9/18 1/9/18 1/9/18 $1,017.50 $375.00 S80.30 $70.50 $528.45 $290.29 $828.00 1/9/18 00003 100 1/10/18 1/10/18 1/10/18 1/10/18 1/10/18 183 $125.25 00003 $10.1 S92.50 00004 $16.91 $85.50Explanation / Answer
A) Date that has highest no.of transactions is 1/9/18 it has 13 transctions
B) number of transactions that has sales higher thn $100 is 19 transactions are there
c) number of tranactions that has sales higher than $100 and number of items less than 5 is 9 items are there
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.