BIS 155 Advanced PC Applications
Week 4
Excel Data Exchange (Graded)
Excel 2010 provides the capability to exchange data with other applications. Discuss the different types of ways to exchange data between Excel and other Microsoft applications. Are there limitations to the exchange process? How can you exchange data with other applications that are not part of the Microsoft Office Suite? Discuss how you would exchange data with external data sources such as websites.
Week 4 Quiz
(TCO 8)Which of the following is one of the most common file types imported into Excel? (Points : 2)
(TCO 8)Which of the following is NOT a text file? (Points : 2)
(TCO 8)Which of the following is NOT a method for refreshing data? (Points : 2)
(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited____(Points:2)
(TCO 8) Which of the following is a frequently used function to manipulate txt? (Points : 2)
(TCO 8)To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2)
(TCO 8)Which of the following cannot be used in a CONCATENATE function? (Points : 2)
(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select……. (Points : 2)
(TCO 8)The New Comment command is located on the ________ tab. (Points : 2)
(TCO 8) An alternative method for inserting a comment in a cell includes: (Points : 2)
(TCO 8)The command to track changes is located on the ________ tab. (Points : 2)
(TCO 8) The command to send an Excel workbook by e-mail is located on the ________ tab. (Points:2)
(TCO 8) Windows can search for files by author name or keywords that have been entered into_(Points:2)
(TCO 8) Which function is similar to the Find and Replace feature? (Points : 2)
(TCO 8) To encrypt a workbook with a password, click Info on the File tab, click _____…… (Points : 2)
Week 4 iLABS
BIS 155 Week 4 iLab (Create Address Labels 1)
BIS 155 Week 4 iLab (Create Address Labels 2)
BIS 155 Week 4 iLab (Create Address Labels 3)