1. (TCO 8) Which of the following is one of the most common file types imported

Question

1. (TCO 8) Which of the following is one of the most common file types imported into Excel? (Points : 2)        Text
       PowerPoint
       Web
       Word Question 2.2. (TCO 8) To create a connection between the original data source and the imported data in Excel, use the _____ on the Data tab. (Points : 2)        Data Validation command
       Connection command
       Edit Links command
       Commands in the Get External Data group Question 3.3. (TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2)        Click the Refresh All command.
       Save the Excel workbook.
       Click the Refresh All arrow, then click Refresh.
       Right-click in a range of data and then select Refresh. Question 4.4. (TCO 8) The Text to Columns Wizard allows you to choose the file type, such as Delimited or _____ width. (Points : 2)        Fixed
       Mixed
       Divided
       Text Question 5.5. (TCO 8) To change the text string jOHn dOE to John Doe, use the _____ function. (Points : 2)        CONCATENATE
       PROPER
       UPPER
       LOWER Question 6.6. (TCO 8) To change the word college to university in a string of text, use the _____ function. (Points : 2)        SUBSTITUTE
       PROPER
       CONCATENATE
       LOWER Question 7.7. (TCO 8) Which of the following functions does not change the case or capitalization of text? (Points : 2)        PROPER
       CAPS
       UPPER
       LOWER Question 8.8. (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _____ tab of the Ribbon. (Points : 2)        Merge
       Mailings
       Home
       Review Question 9.9. (TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs? (Points : 2)        Review tab
       Data tab
       File tab
       None of the above Question 10.10. (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. Question 11.11. (TCO 8) The command to track changes is located on the _____ tab. (Points : 2)        File
       Data
       Review
       View Question 12.12. (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. Question 13.13. (TCO 8) The _____ command displays additional document properties such as Company. (Points : 2)        Options
       Permissions
       Show Fewer Properties
       Show All Properties Question 14.14. (TCO 8) All EXCEPT _____ are Excel functions that help you manipulate text. (Points : 2)        PROPER
       UPPER
       SUBSTITUTE
       RESPOND Question 15.15. (TCO 8) You can automate the deleting of duplicate rows from your spreadsheet by using the _____ on the Data tab of the Ribbon. (Points : 2)        Text to Columns command
       Remove Duplicates command
       Consolidate command
       Group command 1. (TCO 8) Which of the following is one of the most common file types imported into Excel? (Points : 2)        Text
       PowerPoint
       Web
       Word

Explanation / Answer

1.text

2.data validation command

3.save the excel workbook

4.fixed

5.CONCATENATE

6.substitute

7.proper

8.merge

9.File tab

10.right-click the cell and choose insert comment

11.review tab

12.prevents editing

13.show all properties

14.respond

15.remove duplicate commands

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.