Display the Sales Reps sheet. By using Flash Fill and deleting columns as necessary, place the last names in column A and the first names in column B$.$ Widen both columns to $100$ pixels, and then merge and center the title Sales Reps across the two columns. Apply the Heading $1$ cell style to the title$\mathrm{.}24$With any sheet except the chart sheet active, group the worksheets. Change the Orientation to Landscape, center the worksheets Horizontally, and insert a footer in the left section with the file name. Mac users, click the Net Sales sheet, hold down SHIFT, and then click the Sales Reps sheet. Then apply the Page Layout options.$)$