User Account

All Pages

The most common file types imported into excel

Assignment Help Basic Computer Science
Reference no: EM13757185

Question 1. Which of the following is one of the most common file types imported into excel?
Text
Powerpoint
Web
Word

Question 2. Which of the following is not a text file?
Tab-delimited
Comma-separated value
Xml
Fixed-width

Question 3. 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. The convert text to columns wizard allows you to choose the file type, such as delimited or ________ width.

Fixed
Mixed
Divided
Text
Question 5. Which of the following is a frequently used function to manipulate txt?

Concatenate
Pmt
If
Date

Question 6. To change the text string jane doe to jane doe, use the ________ function.

concatenate
Proper
Upper
Lower

Question 7. Which of the following will produce the same result as the concatenate function?

=a4&b4
=a4+b4
=a4b4
=a4,b4

Question 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. The new comment command is located on the ________ tab.

View
Review
Data
File

Question 10. 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. The command to track changes is located on the ________ tab.

File
Data
Review
View

Question 12. 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. 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. All except ___________ are excel functions that help you manipulate text.

Proper
Upper
Substitute
Respond

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

Reference no: EM13757185

Questions Cloud

What ongoing training needs to be implemented : What ongoing training needs to be implemented and why. What training documentation should be kept and why
Good and bad technologies : Good and bad technologies-Some say that no technology is inherently good or evil, any technology can be used for good or evil purposes. Pick three of them and cite a good use and a bad use of the technology
Determine the exact weight of any number of coins : There are n stacks of n identical-looking coins. All ofthe coins in one of these stacks are counterfeit, while all the coins in the otherstacks are genuine. Every genuine coin weighs 10 grams; every fake weighs11 grams.
How stereotypes are portrayed very obviously in the media : How stereotypes are portrayed very obviously in the media, especially the entertainment media and other news.
The most common file types imported into excel : Which of the following is one of the most common file types imported into excel
What are the most important characteristics of markets : What is the efficient markets hypothesis and what are the most important characteristics of markets that are necessary for them to be efficient?
A summary of the information presented in the source : a summary of the information presented in the source and an analysis of the credibility of each source
Base erosion for multi-national corporations : A major issue related to base erosion for multi-national corporations is transfer pricing methods selected by companies.
Ethical consideration- who should be allowed to know : Ethical consideration: Who should be allowed to "know"? Consider that you work in the human resources management department of a local business and that many of your friends work there

Reviews

Write a Review

Basic Computer Science Questions & Answers

  For this case write down a 4-5 page explanation of the

for this case write a 4-5 page description of the steps businesses need to follow to create an online presence the

  Write fields to use as control break fields to make report

Write down fields that you want to use as control break fields to make a report which lists all inventory items in grocery store? Create a sample report.

  Recognize ten different areas where software helps

In spreadsheet, recognize at least 10 different areas where software could help you, like collecting rent, performing tenant background checks, and scheduling building maintenance.

  Designing a 24 cpu multiprocessor chip

designing a 24 CPU multiprocessor chip to compete with Intel PHI at a lower price point. Each core will run at 2 GHz and have a 32Kb L1 cache, 50ps access (per word), 8 word blocks, 4-way associative, write-through, 1% miss ratio There is a 6Mb L2 ca..

  Start by identifying all the hazards and potential causes

Start by identifying all the hazards and potential causes of harm to the IT infrastructure and functionality (for example, what are you going to do if the VIU main web site goes down, or what happens if viruses get into VIU computer systems, or..

  Eplain how have these trends challenged the health care

evaluate the impact of at least two major trends that occurred in the u.s. health care system during the twentieth

  Compute and display the average age

Create a Class StudentType Create a StudentType array of 50 students Set the age of the first student to 10, second student to 11, and so on until the last student to 59. Compute and display the average age of all 50 students with the help of a fu..

  Create three best practices for creating ppt

Create three best practices for creating a PowerPoint presentation.

  Assess an organisation information system

Journal task is to assess an Organisation Information System, and write a report. The assessment should focus on the various components of business systems

  Probability of exactly k collisions and then success

Large population of ALOHA users manage to create 50 requests/sec., including both originals and retransmissions. Time is slotted in units of 40 msec. Compute the probability of exactly K collisions and then a success?

  A 32 gb server to use as a virtualization hos

YOu have a 32 GB server to use as a virtualization host. You have thirty-two applicationservers that you plan to P2V to this host. Each application server is currently on aphysical server that has 4 GB of memory. The application servers all ru..

  Explain how they might be avoided

when is compaction of secondary storage beneficial from the file managers perspective? give several examples. list some problems that could be presented as a result of compaction and explain how they might be avoided.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd