DEVRY BIS 155 Week 4 Quiz Data Analysis with Spreadsheets with Lab
Check this A+ tutorial guideline at
For more classes visit
(TCO 8) In a tab-delimited file, ________ separate the data. (Points : 2)
(TCO 8) The ________ group on the Data tab contains tools to help you manage your external data connections. (Points : 2)
Get External Data
(TCO 8) Which of the following is an example of a text string? (Points : 2)
(TCO 8) To change the text string JANE doe to jane doe, use the ________ function. (Points : 2)
(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 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)
Show All Properties
(TCO 8) In Excel, the...