Answer Happy

Select the extract range starting at cell G5 and apply All Borders (Figure 4-95) ( different from Figure 4-95 depending on the current date.) g Press Ctrl+Home. 9. Import a comma-separated values text file. Click the Expense Info sheet tab. a b. C d. Find and select the ClemensonText-04.csv file downloaded from the Resources link in the Import Data window. Select cell A4 Click the From Text/CSV button (Data tab, Get & Transform Data group] 9. k. Select cell A5 and click the Convert to Range button [Table Design tab, Tools group). Click OK to remove the query definition n. o. p. Select cells A4:D31 and clear the formats [Home tab, Editing group m. Select cells A4:D31 if necessary, and change the font size to 11 pt eClick Import Verify that Comma is selected as the Delimiter in the Navigator window Click the Load arrow and select Load To. Select Existing worksheet hVerify that cell A4 displays as the destination and that Table is how the data will be importer Click OK to import the text data (Figure 4-96) Ocut and paste (or drag and drop) the labels in row 3 to replace the labels in row 4 Select the labels in row 4 and center align them. Format the dates in column C with the Short Date format Select columns A:D and size each column to 12.14 (90 pixels) wide Deselect the columns B A4 5 Allen Gabrys 7 Bashic 8 Gomez Extract Range McAllister Month Apr 2020 CT Scan Aug 2020 CT Scan Dec 2020 CT Scan Apr 2023 CT Scan Aug 2021 CT Scan Jan 2019 MRI 10 Allen 11 Gabrys 12 Bashir May 2019 MRI Sep 1019 MRE Jan 2020 MR May 2020 MB Sep 2020 MR Jan 2021 Ma May 2021 MRI Clemenson Ima Expense Report Infor Last Name First Name Date Colomnt colamn2 Column3 Mary Jo Elizabeth Image P Atef Paola Lex Mary Jo Elizabeth Atef 75 Figure 406 CSV Figure 43 1/1/2019 1/1/2019 1/1/2019 1/1/2019 1/1/2019 2/1/2019 2/1/2019 2/1/2019