EXCEL

should look like this after the filter is applied
Filter the PivotTable as follows to make it easier to analyze information : 24. Create a filter for the PivotTable by adding the Type field to the Filters a. area. Filter the table so it displays only members who signed up through FaceLink. b. Insert a slicer that filters the PivotTable based on the Level field value. C. Resize and reposition the slicer so that its upper-left corner appears within cell E3 and its lower-right corner appears within cell H10. d. Use the slicer to filter the PivotTable to display only members at the Benefactor level. e. Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project. NP EX16 AutoSave Developer View Review Formulas Data Page Layout Draw Insert Home File Width: Automatic. Gridlin Colors Ad A Fonts Height: Automatic Vi Print Breaks Background Print Scale 100% Pri Margins Orientation Size Themes Titles Area Effects – Shet Scale to Fit Page Setup Themes Membership Amount B3 G F F D B A (All) Type 2 Membership Amount 5,800 3 Row Labels CCheetah 4 150 CA-104 $ 1,200 CA-127 500 CA-252 1,000 CA-290 50 OR-145 100 $ OR-171 10 1,250 WA-127 $ 11 500 WA-142 $ 12 50 WA-167 $ 13 1,000 WA-218 $ 14 7,525 15 Elephant 1,500 1,000 CA-116 16 CA-148 17 500 S CA-185 18 50 CA-223 19 500 CA-276 20 250 S CA-287 21 100 OR-130 22 75 OR-154 S 23 250 OR-183 24 1,000 $ OR-184 25 500 WA-129 $ 26 1,500 WA-153 $ 27 250 WA-179 $ 28 50 WA-242 29 8,050 30 Gorilla 250 CA-130 $ 31 250 CA-137 $ 32 150 CA-152 33 Consolidat Oregon Washington California Local Offices Documentation Ready 4. noNao o PivotTable F… Choose fields to add to report Search Member ID Туре Level Animal Amount More Tables.. Draq fields between areas below T Filters Columns Туре E Values Rows Members… Animal Member ID Update Defer Layout Update +100% 7 H G E E D B 1 Type Facelink 2 Membership Amount 2,250 3 Row Labels Level ECheetah WA-127 $ 4 Benefactor 1,250 1,000 5 WA-218 $ 6 Elephant OR-184 S Patron 2,500 7 Sponsor 1,000 8 1,500 2,200 WA-153 $ 9 10 Goro CA-167 1,200 11 1,000 WA-116 S 12 13 Lion 2,500 1,250 1,250 9,450 CA-275 14 OR-190 $ 15 16 Grand Total 17 18 19 20 21 22 23 24 Fall PivotTable Spring Consolidated Washington Oregon California Local Offices

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now