Question 1 . Question : ( TCO 8 ) Which of the following is one of the most common file types imported into Excel ? Text 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