2023 Document Preview E CH09 EXPV2 IRCD Instructions docx Rental Villas Project Description You are doing some research on rental | Assignment Collections

Document Preview:

E_CH09_EXPV2_IRCD_Instructions.docx Rental Villas Project Description: You are doing some research on rental villas on a Caribbean island for you and your friends during Spring Break. In this project, you will import text, create Web queries, insert text functions, and import XML data. Instructions: For the purpose of grading of the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the workbook file Exploring_e09_Grader_IR.xlsx. 0 2 On the Data tab, in the Get External Data group, use the From Text command to insert the text from the downloaded, comma-delimited text file Exploring_e09_Grader_IR.txt starting in cell A1 of the Sheet1 worksheet. 3 3 Insert a new column between the two existing columns. Separate Column A into two columns, Villa and Location, using the hyphen. Change the name of the worksheet to Beaches. 5 4 Adjust the width of column A to 13.00 (96 pixels). Adjust the width of column B to 10.00 (75 pixels). Adjust the width of column C to 20.00 (145 pixels). Apply bold formatting with Dark Blue, Text 2, Lighter 80% fill color to the column labels in row 1. 7 5 Insert a new worksheet named North Shore to the right of the Beaches worksheet. Create a Web query in cell A1 of the new worksheet to the villa table at http://media.pearsoncmg.com/ph/bp/myitlab/docs/Exp09GraderIRCD/T1Rentals.mht. 12 6 Apply bold formatting with Dark Blue, Text 2, Lighter 80% fill color to the column labels in row 1 of the North Shore worksheet. 4 7 Type LOCATION in cell H1 of the North Shore worksheet. Type STATUS in cell I1 of the North Shore worksheet. Insert a function in cell I2 that will display the status from column G with initial capitalization only. Copy the function to the range I3:I11. Adjust the width of column I to 13.00 (96 pixels). Hide column G. 13 8 Create a nested function in cell H2 that looks up the location code from the Beaches worksheet,…