For more course tutorials visit www. uophelp. com
For more course tutorials visit www. uophelp. com
Week 4 Quiz
1.( TCO 8) Which of the following is one of the most common file types imported into Excel?( Points: 2) 2.( TCO 8) Which of the following is NOT a text file?( Points: 2) 3.( TCO 8) Which of the following is NOT a method for refreshing data?( Points: 2) 4.( TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited ____( Points: 2) 5.( TCO 8) Which of the following is a frequently used function to manipulate txt?( Points: 2) 6.( TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.( Points: 2) 7.( TCO 8) Which of the following cannot be used in a
CONCATENATE function?( Points: 2) 8.( 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)
9.( TCO 8) The New Comment command is located on the ________ tab.( Points: 2)
10.( TCO 8) An alternative method for inserting a comment in a cell includes:( Points: 2)
11.( TCO 8) The command to track changes is located on the ________ tab.( Points: 2)
12.( TCO 8) The command to send an Excel workbook by e- mail is located on the ________ tab.( Points: 2)
13.( TCO 8) Windows can search for files by author name or keywords that have been entered into _( Points: 2)
14.( TCO 8) Which function is similar to the Find and Replace feature?( Points: 2)
15.( TCO 8) To encrypt a workbook with a password, click Info on the File tab, click _____......( Points: 2)