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 )