A. Ensure the Sales worksheet is active.

B. Entered a nested function in cell B8 to create a custom transaction number. The transaction number should be comprised of the item number listed in cell C8 combined with the quantity in cell D8 and the first initial of the payment type in cell E1.

C. Use Flash Fill to copy down the function, completing the data in column B.

D. Enter a nested function in G8 that displays the word Flag if the payment type is credit and the amount is greater than or equal to $4,000.

E. Use the Flash fill to copy down the unction, completing the data in column G.

F. Create a data validation list in cell D5 that displays Quantity, Payment Type, and Amount.

G. Type the trans# 30038C in cell B5 and select Quantity from the validation list in cell D5.

H. Enter a nested lookup function in cell F5 that evaluates the Trans # in cell B5 as well as the category in cell D5 and returns the results based on the data in the range C8:F32.

cApp Cap2_Manufacturing Excel Sign in Insert Draw Page Layout Formulas Data Review View Add-ins LOAD TEST Power Pivot TeamTell me what you want to do Share Insert. .A Calibri Delete . Conditional Fomat as Cell Formatting . Sort & Filter-select . Find & .0 .00 00 + o Table" Styles . T Format . . Clipboard Font Number Styles Date Trans # item quantity Payment Type Amount Status InsuranceFacilities Sales Inventory +70% 10:14 PMM 7/18/2017 Search Windows cApp Cap2_Manufacturing Excel Sign in Insert Draw Page Layout Formulas Data Review View Add-ins LOAD TEST Power Pivot TeamTell me what you want to do Share Insert. .A Calibri Delete . Conditional Fomat as Cell Formatting . Sort & Filter-select . Find & .0 .00 00 + o Table" Styles . T Format . . Clipboard Font Number Styles Date Trans # item quantity Payment Type Amount Status InsuranceFacilities Sales Inventory +70% 10:14 PMM 7/18/2017 Search Windows