Step Instructions 1 In the Dining Out worksheet, convert the data to a table. Apply Table Style Light 16 2 Sort the table by Description in alphabetical order, then by Store in alphabetical order, and then by Amount from the smallest to the largest. 3 Filter the records using the check box filters to show personal (i.e., non-business) lunch and dinner expenses. 4 Display the Total Row. In cell D48, select the function to total the Amount values. In cell E48, do not show a total. 5 In the June Expenses worksheet, apply the conditional formatting style that displays a Red Data Bar Gradient Fill in the range D2:D47. 6 Create a conditional formatting rule with these specifications to the range A2:C47: Formula to determine which cells to format Formula: =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is greater than or equal to 100 and argument 2 compares $E2 to see if the text is "Yes". Dark Blue (Standard) fill color Blue border color Outline preset border style 7 Create a conditional formatting rule with these specifications to the range A2:C47: Formula to determine which cells to format Formula: =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is less than 100 and argument 2 compares $E2 to see if the text is "Yes". Yellow (Standard) fill color Yellow border color Outline preset border style 8 Create a custom color sort for the Description column with these specifications: Sort on cell color to display the Dark Blue (Standard) fill color on Top as the primary sort. Sort on cell color to display the Yellow (Standard) fill color on Top as the secondary sort. 9 Freeze the top row. 10 Set the Scale to Fit percentage to 140%. Display the worksheet in Page Break Preview and insert a page break so that row 36 starts on a new page. 11 Repeat the titles on row 1 on all pages. 12 Insert a custom footer with the text Exploring Series on the left side, page number in the center, and question3 on the right side of the June Expenses worksheet