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.