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
In excel 2013 where are the various function categories stored on the Ribbon?
In Excel Where are the various function categories stored on the Ribbon?
How much rows does worksheet contains?
A Microsoft Excel 97 through Excel 2003 worksheet contains 65,536 rows. A Microsoft Excel 2007 workbook saved in one of the new formats (.xlsx, .xlsm) has worksheets with 1,048,576 rows.
what-if analysis or sensitivity analysis
Its What-if Analysis
What is the default alignment of cells contents in a table?
Normally, default alignment for text is left. Default alignment for numbers is right. The alignment depends on the template you use to build your table.
There are different ways you could do it. You could use the Scenario Manager to store an initial set of values that you can restore. You could use the Undo command. You could save the file just before you make you changes and then go back to the saved version when you are finished.
What is an excel window area that displays the value contained in an active cell?
The cell address (or name) window is above the worksheet (usually below the menu bar). When you click on a cell, you will see either the cell address (e.g. A3) or cell name (e.g. Total; if you assigned a cell name).
Which button should you click if you want to print formula in a worksheet?
In Excel 2007:
- Click on the Formulas ribbon tab.
- In the Formula Auditing section, click Show Formulas. This will display formulas instead of calculated results.
- Print the spreadsheet as you normally would.
- When done evaluating for formulas, do not forget to turn the Show Forumulas off.
In Excel 2003 or earlier:
- From the Tools menu, select Formula Auditing and click on Formula Auditing Mode.This will display formulas instead of calculated results.
- Print the spreadsheet as you normally would.
- When done evaluating for formulas, do not forget to turn the Show Forumulas off.
control-~
will display formulas
then you can print them
control-~ toggles back to values
If you press and hold the Ctrl key and then press the `key, all formulas will be shown in cells instead of the values. You can also achieve this by going to the Tools menu and picking Options. From there go to the View tab and put a tick beside formulas. When printing, there is a option to print formulas instead of the values.
In Excel 2007: From the Formula tab on the menu ribbon, in the Formula Auditing section, click on Show Formulas. That will display the formulas instead of the results in each row that has a formula. Then, you just print as you normally would. Remember to turn Show Formulas off when you want to go back to showing the results of the formulas instead the forumulas themselves.
On the Formulas bar, in the Formula Auditing section, click on Show Formulas to toggle formula view on and off. When the formula view is turned on, you will print formulas in the cells when you print the document. When the formula view is turned off, you will print values in the cells when you print the document.
Is there much of a difference between Microsoft Excel 2010 and 2013?
There is not much difference. Some older things have been retired, like different chart types, for example cones. The ribbon's look and animations have had small changes. There are some other cosmetic changes you will notice when you use it. They have done things to improve the use of Fill, Charts and Pivot Tables. It is really a case of Office that has been upgraded, so there are only a small amount of changes in any of the individual applications, rather than major changes in each.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
You can use the Ctrl - Y key combination, or you can use the F4 key.
What are 3 things you can put in a cell using Microsoft Excel?
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
Any kind of value, such as text, numbers, dates or TRUE and FALSE values. Most commonly it is numbers.
What indicates which workbook cells are included in a formula calculation?
The name of the workbook will be enclosed in square brackets, indicating it is another workbook.
How do you make text in a cell in excel occupy more than just one line?
Use the Wrap Text command in Format, Cells dialog. If you want to break the text in a specific place, put your cursor at that point and press Alt+Enter.
What is a field in a database that contains formulas or functions in Excel?
In a database a field with a formula is called a calculated field. A calculated field should actually be in a table, as it can be calculated from data in other fields in the table, so it normally only appears in queries, reports and forms. In a spreadsheet it would just be a calculation.
When you select text the toolbar?
that's not even a complete question stated like that it makes no sense, but I believe I found the entire question you were trying to ask and the answer is mini or miniature
What is general format in Excel?
Data can take different formats. For example, numbers can be displayed with or without decimal points or as currency or percentage and other formats. Dates can be shown with just numbers or with words for the month and the day, or showing month, then day or day, then month. So all of these things are formatting. There are many data types and they can be formatted in different ways to suit what the user of the spreadsheet wants.
The IF function is useful when you want to assign a value to a cell based on a logical test.?
The IF function is exactly what you need to assign a value based on a logical test, as in:
=IF(A1>5,"Greater","Less" than or equals to")
This will result in a cell whose value is the string "Greater" if A1 contains a value greater than 5 and "Less than or equals to" if it is not greater than 5. You can also put numbers or even formulas in the values to assign.
It is changing the contents of the cell, like changing a formula or putting a new value in it. You can start editing by clicking on the content in the formula bar or pressing the F2 key.
Cell editing is making any changes to the contents of the cell whether the contents is text, data (numbers) or a formula. Double click on a cell and you can edit it in the cell instead of on the formula bar.
What does the underlined letters in Microsoft Excel under the menus mean?
They show you keys that you can use to activate those menus and items on menus. Pressing and holding the Alt key and then the F key will open the file menu. Pressing X then, would select the Exit option and close Excel. Alt activates the menu bar. You can use these keys to do things quickly. Alt - E - C is Alt, Edit menu, Copy option. So the underlined letter is the letter you type to select that particular option.
Where you can change margin settings and page?
Page Layout tab,Page setup section in word,excel 2007/2010
make sure you select the Preferred check box for each merchant's ESI record
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
Autofit is the facility in Excel to widen out a column to fit the widest entry in the column so that it is visible in full.
What is a model in spreadsheets?
A Spreadsheet Model is a document created in a spreadsheet program (like Microsoft Excel) which is supposed to simulate a real life situation. For example a spreadsheet model might be used to help plan a school disco. It would show how much everything costs and help you to decide how much you need to sell tickets for to cover your costs.
Spreadsheet models are often used in business to help with planning, accounting and forecasting.
