Get a unique, high-quality and non-plagiarized paper from us today at the most affordable price
Email us : premieredtutorials@gmail.com

most common file types imported into Excel

Question

(TCO 8) Which of the following is one of the most common file types imported into Excel?

 

Text

PowerPoint

Web

Word

 

 

 

 

 

Question 2. Question :

(TCO 8) Which of the following is NOT a text file?

 

Tab-delimited

Comma-separated value

XML

Fixed-width

 

 

 

 

Question 3. Question :

(TCO 8) Which of the following is NOT a method for refreshing data?

 

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. Question :

(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.

 

Fixed

Mixed

Divided

Text

 

 

 

 

 

Question 5. Question :

(TCO 8) Which of the following is a frequently used function to manipulate txt?

 

CONCATENATE

PMT

IF

DATE

 

 

 

 

 

Question 6. Question :

(TCO 8) To change the text string JANE doe to jane doe, use the ________ function.

 

: CONCATENATE

PROPER

UPPER

LOWER

 

 

 

 

 

Question 7. Question :

(TCO 8) Which of the following will produce the same result as the CONCATENATE function?

 

=A4&B4

=A4+B4

=A4B4

=A4,B4

 

 

 

 

 

Question 8. Question :

(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge.

 

Type New List

Use Existing List

Import from Excel

Select from Outlook Contacts

 

 

 

 

 

 

Question 9. Question :

(TCO 8) The New Comment command is located on the ________ tab.

 

View

Review

Data

File

 

 

 

 

 

Question 10. Question :

(TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________.

 

Split Names Wizard

PivotTable feature

CONCATENATE function

Convert Text to Columns Wizard

 

 

 

 

 

 

Question 11. Question :

(TCO 8) The command to track changes is located on the ________ tab.

 

File

Data

Review

View

 

 

 

 

Question 12. Question :

(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.

 

Gmail

Hotmail

Yahoo

Outlook

 

 

 

 

 

 

Question 13. Question :

(TCO 8) Windows can search for files by author name or keywords that have been entered into ________.

 

a file name

the Trust Center

document properties

cell A1

 

 

 

 

 

Question 14. Question :

(TCO 8) All EXCEPT ___________ are Excel functions that help you manipulate text.

 

PROPER

UPPER

SUBSTITUTE

RESPOND

 

 

 

 

 

Question 15. Question :

(TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password.

 

Check for Issues

Protect Workbook

Manage Versions

Options

 

Do you want your assignment written by the best essay experts? Order now, for an amazing discount.

How to Place an Order 

Send the assignment details such as the instructions, due date/deadline, number of pages and college level to the customer support agent online on live chat,  fill in the assignment details at place an order or send the information to our email address premieredtutorials@gmail.com and a customer support agent will respond to you immediately. 

Once you place your order, we choose for you the best and competent writer for your assignment based on each writer’s competence in handling a subject. 

When the homework is completed, we have a quality assurance team that proofreads the assignment to ensure it meets the required rubric instructions from your professor.

After thorough review of your assignment, we send the paper to the client. In case you need any changes at this point, you can let us know so that we can handle it for you at no extra charge. 

Homework Help Website

Why we should write your Paper 

  1. Money Return guarantee
  2. 0% Plagiarism Rate
  3. Guaranteed Privacy
  4. Written from scratch by highly qualified writers 
  5. Communication at Any Time (24/7)
  6. Flexible Pricing and Great Discount Programs
  7. Timely Deliveries
  8. Free Amendments
Looking for a similar assignment and in urgent need for help? Place your order and have excellent work written by our team of professionals to ensure you acquire the best grades.

  We are here to assist you.

 

Statistics about Us

130 New Projects
235 Projects in Progress
315 Inquiries
420 Repeat clients

© 2021 Premiered Tutorials
All rights reserved. We provide online custom written papers, such as term papers, research papers, thesis papers, essays, dissertations and other custom writing services.

All papers inclusive of research material are strictly intended to be used for research and study purposes only. Premiered Tutorials does not support or condone plagiarism in any form. These custom papers should be used with proper reference.

Place an Order
error: Content is protected !!