BIS 155 WEEK 4 QUIZ

BIS 155 
WEEK 4 
 1.
Question :
(TCO 8) In a tab-delimited file, ________ separate the data.

Question 2.
Question :
(TCO 8) The Text Import Wizard displays when a(n) ________ file is imported.

Question 3.
Question :
(TCO 8) Which of the following is NOT a method for refreshing data?

Question 4.
Question :
(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.

Question 5.
Question :
(TCO 8) Which of the following is a frequently used function to manipulate txt?

Question 6.
Question :
(TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.

Question 7.
Question :
(TCO 8) Which of the following will produce the same result as the CONCATENATE function?

Question 8.
Question :
(TCO 8) When the data source you select for a mail merge is an Excel workbook that has more than one worksheet, what does Word do?

Question 9.
Question :
(TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs?

Question 10.
Question :
(TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________.

Question :
(TCO 8) The ________ command displays all comments in the entire workbook.
Question :
(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.
Question :
(TCO 8) To display the Properties dialog box, click ________ in the Info section of the Backstage view and select Advanced Properties.
Question :
(TCO 8) Which function is similar to the Find and Replace feature?
Question :
(TCO 8) You can identify duplicate rows in a table using the _________.