Details of this Paper

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


Paper#35198 | Written in 18-Jul-2015

Price : $22