DeVry Chicago BIS 155 Week 4 Quiz 2014

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

 Student Answer: commas 

  tabs 

  spaces 

  hyphens 

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

 Student Answer: Access database 

  XML 

  CSV 

  txt 

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

 Student Answer: Click the Refresh All command. 

  Save the Excel workbook. 

  Click the Refresh All arrow, then click Refresh. 

  Right-click in a range of data and then select Refresh. 

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

 Student Answer: Fixed 

  Mixed 

  Divided 

  Text 

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

 Student Answer: CONCATENATE 

  PMT 

  IF 

  DATE 

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

 Student Answer: UPPER 

  LOWER 

  PROPER 

  CONCATENATE 

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

 Student Answer: =A4&B4 

  =A4+B4 

  =A4B4 

  =A4,B4 

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?

 Student Answer: Automatically uses the data from the first worksheet in the workbook. 

  Automatically uses the data from the last worksheet in the workbook. 

  Displays a list of the worksheet names and lets you pick which one to use. 

  Displays an error message and is unable to continue. 

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

 Student Answer: Review tab 

  Data tab 

  File tab 

  None of the above 

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 ________.

 Student Answer: Split Names Wizard 

  PivotTable feature 

  CONCATENATE function 

  Convert Text to Columns Wizard 

Question 11.Question :(TCO 8) The ________ command displays all comments in the entire workbook.

 Student Answer: Track Changes 

  Show Ink 

  Show/Hide Comment 

  Show All Comments 

Question 12.Question :(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.

 Student Answer: Gmail 

  Hotmail 

  Yahoo 

  Outlook 

Question 13.Question :(TCO 8) To display the Properties dialog box, click ________ in the Info section of the Backstage view and select Advanced Properties.

 Student Answer: Properties 

  Show All Properties 

  Permissions 

  Versions 

Question 14.Question :(TCO 8) Which function is similar to the Find and Replace feature?

 Student Answer: CONCATENATE 

  SUBSTITUTE 

  UPPER 

  PROPER 

Question 15.Question :(TCO 8) You can identify duplicate rows in a table using the _________.