Question 1. 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) To create a connection between the original data source and the imported data in Excel, use the _____ on the Data tab.
Data Validation command
Connection command
Edit Links command
Commands in the Get External Data group
Question 3. Question : (TCO 8) All of the following will display data range properties EXCEPT
click Properties in the Connections Group.
click Edit Links.
click Refresh All arrow and select Connection Properties.
click Connections then click Properties.
Question 4. Question : (TCO 8) Text to Columns command splits text in one column into separate _____.
columns
rows
worksheets
workbooks
Question 5. Question : (TCO 8) Which of the following is an example of a text string?
=B5*B7
=SUM(A5:A10)
=IF(B3>B4, B3)
John Doe
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 cannot be used in a CONCATENATE function?
Text
Numbers
Multiple-cell references
Single-cell references
Question 8. Question : (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _____ tab of the Ribbon.
Merge
Mailings
Home
Review
Question 9. Question : (TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs?
Review tab
Data tab
File tab
None of the above
Question 10. Question : (TCO 8) An alternative method for inserting a comment in a cell includes
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. Question : (TCO 8) The _____ tab on the Page Setup dialog box provides options for printing comments.
Page
Margins
Header/Footer
Sheet
Question 12. Question : (TCO 8) The command to send an Excel workbook by e-mail is located on the _____ tab.
File, Share
Home, Send
File, Options
View, Email
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
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need an answer to this or any other questions?
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will
direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
