DEVRY BIS155 WEEK 4 QUIZ

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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.