20. Filtering and Slicing Pivot Tables a. Filter customer names to only show customers that begin with the letter B by left clicking the filter icon to show the filter drop down menu (the little triangle in the column header in the same cell as the text Customer Name), selecting Labels Filters, and Begins With. b. Filter product names to only show products that begin with letters between O-Z using Labels Filters Between... c. Insert a Slicer using Order Date and select Feb, May, and Aug. 21. Obtaining Details from Pivot Tables a. For Customer Name and Product Name: Bon app' and Pavlova, double left click the Number of Order Lines for 2018 (double left click on the 2). Note that the details of the two order lines will display in a new worksheet. b. Change the new worksheet name to Bon App Pavlova 2018 Details.

Given the initial list provided, use list comprehensions to create and print the following new lists: 1. locations List of the locations of each of the attractions • result should be ['Esperance', 'Kulin', 'Lake Ballard', ...] 1. Initials List of the attractions that have three words in their name (do not include the location) • result should be ['Tin Horse Highway", "World's tallest bin", ...] Source: https://www.escape.com.au/top-lists/top-10-weirdest-tourist-attractions-in-western-australia/image-gallery 3 weirdest=["Stonehenge, Esperance", "Tin Horse Highway, Kulin", "Inside Australia, Lake Ballard", "Gnomesville, Wellington Mill", "World's tallest bin, Kalgoorlie", "Dave Evans Bicentennial Tree, Pemberton", "Cowaramup cows, Cowaramup", "Corrigin Dog Cemetery, Corrigin", "Nullarbor Links Golf Course, Ceduna to Kalgoorlie", "The Big Camera, Meckering"]

Create an autocomplete input element with an associated datalist that contains the days of the week.

Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20