BIS 155 Week 4 Quiz NEW

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) To create a connection between the original data source and the imported data in Excel, use the _ on the Data tab.

Data Validation command
Connection command
Edit Links command
Commands in the Get External Data group

Question 3. Question : (TCO 8) All of the following will display data range properties EXCEPT

click Properties in the Connections Group.
click Edit Links.
click Refresh All arrow and select Connection Properties.
click Connections then click Properties.

Question 4. Question : (TCO 8) Text to Columns command splits text in one column into separate _.

columns
rows
worksheets
workbooks

Question 5. Question : (TCO 8) Which of the following is an example of a text string?

=B5*B7
=SUM(A5:A10)
=IF(B3>B4, B3)
John Doe

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 cannot be used in a CONCATENATE function?

Text
Numbers
Multiple-cell references
Single-cell references

Question 8. Question : (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _ tab of the Ribbon.

Merge
Mailings
Home
Review

Question 9. Question : (TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs?

Review tab
Data tab
File tab
None of the above

Question 10. Question : (TCO 8) An alternative method for inserting a comment in a cell includes

typing the comment into the cell and then clicking New Comment.
right-click the cell and choose Insert Comment.
left-click the cell and choose Insert Comment.
clicking paste on the Home tab after typing in the comment.

Question 11. Question : (TCO 8) The _ tab on the Page Setup dialog box provides options for printing comments.

Page
Margins
Header/Footer
Sheet

Question 12. Question : (TCO 8) The command to send an Excel workbook by e-mail is located on the _ tab.

File, Share
Home, Send
File, Options
View, Email

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