only answer if knowledgable on excel!!

Incorrect Question 3 0/1 pts This Pivot Table was created from the Insert Pivot Table icon from the Insert Ribbon. If your cursor is in the red circled cell (in the body of the PivotTable) or the the blue circled cell (in the totals row of the PivotTable). What is in the Formula Bar at the top of the worksheet? Sum of Note Column Labels RowLabels samboo Coffee Table Bamboo End Table Captain Recliner Chameleon Couch Media Armoire Grand Total 5. Bemotive 79 107 142 6 Kirsten, Dotty 209 110 151 117 13 770 7 Leon, Emily 154 124 300 167 632 Lucas, John 77 110 172 516 Malley, Terri 19 150 174 166 599 10 Maynard, Susan 147 145 116 212 705 11 McCullough Scott 33 62 72 90 121 12 Norman, Rita 134 145 172 13 Owen, Robert 658 157 120 29 170 BLO 14 Ramey, Sam 239 199 214 199 217 1000 15 Trige, Norm 150 69 101 130 585 16 Warren, Leonard 154 101 121 91 so 17 Grand Total 1612 14 LO 1679 1815 7997 5g*39**332 Blank. PivotTable values don't show in the Formula Bar. A complex IF function when you select the cell in the red or blue circle. No formulas or functions, just numbers (for example, 147 when I select the cell in the red circle). A SUM function when you select the cell with the blue circle. Incorrect Question 4 0/1 pts Which of the following are advantages of using Slicers over traditional Filters in a PivotTable: (Choose all that are True.) Slicer boxes allow for more interactive data filtering. Filtering is only available in older versions of Excel. Filters only work on Text data Slicer boxes show which data has been filtered out