Keywords

bis 155
bis 155 week 5
bis 155 week 4
bis 155 week 3
bis 155 week 2
bis 155 week 1
bis 155 free
bis 155 course project
devry bis 155 final exam
bis 155 final exam
bis 155 exercise
bis 155 ilabs
devry bis 155
bis 155 devry
bis 155 entire course
bis 155 week 6


Authorizations, license

Visible by: Everyone
All rights reserved

4 visits

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


DEVRY BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab This doc cannot be viewed.

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

Check this A+ tutorial guideline at

www.assignmentclick.com/bis-155/bis-155-week-4-quiz-data-analysis-with-spreadsheets-with-lab

For more classes visit
www.assignmentclick.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

Comments