View the step-by-step solution to: 1. (TCO 8) Which of the following is one of the most common file

This question was answered on May 25, 2012. View the Answer
1. (TCO 8) Which of the following is one of the most common file types imported into Excel? (Points : 2)
Text
PowerPoint
Web
Word

2. (TCO 8) The Text Import Wizard displays when a(n) ________ file is imported. (Points : 2)
Access database
XML
CSV
txt

3. (TCO 8) The ________ group on the Data tab contains tools to help you manage your external data connections. (Points : 2)
Get External Data
Data Tools
Analysis
Connections

4. (TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width. (Points : 2)
Fixed
Mixed
Divided
Text

5. (TCO 8) To change the text string jOHn dOE to John Doe, use the ________ function. (Points : 2)
CONCATENATE
PROPER
UPPER
LOWER

6. (TCO 8) To change the word college to university in a string of text, use the ________ function. (Points : 2)
SUBSTITUTE
PROPER
CONCATENATE
LOWER

7. (TCO 8) Which of the following cannot be used in a CONCATENATE function? (Points : 2)
Text
Numbers
Multiple-cell references
Single-cell references

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

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

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.

11. (TCO 8) The ________ tab on the Page Setup dialog box provides options for printing comments. (Points : 2)
Page
Margins
Header/Footer
Sheet

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.

13. (TCO 8) Windows can search for files by author name or keywords that have been entered into ________. (Points : 2)
a file name
the Trust Center
document properties
cell A1

14. (TCO 8) All EXCEPT ___________ are Excel functions that help you manipulate text. (Points : 2)
PROPER
UPPER
SUBSTITUTE
RESPOND

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
Sign up to view the entire interaction

We can only answer your free 3 questions one at a time. You have two options to get your questions answered:... View the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • 890,990,898

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • 890,990,898

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards