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#66566 | Written in 18-Jul-2015

Price : $22