DEVRY BIS155/BIS 155 WEEK 4 QUIZ (ALL CORRECT)

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