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
Can you add 10000 sheet in Excel book?
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
It will depend on the amount of computer memory you have. That is what limits what you can add to your workbook.
What is the dictionary in Microsoft Excel used for?
It contains the words that the spell checker uses for checking for errors. You can add new words to the dictionary.
How to sort a list in Excel in Hindi alphabet order?
If your computer is set to recognise Hindi, then it is just a matter of selecting the data and sorting by the column you want to have your data sorted by. If your computer does not understand Hindi, but you do, then there is a way of doing it, though it is slow. You need to go through the list and when you find the item that is first in alphabetical order, put 1 in a column beside it. Find the next item and put 2 beside it in the same column as the 1. Continue doing this for all items. When all the items have a number, then select all the data first and sort on the column with the numbers, and your data should be in order. After sortting, just carefully check down through the list in case you made a mistake in your numbering and sort again if necessary. Ideally have the numbers in the first column, but even if they aren't, you can pick that column through the Advanced Sort option. If your computer is not set to Hindi and you do not understand Hindi and you can't find anyone that does, then you can't do it.
How do you decrease the size of an Excel file?
Remove anything that you are not using, like unused sheets. Do the same with any unused data. Things like pictures will greatly add to the size of a file, so remove any of those that are not necessary. You may not get a major reduction in size when you've done these things, but it should help a little. Older versions of Excel use less space for the same files, so you could save the file in an earlier format, by doing a Save As and picking an older version in Save As Type at the bottom of the dialog box. You can also zip a saved file to make it smaller.
In a spreadsheet you will have lots of figures. In the same way that you write numbers under each other to do calculations on paper, they can be arranged in columns on a spreadsheet. A spreadsheet will have lots of columns of numbers. It is important to know what the numbers in each column are for, so at the top of each column of numbers a heading should be put to make it clear what those numbers refer to. It could be things like Wages, Sales, Tax, Price and so on.
You will also have columns that have text in them, and they would also have headings on them. You might have a list of names and at the top have a heading identifying what the names are like Students, Staff, Managers, Salesperson or whatever. Without column headings spreadsheets would be a lot harder to understand, so they are very important.
Can EXCEL generate different permitations?
Using the Permut function, you can find out how many permutations can be got from a set of values. To actually generate the individual permutations you would need a program.
What appear between cells in a worksheet but they do not print if the worksheet is printed?
Gridlines
This is a statement, not a question. Please ask a question using words that indicate what you would like to know. This is a true statement and does not indicate if the author wants to know anything, but thank you for sharing what you know with the community.
What is a cell surrounded by a dark borded in Excel?
It could just be a cell with a border around it, or it could be the active cell, which is probably the answer you are looking for.
What is the purpose of these functions Max Min Count?
MAX gives you the highest value in a specified range. MIN gives you the lowest value in a specified range. COUNT will count how many values there are in a specified range, ignoring cells that do not have numbers in them. You could use them like this:
=MAX(A2:A20)
=MIN(A2:A20)
=COUNT(A2:A20)
How many rows and columns in Excel 2013?
There are virtually unlimited rows and columns in Microsoft Excel.
However, the finite amount of memory and the finite amount of processing power available define a natural boundary. This boundary varies from system to system, and cannot generally be expressed in numbers of rows and columns. Suffice to say that Microsoft Excel supports a very large number of rows and columns on a modern computer.
A surrounds the selected range to be copied?
A flashing dotted line, sometimes referred to as marching ants, surrounds the area being copied.
Why are text numbers considered constant values in Excel?
They are constants, because they do not change. If you type a value into a cell that value cannot change until something else is typed in. If you type a formula in, the formula will display a result. The result it shows can change when other things change in the worksheet. Any text or values typed directly into a formula won't change, but if cell references are used in the formulas then the values in those cells can change. For example, the formula =10+5 will always give 15 because 10 and 5 are constants, but the formula =A2+A3 can give a different result depending on what is in the cells A2 and A3.
How do write formula in Excel to check stock how many days stay in wherehouse?
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
If the day an item comes is and the day it goes out are recorded in two cells, you can subtract the first date from the second date. Then you would format the result as a number, as it will first appear as a date. So if the date the item came in was in cell A2 and the date it went out was in B2 then in another cell you would have the following formula:
=B2-A2
What is the importance of zooming in and out in viewing a spreadsheet?
Zoom in to see more detail about a particular section of the spreadsheet and zoom out to see the entire spreadsheet layout.
What symbol is used to specify calculation?
Use the equal sign (=) to identify cell entries that should attempt to calculate a value.
What is a a cool excel formula you know?
Put your date of birth in cell A1 as a date. Then in cell A2 type the following formula:
=weekday(A1)
You will get a number between 1 and 7, telling you what day of the week that you were born on.
1 is Sunday
2 is Monday
3 is Tuesday
4 is Wednesday
5 is Thursday
6 is Friday
7 is Saturday
You can put any date into A1 and it will give you the correct day in A2. Try today's date, by holding the Ctrl key and then pressing the ; key.
