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 do you press to complete a cell entry?
A number of keys can do it. The Enter key on the numeric keypad or the Return key on the main keypad will do it. The Tab key will do it. Any of the 4 arrow keys will do it. There are also a few special key combinations, such as Ctrl-Return to enter one value into multiple cells.
What on excel appears when you right click an object?
A shortcut menu, with items relevant to what you are doing at that time.
What other words can you use to describe excellent?
Brilliant, Bravo, that's all I know for right now
Why are Excel skills are important in the job market?
The need for Excel is very important to any business. It is used for matching and analyzing cost. Validating and maintaining item/cost information, analyzing cost variances for inventory. Auditing/processing invoices. Excel spreadsheet is used to store quantitative data and to perform accurate and rapid calculations with results ranging from simple budgets to financial analyses and statistical analyzes. Excel is part of a user interface which is the meeting point between computer software and the person using it and provides the means for a person to communicate with a software program. All businesses rely on some form of number system to keep track of merchandise, customer service surveys, stocks and employees. A system of accounting is used to keep records of employees, merchandise, materials, and all aspects that has to do with that business. The need for excel falls in the category of this need to keep the flow of the business. Since we are in the age of the computer the only use for paper is the backup system when the computers are down. This program is a more accurate way to keep up with the operation of any business.
When Excel is installed the default chart type for a PowerPoint slide is what chart?
A column chart.
A column chart.
A column chart.
A column chart.
A column chart.
A column chart.
A column chart.
A column chart.
A column chart.
A column chart.
A column chart.
What is a cell coordinate in Microsoft Excel?
The co-ordinate of a cell is given by its column and row. So its column is a coordinate and its row is a coordinate. So the cell in column D, row 15 has the address D15, with the coordinates D and 15.
How do you type numbers in a text?
If you have a keyboard, you hold down Fn while you push the number. If it is like a flip phone you just push the button with the number until you get past all the letters and to that number.
Yes. All functions in Excel have brackets and the ones that have arguments must have them within the brackets. Not all functions have arguments, but they still have to have the brackets. This distinguishes them for other things in Excel that have names. So it is possible to have a name called Average.
There is a button entitled "increase decimal". Its location depends on the version of Excel you are using.
First you must select the cell/s you wish to alter and then press the "increase decimal" button.
In Excel 2003 it is on the Formatting toolbar. It has the appearance of a small blue arrow, pointing left and is followed by a decimal point and single zero, overlying a decimal point and a double zero and looks roughly like the following:
↠.0
.00
In Excel 2007 the button can be found in the following location: On the Home tab, in the Number group.
Please see related links.
How can you make a worksheet show the actual formulas rather than the resulting values?
It's the same standard worksheet but just displayed differently. A quick way to toggle between the formulae displayed and the results (normal) view is to hold Ctrl and press the button with three symbols on it just below the Esc button.
Which chart is used to show the proportions of how one or more data elements relate to one other?
The right answer is "XY CHART", not Pie Chart, because when it comes to the fact, "one or more data elements are relate to another data element" can only be seen & proven in XY CHART ONLY.
What are the 4 main Ribbon tabs?
The four main ribbon tabs in Microsoft Office 2007 and 2010 are Home, Create, External Data, and Database Tools.
What does the equal sign signify in an Excel document?
All formulas in Excel must begin with an equals sign. If that is not done, it will not recognise formulas you are trying to put it and treat them as text. You can also use the equals sign to compare things. It will either give TRUE or FALSE depending on whether the values are equal or not. In the following, the first equals is used to start a formula and second one is used to compare the values in cells A2 and B2:
=A2=B2
What provides a visual cue about the value of a cell relative to other cells in excel?
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.
How do you insert multiple rows in Excel?
If you select more than one row and then insert, Excel inserts the amount of rows selected. So the first thing to do is to select 20 rows. Then you can insert rows and it will put in 20 new rows for you.
Which is the name of the feature used to resize a column to accommodate its widest entry?
On the Home menu bar on the right side click format, on the drop down menu click AUTOFIT column width.
How do you set a password in an Excel file?
In common with most other computer applications you need to know what the password is before you can remove it. This is to prevent unauthorised alterations.
Go to the Tool... Protection... Unprotect sheet menu and a dialog box will appear, in which you have to type the password.
You can google 'Excel Password Unlocker' and it will give you many options.
It wont give you your old password but make you change it so you can get in.
A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.
Can Microsoft Excel table be inserted into a Microsoft Word document?
If you are just talking about importing text then yes. On Microsoft Word you just highlight you text then copy it or (ctrl c) then you go to Microsoft Excel and paste it or (ctrl v). If that doesn't answer the question be more specific because that is how I interpreted your question.
What are the applications of MS Excel?
Excel can be used for almost anything where putting information in table format would be useful. Excel is somewhat limited in the way it handles text so if your project requires large volumes of text, MS Word would be a better option. However, if your project involves numbers (and especially if you want to perform calculations based on those numbers) Excel is a very powerful tool because of the built in mathematical functions. Excel can also be used for many other things. I have even used it to develop floor plans for a house.
A spreadsheet is often called a ........ when it is used to try out different scenerios?
i have found out that it is called a solver !:)
Why is it useful to create a macro on spreadsheet?
Macros come in handy when dealing with tasks such as a simple booking system for a stadium. For example, you may want to clear one section of the stadium or whatever you can press the macro and it automatically does it for you, so you don't ave to do it manually. You can also assign macros to other tasks in Excel so you don't get frustrated doing tasks manually.
