Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Add a column to the table named lax in cell I11. In 112, enter a formula that multiples the value in cell B3 on the
Add a column to the table named lax in cell I11. In 112, enter a formula that multiples the value in cell B3 on the GolfReport worksheet by a structured reference to cell E12 on the GolfData worksheet. Use an absolute reference where necessary. Format the Tax column with Accounting Number format. Note, Mac users, copy the formula down through the column, if necessary. Filter data for party size of 2. Filter the data for food orders greater than 60. Copy the filtered data including the column headers in row 11 and paste the filtered data in cell Al of a new sheet named Filter. Autofit the column width of the pasted data. On the GolfData worksheet, copy the table headings in row 11 to cell Al. Clear all table filters. In F2, type Hotel. Create an advanced filter using A1:12 as the criteria range. In E2, type >100. In H2, type TX. Create an advanced filter using A1:12 as the criteria range. In D3, type 1. In F3, type Local. Create an advanced filter using A1:13 as the criteria range. Copy the filtered data including the column headers in row 11 and paste it in cell Al of a new worksheet named Filter2. Autofit the column width of the pasted data. On the GolfData worksheet, insert a slicer for the Cust_Type field. Move the slicer so the top left corner is in cell L2; drag the bottom edge so there is no extra white space. Select Unknown and Local in the slicer, and then clear the filter. Then click Unknown. Insert a second slicer for the Home_State field. Move the slicer so the top left corner is in cell Ll1. Change the caption of the Home_State slicer to Home State. Change the size and properties of the Home State slicer to 3 columns. Change the caption of the Cust_Type slicer to Customer Type. In the Customer Type slicer, select Mix. Apply the Slicer Style Dark 2 to the Customer Type slicer. Apply the Slicer Style Dark 2 to the Home State slicer. Note, depending on the version of Office used, the slicer style name may be Light Orange, Slide Style Dark 2. Note, Mac users, do not create slicers. Instead, on the GolfData sheet, filter the data for records with the Cust_Type as Mix
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started