Details of this Paper

DEVRY BIS155 week 4 quiz




Question;(TCO 8) Which of the following is one of the most common;file types imported into Excel?;Text;PowerPoint;Web;Word;Question 2. Question;(TCO 8) Which of the following is NOT a text file?;Tab-delimited;Comma-separated value;XML;Fixed-width;Question 3. Question;(TCO 8) Which of the following is NOT a method for;refreshing data?;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.;Fixed;Mixed;Divided;Text;Question 5. Question;(TCO 8) Which of the following is a frequently used function;to manipulate txt?;CONCATENATE;PMT;IF;DATE;Question 6. Question;(TCO 8) To change the text string JANE doe to jane doe, use;the ________ function.;CONCATENATE;PROPER;UPPER;LOWER;Question 7. Question;(TCO 8) Which of the following will produce the same result;as the CONCATENATE function?;=A4&B4;=A4+B4;=A4B4;=A4,B4;Question 8. Question;(TCO 8) If you want to send a letter to all your customers;using Mail Merge, and you already have the customers' names and addresses;stored in an Excel file, you should choose _________ from the Select Recipients;menu while performing the merge.;Type New List;Use Existing List;Import from Excel;Select from Outlook Contacts;Question 9. Question;(TCO 8) The New Comment command is located on the;tab.;View;Review;Data;File;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 ________.;Split Names Wizard;PivotTable feature;CONCATENATE function;Convert Text to Columns Wizard;Question 11. Question;(TCO 8) The command to track changes is located on the;tab.;File;Data;Review;View;Question 12. Question;(TCO 8) If you have ________ configured as your e-mail;client, you can e-mail an Excel file directly from Excel.;Gmail;Hotmail;Yahoo;Outlook;Question 13. Question;(TCO 8) Windows can search for files by author name or;keywords that have been entered into ________.;a file name;the Trust Center;document properties;cell A1;Question 14. Question;(TCO 8) All EXCEPT ___________ are Excel functions that help;you manipulate text.;PROPER;UPPER;SUBSTITUTE;RESPOND;Question 15. Question;(TCO 8) To encrypt a workbook with a password, click Info on;the File tab, click ________, and then select Encrypt with Password.;Check for Issues;Protect Workbook;Manage Versions;Options


Paper#36896 | Written in 18-Jul-2015

Price : $21