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
What is the F10 function key in Excel?
The F10 key in Excel activates the menus. It does the same as pressing the Alt key by itself. In older versions of Excel, up to Excel 2003, menus were used and the Alt or F10 key activated the menu bar. They both work in versions of Excel from 2007 onwards to activate key tips, so that you can use keyboard combinations for certain activities that would have been on the menus on older versions. You can also use F10 with other keys. SHIFT+F10 displays the shortcut menu for a selected item. ALT+SHIFT+F10 displays the menu or message for an Error Checking button. CTRL+F10 maximizes or restores the selected workbook window.
How far down does the sheet go in excel?
This made me laugh!!
I got to zxx and i gave up, but it probably never ends they just make combinations of letters (or numbers depending on which way you're going.
Double click on a column, and it will automatically make the column wide enough to fit the longest entry.
Do function formulas have operators?
They can have operators. It depends on the formula or function in question. There are lots of kinds of operators that can be used like the mathematical ones, operators for comparisons and boolean operators.
The power of Excel are its functions and which enable accurate and quick calculations?
As long as the formulas are done correctly, then yes it the will give faster and accurate calculations. If there is an error in a formula then you may get an incorrect result. Generally though, having a spreadsheet enables you to do lots of calculations and quickly see the changes that happen when you adjust figures.
What is the difference between widows and orphans as used in word processing?
widows means a lady whose husband has died.orphan means a parentless child.
Can you put fifteen digits in excel?
Yes
you can enter a number as text in which case you can enter I believe up to 256 digits.
or you can enter 15 single digits numbers into 15 different cells
or you can enter a single 15 digit number in a single cell (this is the physical limit set by the software on how many digits a number can be allowed to have) though it will most likely be displayed in scientific notation unless you format it differently.
How do you freeze the top row of the current worksheet?
In Excel 2003 and earlier, place your cursor in row 2 and click on Freeze Panes. The Freeze Pains command will freeze the rows above the cursor. Excel 2007 offers an option to freeze top row no matter where your cursor is located.
Comparison between a word processor and a spreadsheet?
MS Word is a word processor. MS Excel is a spreadsheet. They are two different types of applications.
They are both software packages. Microsoft "Word" is a Word Processor programme for TYPING letters, documents etc.
Microsoft "Excel" is a spreadsheet programme. Spreadsheets are laid out in a graph format and their main usage is for auto calculations of columns of numbers.
What is an example of syntax in Excel?
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
Syntax is the structure of a command or its rules that must be followed in order for it to work. For Excel formulas and functions often have to be written in a particular way. Many functions require that you have some data in them, and if you do, it often has to be of a particular type and entered in a particular order. You may need commas in certain places to separate the different parts. All functions have brackets and there must be an opening and closing bracket for each function, so it they were left out or even one is left out, it is breaking the rules of syntax and the function will not work. So for example, the following function will not work because there must be a cell reference after the colon and there is no closing bracket:
=SUM(A3:
What are two things that you can do in Word that cannot be done in Excel?
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
Count the words in the document. Add footnotes and endnotes.
uncategorized
What are the disadvantage of using formula in excel instead of using cell reference?
Using a formula which does not reference any cells means that the result is fixed, as the values are fixed. The result will only change if the formula is changed. Using cell references allows you to have a formula using variables. If the data changes then the result of the formula changes. The question is a little odd however because it is almost certain you will want to, and are able to, use both; cell references within formulas.
What is definition of folder in Excel 2007 Sorry for caps?
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
A folder is an area on a computer for storing files of any type. That can be for Excel 2007 files or any type you want. Normally we create folders to organises files, having different folders for different kinds of files or files that are in some way related. That makes them easier to find.
Where can one access online an interactive currency chart?
Interactive currency charts are available from websites about money news and the stock market. These charts allow users to track the strength of currencies against each other over time. Places to try include Bloomberg and MarketWatch.
It is acceptable for dates to have a currency format?
It is acceptable for dates to have a currency format
How do you calculate IRR in Excel?
Use the IRR function in Excel. You need an array of values, of which at least one must be negative and one positive. You also have the option of a Guess value. It is a specialised financial function, so if you don't fully understand its use, the Excel Help facility has some assistance and there are many other sources of help too.
How do you open non native files in Excel?
First, when you go to open a file, you can the File Of Type option and you can choose other kinds of files that Excel can open. If you set it to All Files, you will be able to choose from a wider range of files, but Excel may not be able to open them.
Yes, you can set ranges using validation options in Excel.
You can create spreadsheets or tables.
For example when you need to do your accounting, tax returns or so.
1. Used for data analysis as it has financial and statistical function. 2. Storing data in systematic way. Like one Excel file for each day. 3. Making invoices, timesheet, Trackers etc. 4. Creating charts for presentation which further can be moved to presentation software like Power Point 5. Used for cleaning data like removing duplicate reports, filtering out specific records etc
Microsoft Excel is used for organising data and presenting it. It is also used to calculate budgets and finances. It is often used by Businesses.
You can expand the range of data to include a row of cells you didn't originally select
You can specify that the table includes headers
Is Microsoft Excel is used for completing result?
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
That depends on what you mean by completing results, but there are many ways that could be done in Excel.
