I need help with number 3 & 4 with formulas

B D E 3 6 A Transaction F Trans Sold G Trans Delivered Trans Item Trans_Qty Trans Category Weekday 1 1 2 3 On the Daily Transactions worksheet, in cell F11, the data in the Trans. Sold column is the number of items sold. (Negative Transaty numbers are the quantity that was sold or outgoing. Positive Trans. Aty numbers are the total number received from the supplier or incorning). Enter an IF function to determine if the Transaty, in C11 is less than zero. If the Trans.ty, is less than zero, then return the absolute value of the Transly, or else the cell is loft blank Copy the formula through cell F40. Trans Sold Sum Average 4 6 On the DaltyTransactions worksheet in cell G11, enter an IF function to determine if there were transactions delivered. If the value in the Trans. Qty is greater than zero, then the result is the value, or else the cell is left blank. Copy the formula through cell G40. Weekday Trans Sold Trans Delivered Mon 5 On the Rail Traosaclions worksheet, in cell D2, type Food and in cell E2, type Fri 2 6 6 On the Daily Transactions worksheet, select the range A10:G40. Name the range Inxentop Table In cell C6, enter a DSUM function to sum the date in the loxentos Table of the field name in CS and the criteria range established in D1:E2. 7 In cell C7. enter a DAVERAGE function to determine the average of the field in cell C5 from the table range data in the loveator Table, and the criteria range established in D1:E2. 6 Format cell C7 with no decimal places. 4 5 6 7 7 8 8 9 9 10 Transaction 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Trans_Item 1 A1 2 A3 3 AS 4 A3 5 A6 6 6 A3 7 A1 & A2 9 A7 10 A19 11 Al 12 A10 13 A1 14 AS 15 AZ 161 Al 17 A3 18 A15 19 A13 20 A14 21 A4 22 A9 23 AS 24 A15 25 A17 26 Ag 27 A14 28 A17 29 A18 30 AZ Trans Qty Trans Category -14 Food 5 Food -7 Golf -14 Faad -15 Massage -16 Food -7 Food 10 Clothing 4 Clothing -2 Golf 15 Food -18 Massage 6 Faad Clothing -13 Clothing -2 rood -17 Foad & Clothing 5 5 Golf -11 Novelty 4 Reading O Gol! 18 Golf 6 Clothing 4 Novelty -18 Golf 13 Novelty -15 Novelty -14 Reading -9 Clothing Mon Wed Thur Fri Fri Fri Fri Sat Sun Thur Mon Wed Thur Fri Fri Sat Sat Mon Mon Mon Tues Wed Wed Thur Thur Thur Created On: 07/05/2019 YO_Exon16_BUDB_PS1 V2 Grader - Instructions Excel 2018 Project Step Instructions Points Possible Fri Fri Sat B On the Inventory Audit worksheet, the cells in range A3:D17 need to be filled in based on the 6 gemar that is listed in Rich The table will then contain the information about 41