Bis 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab

BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab
To Buy This material Click below link
http://www.uoptutors.com/bis-155/bis-155-week-4-quiz-data-analysis-with-spreadsheets-with-lab
(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 :...