Description of this paper

DEVRY BIS155 week 4 quiz-Which of the following is one of the most common file types imported into Excel




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

Price : $36