excel

I encluded the data sheet and can you andwer all three question please.

Paste Format Painter BIUEAE E E Merge & Center a Clipboard Font Alignment J11 f A B D E F G H H Amount AuthCode Tax Status 1 Month 2 Jan 3 Jan 4 Jan 5 Jan 6 Jan 7 Feb 8 Feb 9 Feb 10 Feb 11 Mar 12 Mar 13 Mar 14 Mar 15 Mar 16 Jan 17 Jan 18 Feb 19 Mar 20 Apr 21 Apr 22 Type Category Personal Restaurant Business Taxi Business Restaurant Personal Restaurant Business Tips Personal Restaurant Personal Entertainment Business Entertainment Business Lodging Business Airfare Personal Restaurant Business Restaurant Business Lodging Business Tolls Business Taxi Business Lodging Business Restaurant Business Airfare Business Tolls Business Entertainment $60.00 $67.00 $89.00 $47.00 $37.00 $57.00 $49.00 $70.00 $123.00 $275.00 $49.00 $70.00 $145.00 $33.00 $63.00 $152.00 $89.00 $447.00 $37.00 $95.00 1.2 Txbl 2.35 Dedct 2.2 Exmp 1.2 Txbl 29 Dedct 1.2 Txbl 1.7 Txbl 2.7 Exmp 2.32 Dedct 2.3 Exmp 1.2 Txbl 22 Exmp 2.32 Dedct 2.36 Dedct 2.35 Dedct 2.32 Dedct 22 Exmp 2.3 Exmp 2.36 Dedct 2.7 Exmp 23 24 25 26 27 28 29 30 You will need an Excel file to answer questions after creating a pivot table. Download the Excel file ExpenseData.xlsx and save the file to your desktop. This questions requires completion of the pivot table from Expenses.xlsx. Configure the pivot table to show categories in rows and type in columns. Filter categories to Entertainment, Restaurant, and Taxi. Show totals as % Grand total. Which of the following percentages best represents the percent of personal restaurant expenses? 5 22 35 57 This questions requires completion of the pivot table from Expenses.xlsx. Configure the pivot table to show categories in rows and type in columns. Have no filters. Show totals as % Column total. About what percent of business expenses is lodging? 08 12 24 47 This questions requires completion of the pivot table from Expenses.xlsx Configure the pivot table to show categories in rows and type in columns. Have no filters. Show totals in default format - no calculation. How much was spent on business taxis? 26 50 80 130