Devry BIS155 Week 4 Quiz Latest 2015 November
1. Question : (TCO 8) In a tab-delimited file, ________ separate the
data.
commas
tabs
spaces
hyphens
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) All of the following
will display data range properties EXCEPT:
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. Question
: (TCO 8) Text to Columns
command splits text in one column into separate ________.
columns
rows
worksheets
workbooks
Question 5. Question
: (TCO 8) Which of the following
is an example of a text string?
=B5*B7
=SUM(A5:A10)
=IF(B3>B4, B3)
John Doe
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
functions does not change the case or capitalization of text?
PROPER
CAPS
UPPER
LOWER
Question 8. Question
: (TCO 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. Question
: (TCO 8) 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. 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 ________ tab on
the Page Setup dialog box provides options for printing comments.
Page
Margins
Header/Footer
Sheet
Question 12. Question
: (TCO 8) An Excel file saved as
a .pdf does all the following EXCEPT:
preserves the formatting.
prevents editing.
prevents users from printing the file.
can be viewed on multiple computer systems
and platforms.
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) To join two or more
text strings into one text string, you can use the ___________.
Convert Text to Columns Wizard
Merge and Center command on the Home tab of
the Ribbon
CONCATENATE function
Street Address
Question 15. Question
: (TCO 8) You can automate the
deleting of duplicate rows from your spreadsheet by using the _________ on the
Data tab of the Ribbon.
Text to Columns command
Remove Duplicates command
Consolidate command
Group command
