Question 1. In a tab-delimited file, ________ separate the data.

commas

tabs

spaces

hyphens


Question 2. The Text Import Wizard displays when a(n) ________ file is imported.

Access database

XML

CSV

txt

Question 3. 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. The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.

Fixed

Mixed

Divided

Text

Question 5. Which of the following is a frequently used function to manipulate txt?

CONCATENATE

PMT

IF

DATE

Question 6. To change the text string Jack Doe to JACK DOE, use the ________ function.

UPPER

LOWER

PROPER

CONCATENATE

Question 7. Which of the following will produce the same result as the CONCATENATE function?

=A4&B4

=A4+B4

=A4B4

=A4,B4

Question 8. When the data source you select for a mail merge is an Excel workbook that has more than one worksheet, what does Word do?

Automatically uses the data from the first worksheet in the workbook.

Automatically uses the data from the last worksheet in the workbook.

Displays a list of the worksheet names and lets you pick which one to use.

Displays an error message and is unable to continue.

Question 9. 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. 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. The ________ command displays all comments in the entire workbook.

Track Changes

Show Ink

Show/Hide Comment

Show All Comments

Question 12. 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. To display the Properties dialog box, click ________ in the Info section of the Backstage view and select Advanced Properties.

Properties

Show All Properties

Permissions

Versions

Question 14. Which function is similar to the Find and Replace feature?

CONCATENATE

SUBSTITUTE

UPPER

PROPER

Question 15. You can identify duplicate rows in a table using the _________.

Data Validation menu in the Data Tools group on the Data tab of the Ribbon

Error Checking command in the Formula Auditing group on the Formulas tab of the Ribbon

PivotTable command in the Tables group on the Insert tab of the Ribbon

Conditional Formatting command in the Styles group on the Home tab of the Ribbon.