PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

Share a file Manage my documents Convert Recover PDF Search Help Contact



DEVRY BIS 155 Week 4 Quiz Data Anal .pdf



Original filename: DEVRY BIS 155 Week 4 Quiz Data Anal.pdf
Author: LENOVO

This PDF 1.5 document has been generated by Microsoft® Office Word 2007, and has been sent on pdf-archive.com on 02/03/2017 at 12:21, from IP address 43.224.x.x. The current document download page has been viewed 211 times.
File size: 340 KB (9 pages).
Privacy: public file




Download original PDF file









Document preview


DEVRY BIS 155 Week 4 Quiz Data Analysis
with Spreadsheets with Lab

Check this A+ tutorial guideline at
http://www.assignmentcloud.com/bis155/bis-155-week-4-quiz-data-analysiswith-spreadsheets-with-lab
For more classes visit

http://www.assignmentcloud.com
(TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2)
Commas
Tabs
Spaces
Hyphens
(TCO 8) The ________ group on the Data tab contains tools to help you manage your
external data connections. (Points : 2)
Get External Data
Data Tools
Analysis

Connections
(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
(TCO 8) To change the text string JANE doe to jane doe, use the ________ function.
(Points : 2)
CONCATENATE
PROPER
UPPER
LOWER
(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? (Points : 2)
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.
(TCO 8) An alternative method for inserting a comment in a cell includes: (Points : 2)
typing the comment into the cell and then clicking New Comment.
right-click the cell and choose Insert Comment.
left-click the cell and choose Insert Comment.
clicking paste on the Home tab after typing in the comment.
(TCO 8) An Excel file saved as a .pdf does all the following EXCEPT: (Points : 2)
preserves the formatting.

prevents editing.
prevents users from printing the file.
can be viewed on multiple computer systems and platforms.
(TCO 8) To display the Properties dialog box, click ________ in the Info section of the
Backstage view and select Advanced Properties. (Points : 2)
Properties
Show All Properties
Permissions
Versions
(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
(TCO 8) Which of the following is NOT a text file? (Points : 2)
Tab-delimited
Comma-separated value
XML
Fixed-width
(TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2)
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.

(TCO 8) The Text to Columns command is found on the ________ tab. (Points : 2)
File
Data
Insert
Page Layout
(TCO 8) To change the text string jOHn dOE to John Doe, use the ________ function.
(Points : 2)
CONCATENATE
PROPER
UPPER
LOWER
(TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function.
(Points : 2)
UPPER
LOWER
PROPER
CONCATENATE
(TCO 8) Which of the following functions does not change the case or capitalization
of text? (Points : 2)
PROPER
CAPS
UPPER
LOWER
(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
(TCO 8) The New Comment command is located on the ________ tab. (Points : 2)
View
Review
Data
File
(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.
(TCO 8) The command to track changes is located on the ________ tab. (Points : 2)
File
Data
Review
View
(TCO 8) The command to send an Excel workbook by e-mail is located on the ________
tab. (Points : 2)
File
Home

Insert
View
(TCO 8) The ________ command displays additional document properties such as
Company. (Points : 2)
Options
Permissions
Show Fewer Properties
Show All Properties
(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
(TCO 8) To encrypt a workbook with a password, click Info on the File tab, click
________, and then select Encrypt with Password. (Points : 2)
Check for Issues
Protect Workbook
Manage Versions
Options
(TCO 8) Which of the following is one of the most common file types imported into
Excel?
Text
PowerPoint
Web

Word
(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such
as Delimited or ________ width.
Fixed
Mixed
Divided
Text
(TCO 8) Which of the following is a frequently used function to manipulate txt?
CONCATENATE
PMT
IF
DATE
(TCO 8) To change the text string JANE doe to jane doe, use the ________ function.
CONCATENATE
PROPER
UPPER
LOWER
(TCO 8) Which of the following will produce the same result as the CONCATENATE
function?
=A4&B4
=A4+B4
=A4B4
=A4,B4

(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you
already have the customers’ names and addresses stored in an Excel file, you should
choose _________ from the Select Recipients menu while performing the merge.
Type New List
Use Existing List
Import from Excel
Select from Outlook Contacts
(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
(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel
file directly from Excel.
Gmail
Hotmail
Yahoo
Outlook
(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
(TCO 8) All EXCEPT ___________ are Excel functions that help you manipulate text.

PROPER
UPPER
SUBSTITUTE
RESPOND


Related documents


PDF Document devry bis 155 week 4 quiz data anal
PDF Document devry bis 155 week 5 quiz data ana
PDF Document excel
PDF Document devry bis 155 week 1 quiz data a
PDF Document excelb
PDF Document how to print multiple excel1148


Related keywords