Chat with us, powered by LiveChat DeVry Chicago BIS 155 Week 4 Quiz 2014 - Uni Pal

DeVry Chicago BIS 155 Week 4
Quiz 2014

1.Question :(TCO 8) In a tab-delimited file, ________ separate the
data.

Student Answer: commas

tabs

spaces

hyphens

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

Student Answer: Access database

XML

CSV

txt

Question 3.Question :(TCO 8) Which of the following is NOT a method for
refreshing data?

Student Answer: 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.

Student Answer: Fixed

Mixed

Divided

Text

Question 5.Question :(TCO 8) Which of the following is a frequently used
function to manipulate txt?

Student Answer: CONCATENATE

PMT

IF

DATE

Question 6.Question :(TCO 8) To change the text string Jack Doe to JACK
DOE, use the ________ function.

Student Answer: UPPER

LOWER

PROPER

CONCATENATE

Question 7.Question :(TCO 8) Which of the following will produce the
same result as the CONCATENATE function?

Student Answer: =A4&B4

=A4+B4

=A4B4

=A4,B4

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?

Student Answer: 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?

Student Answer: 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 ________.

Student Answer: Split Names Wizard

PivotTable feature

CONCATENATE function

Convert Text to Columns Wizard

Question 11.Question :(TCO 8) The ________ command displays all comments
in the entire workbook.

Student Answer: Track Changes

Show Ink

Show/Hide Comment

Show All Comments

Question 12.Question :(TCO 8) If you have ________ configured as your
e-mail client, you can e-mail an Excel file directly from Excel.

Student Answer: Gmail

Hotmail

Yahoo

Outlook

Question 13.Question :(TCO 8) To display the Properties dialog box,
click ________ in the Info section of the Backstage view and select Advanced
Properties.

Student Answer: Properties

Show All Properties

Permissions

Versions

Question 14.Question :(TCO 8) Which function is similar to the Find and
Replace feature?

Student Answer: CONCATENATE

SUBSTITUTE

UPPER

PROPER

Question
15.Question :(TCO 8) You can identify duplicate rows in a table using the
_________.

error: Content is protected !!