0
Microsoft Excel
Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.
9,788 Questions
How do I paste text into Excel so each letter is in its own cell?
You can't copy one set of letters in one go from a single cell or other source and then do a paste that will put them into separate cells. There are more complex ways of doing it. You could paste all the letters into one cell and then use formulas to extract each letter individually to each cell. Text functions like MID can be good for that. Another approach, which is also slow and complex, is to have all the letters separated by commas in a text file, and then import the file into and Excel file and it will read the commas as breaks for each cell. Those are very long-winded methods and not really suited to what you probably want to do, which is probably a quick copy and paste like you do for other things. Unfortunately though, there is no simple fast way to do it.
Do you have to merge all the data in a data source?
No. There are various ways of merging some data only. It will depend on what you are doing, but you may want to just merge a certain number or ones that fit certain criteria. It is possible to do that.
What can you treat a range of data as a distintinct object in a Excel worksheet?
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
A range can be named and then it is simpler to treat it as a single object. It could also be a table, or a record or field in a database when you have one set up in Excel.
What is the difference between if and countif?
COUNTIF counts things that meet certain criteria. The IF function can help a spreadsheet to make decisions. See the related question below.
What is the most common files types imported into Excel?
Text files are commonly imported into Excel. You may also import multiple text files that are separated by a comma.
Worksheet called did you hear About?
if its the math worksheet im trying to figure out. lol sorry. i suck at math too.
In excel each sheet displays where at the bottom of the workbook?
This is a true statement, but not a question.
What functions are immediately available from the arrow next to the AutoSum button in excel?
Sum, Average, Count, Min and Max are the main ones. At the end there is a "More Functions..." option, which starts the regular function wizard so that you can do any function you want.
protect
This is a true statement, but not a question. Please ask again using words that indicate what you want to know.
The VLOOKUP function would be the best one to use. You need to set up a table with the name of the grade and the range of marks for that grade. You then compare each score against the range in the table and it will read off the apporpriate grade. Do some research on the VLOOKUP function and that will help.
When working in Excel you can only have one woorkbook opened at a time true or false?
False. You can have many workbooks open at the same time.
If you mean on the computer it is whether or not you have variations of the same colour on a Microsoft document
A printer that can handle a number of different image files formats
What is used to move the window to view the worksheet along with scroll arrows and scroll boxes?
You can use the page up (Pg Up), page down (Pg Dn), Arrow Keys, and Home keys on your keyboard.
If you mean not on the actual data points, then you could mean a legend. You could also attach a data table to the chart so that all of the data being used shows with the chart.
How do lawyers use Microsoft Excel?
There are a huge amount of ways they could use them. Like any business people, they could use them for doing some general accounts. They could use them to keep data on some of their clients. With some knowledge they could set up some sophisticated ways of managing their data. They could use them for managing data on other things, like the materials they use. Excel can be interlinked with other applications, so a lot of what they use the other applications for will be linked to Excel. So they could be writing letters to their clients and using data like prices of services that they may be providing or totals that they owe, or charts. They could use statistical analysis for cases they've won or types of cases they take.
Which features applies formatting attributes according to cell contents?
Conditional formatting can do this, and cells can also be pre-formatted so that when certain types of data are entered into them they will display in the format that you want.
What is the sum function for cells A-1 to B-1 in excel?
The proper way is:
=SUM(A1:B1)
Though you would hardly ever see any of them, it could also be done in these ways:
=SUM(A1,B1)
=SUM(A1+B1)
Why are the cells or range of cells being copied also called source area?
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
It is where the copy action is getting its data from, so it is the source of the data. So it can be referred to as the source area or the copy area.
What keys do you press to copy cell contents in Excel?
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
There are many possible combinations. Ctrl - C is the most obvious one. You can also use Alt - E - C. You can press the shortcut menu key and then press C. Ctrl - R and Ctrl - D can be used to do a copy like a fill, with Ctrl - R being for copy right and Ctrl - D being for copy down.
