DEVRY BIS155 WEEK 4 QUIZ
- Mastermind
- Rating : 6
- Grade : A+
- Questions : 0
- Solutions : 3687
- Blog : 0
- Earned : $13683.31
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
[Solved] DEVRY BIS155 WEEK 4 QUIZ
- This Solution has been Purchased 2 time
- Submitted On 05 Apr, 2015 10:39:23
- Mastermind
- Rating : 6
- Grade : A+
- Questions : 0
- Solutions : 3687
- Blog : 0
- Earned : $13683.31