PowerPoint Web Word
Question 2. Question:( TCO 8) To create a connection between the original data source and the imported data in Excel, use the _____ on the Data tab. Data Validation command Connection command Edit Links command Commands in the Get External Data group
Question 3. Question:( TCO 8) All of the following will display data range properties EXCEPT click Properties in the Connections Group. click Edit Links. click Refresh All arrow and select Connection Properties. click Connections then click Properties.
Question 4. Question:( TCO 8) Text to Columns command splits text in one column into separate _____. columns rows worksheets workbooks
Question 5. Question:( TCO 8) Which of the following is an example of a text string? = B5 * B7 = SUM( A5: A10) = IF( B3 > B4, B3) John Doe
Question 6. Question:( TCO 8) To change the text string JANE doe to jane doe, use the _____ function. CONCATENATE PROPER