DEVRY BIS155/BIS 155 WEEK 4 QUIZ - 89609

Solution Posted by
anjis_devis

anjis_devis

Rating : (20)B
Solution Detail
Price: $13.00
  • From: Computer Science, PHP
  • Posted on: Sun 05 Apr, 2015
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
QUESTION 1. 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
Solution Description

Question 1. 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

Attachments
DEVRY_BIS155_week_4_quiz.docx
DEVRY_BIS155_we...