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 .