20 On the Stocks worksheet, separate the text in the first
4 column into two columns using the asterisk( * ) as the delimiter. Insert a function in cell A3 that will display the text in cell A9 with initial capitalization only.
21 On the Stocks worksheet, import the downloaded XML
4 fileeV2 _ highclose. xml into cell A11. Open the XML file in Notepad, and then find and replace all instances of the textGeneral Electric with General Electric Co( no period). Save the XML document and close Notepad. Refresh the XML data on the Stocks worksheet.
22 Apply the Retrospect theme to the workbook. Apply the
2 cell style Accent1 to cells A3 and D3 on the CarLoan worksheet.
23 Set the Author property of the workbook to Exploring
2
Excel Student and then set the Title property to Personal Finances.