Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) Which of the following is one of the most common file types imported into Excel?\tText\tPowerPoint\tWeb\tWord\t\u00a0\tQuestion 2. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) To create a connection between the original data source and the imported data in Excel, use the _____ on the Data tab.\tData Validation command\tConnection command\tEdit Links command\tCommands in the Get External Data group\t\u00a0\tQuestion 3. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) All of the following will display data range properties EXCEPT\tclick Properties in the Connections Group.\tclick Edit Links.\tclick Refresh All arrow and select Connection Properties.\tclick Connections then click Properties.\t\u00a0\tQuestion 4. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) Text to Columns command splits text in one column into separate _____.\tcolumns\trows\tworksheets\tworkbooks\t\u00a0\tQuestion 5. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) Which of the following is an example of a text string?\t=B5*B7\t=SUM(A5:A10)\t=IF(B3>B4, B3)\tJohn Doe\t\u00a0\tQuestion 6. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) To change the text string JANE doe to jane doe, use the _____ function.\tCONCATENATE\tPROPER\tUPPER\tLOWER\t\u00a0\tQuestion 7. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) Which of the following cannot be used in a CONCATENATE function?\tText\tNumbers\tMultiple-cell references\tSingle-cell references\t\u00a0\tQuestion 8. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _____ tab of the Ribbon.\tMerge\tMailings\tHome\tReview\t\u00a0\tQuestion 9. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs?\tReview tab\tData tab\tFile tab\tNone of the above\t\u00a0\tQuestion 10.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 8) An alternative method for inserting a comment in a cell includes\ttyping the comment into the cell and then clicking New Comment.\tright-click the cell and choose Insert Comment.\tleft-click the cell and choose Insert Comment.\tclicking paste on the Home tab after typing in the comment.\t\u00a0\tQuestion 11.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 8) The _____ tab on the Page Setup dialog box provides options for printing comments.\tPage\tMargins\tHeader\/Footer\tSheet\t\u00a0\tQuestion 12.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 8) The command to send an Excel workbook by e-mail is located on the _____ tab.\tFile, Share\tHome, Send\tFile, Options\tView, Email\t\u00a0\tQuestion 13.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 8) Windows can search for files by author name or keywords that have been entered into _____.\ta file name\tthe Trust Center\tdocument properties\tcell A1\t\u00a0\tQuestion 14.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 8) All EXCEPT _____ are Excel functions that help you manipulate text.\tPROPER\tUPPER\tSUBSTITUTE\tRESPOND\t\u00a0\tQuestion 15.\u00a0\u00a0\u00a0 Question : \ufffd\u00a0\u00a0 (TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password.\tCheck for Issues\tProtect Workbook\tManage Versions\tOptions<\/p>\n","protected":false},"excerpt":{"rendered":"
Question 1. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) Which of the following is one of the most common file types imported into Excel? Text PowerPoint Web Word \u00a0 Question 2. \ufffd Question : \ufffd\u00a0\u00a0 (TCO 8) To create a connection Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-202969","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=202969"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/202969\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=202969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=202969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=202969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}