Page 1
Question 1.1.(TCO 8) Which of the following is one of the most common file types imported into Excel?(Points : 2)
Text
PowerPoint
Web
Word
Question 2.2.(TCO 8) Which of the following is NOT a text file?(Points : 2)
Tab-delimited
Comma-separated value
XML
Fixed-width
Question 3.3.(TCO 8) All of the following will display data range properties EXCEPT:(Points : 2)
click Properties in the Connections Group.
click Edit Links.
click Refresh All arrow and select Connection Properties.
click Connections then click Properties.
Pool 4, MC 2 Points Each
Question 4.4.(TCO 8) The Text to Columns command is found on the ________ tab.(Points : 2)
File
Data
Insert
Page Layout
Question 5.5.(TCO 8) Which of the following is an example of a text string?(Points : 2)
=B5*B7
=SUM(A5:A10)
=IF(B3>B4, B3)
John Doe
Question 6.6.(TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.(Points : 2)
UPPER
LOWER
PROPER
CONCATENATE
Question 7.7.(TCO 8) Which of the following will produce the same result as the CONCATENATE function?(Points : 2)
=A4&B4
=A4+B4
=A4B4
=A4,B4
Question 8.8.(TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _________ tab of the Ribbon.(Points : 2)
Merge
Mailings
Home
Review
Question 9.9.(TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs?(Points : 2)
Review tab
Data tab
File tab
None of the above
Question 10.10.(TCO 8) If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need:(Points : 2)
empty columns to the right of column C.
empty rows at the bottom of the worksheet.
empty columns to the left of column C.
empty rows at the top of the worksheet.
Question 11.11.(TCO 8) The ________ tab on the Page Setup dialog box provides options for printing comments.(Points : 2)
Page
Margins
Header/Footer
Sheet
Question 12.12.(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.(Points : 2)
Gmail
Hotmail
Yahoo
Outlook
Question 13.13.(TCO 8) Windows can search for files by author name or keywords that have been entered into ________.(Points : 2)
a file name
the Trust Center
document properties
cell A1
Question 14.14.(TCO 8) To join two or more text strings into one text string, you can use the ___________.(Points : 2)
Convert Text to Columns Wizard
Merge and Center command on the Home tab of the Ribbon
CONCATENATE function
Street Address
Question 15.15.(TCO 8) You can automate the deleting of duplicate rows from your spreadsheet by using the _________ on the Data tab of the Ribbon.(Points : 2)
Text to Columns command
Remove Duplicates command
Consolidate command
Group command