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

 Student Answer: Data Validation menu in the Data Tools group on the Data tab of the Ribbon 

  Error Checking command in the Formula Auditing group on the Formulas tab of the Ribbon 

  PivotTable command in the Tables group on the Insert tab of the Ribbon 

  Conditional Formatting command in the Styles group on the Home tab of the Ribbon