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.