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 .