(TCO 8) Which of the following is one of the most common file types imported into Excel?(Points : 2)

$9.99
BIS 155 Data Analysis with Spreadsheets w/Lab Week 4 Quiz Answers (Office Integration and Mail Merge)

 

  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?
  3. (TCO 8) Which of the following is NOT a method for refreshing data?
  4. (TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.(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 Recipients menu while performing the merge. (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 ________, and then select Encrypt with Password.(Points : 2)