21	Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than or equal to $4000. Otherwise, the function will display a blank cell. Use Auto Fill to copy the function down, completing the data in column G.	7
22	Create a data validation list in cell D5 that displays Quantity, Payment Type, and Amount.	5
23	Type the Trans# 30038C in cell B5, and select Quantity from the validation list in cell D5.	2
24	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 A8:F32.	3
25	Create a PivotTable based on the range A7:G32. Place the PivotTable in cell I17 on the current worksheet. Place Payment Type in the Rows box and Amount in the Values box. Format the Amount with Accounting Number Format.	5
26	Insert a PivotChart using the Pie chart type based on the data. Place the upper-left corner of the chart inside cell I22. Format the Legend of the chart to appear at the bottom of the chart area. Format the Data Labels to appear on the Outside end of the chart. Note, Mac users, select the range I18:J20, on the Insert tab, click Recommended Charts, and then click Pie. Format the legend, and apply the data labels as specified.	4
27	Insert a Slicer based on Date. Place the upper-left corner of the Slicer inside cell L8.	3
28	Ensure the Inventory worksheet is active. Import the Access database eApp_Cap2_Inventory.accdb into the worksheet starting in cell A3. Note, Mac users, download and import the delimited Inventory.txt file into the worksheet starting in cell A3.	5
29	Create a footer with your name on the left, the sheet code in the center, and the file name on the right for each worksheet.	2
30	Save and close the file. Based on your instructor's directions, submit eApp_Cap2_Manufacturing_LastFirst.xlsx.	0

Total Points

100