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 can you exit footer in excel?
Page Layout
Print Layout
Header/Footers
Fill in what you want in the Footers box and center/format as desired.
A blinking vertical line that indicates where the next character typed will display?
Insertion point
cursor
Can you add a word in the dictionary in Microsoft Excel?
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
Yes you can add a word to the dictionary in Microsoft Excel.
What cell reference instructs excel to adjust the reference as it copies it to the destination area?
Cell references in a formula don't change if they are moved. Relative references will change if they are copied. Mixed references may change, depending on the type of mixed reference and which direction they are copied.
How many cells are there in a single Excel sheet?
In the Excel spreadsheet versions prior to 2002 or Office XP there are 65,536 rows and 256 columns , 65,536 x 256 = 16,777,216 cells or 'boxes'. Later versions of Excel have far more - millions of rows and thousands of columns. EDIT The latest version of Microsoft Excel that comes with Office 2007 has 17,179,869,184 cells in all. The columns are letter all the way to XFD and there are 1,048,576 rows.
How do you make an excel graph with a logarithmic scale?
first make your graph with all the points and then once you've done that and you have your graph... double click on one of the scale values on either the x or y axis, look for the 'scale' tab and check the box 'logarithmic scale'....hope it helps
The above is incorrect. There is no option for log scale on the x axis. The data will have to be provided in in logarithmic scale for the x axis to depict it as such.
Which of the sentences below would go in the problem concept column of an everything I know chart?
How can I fix my car?
How do you add 2 percent to 11.00 in Microsoft Excel using a formula?
If you mean to increase their values by 2%, there are a few ways. You could have a column beside it with a formula to increase the value, by multiplying each corresponding value by 1.02 in each cell. So if the first value was in cell A2, then in cell B2 you could have the following formula:
=A2 * 1.02
If you wanted to still only have one column of figures, rather than two, then that might not be perfect. There are two things you could do using the facilities in Paste Special. You could copy all of the figures in the second column and then use the Values option in Paste Special to paste them over the original set. You could then remove the second column altogether.
Another approach without even using a formula or a second column can be taken using Paste Special. Type 1.02 into a cell. Then copy it and then select your column of figures. Then using Paste Special, in the Operation section choose Multiply and then click OK. The values will now all have been multiplied by 1.02 and you will still have just one column.
What is use of word art in MS-Office?
It is how you can create funky writing instead of boring normal writing. In other words fancy lettering with 3D effects, shadows, curved paths etc.
See the link below: How to insert and modify WordArt at Microsoft Help
How do you highlight all the cells in a worksheet in Excel?
Click on the Select All button. It is in the top corner of the spreadsheet, above the 1 for row 1 and to the left of the A for column A, and is a blank button. Clicking on that will select the entire worksheet.
How do you find out days and month calculation in Excel?
Arithmetic works with dates and displays the results as days, so just multiply the result times 24 to get the approximate number of hours between the dates (Excel default format for dates assumes each day has a full 24 hours). If your oldest date is in A1 and your most recent date is in A2, use the following formula to calculate hours between the two dates: =(A2-A1)*24.
If you need to show exact hours between specific times for two dates, just format A1 and A2 to display both date and time (a standard option under cell format for dates SAMPLE: 1/1/09 12:00 AM).
What are the similarities of Microsoft Word PowerPoint and Excel?
They can all make graphs,and show things that you can't by hand. They have a lot of the same formatting capabilities for text in particular. They can all create tables and do things with them. Many of the same options on the ribbon and tabs are the same. Each has their own particular job, but there is a lot that can be done by them all. They can also be integrated, like creating a worksheet in Excel and copying it into a Word document or Powerpoint slide.
What program would you use to create a worksheet?
A couple of options are Microsoft Excel or Open Office Calc (open-source free software).
What does currency in Microsoft Excel mean?
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
It would be used to show values for money in whatever currency you were working in if doing something financial. So if you were doing something like investments or wages or sales, you would be using a currency. Excel provides lots of currency symbols, as it is used all over the world. The same spreadsheet could even have several currencies in it, if it was doing currency conversions. The Currency format is slightly different to the Accounting format, which puts the currency symbol to the left of the cell, whereas Currency puts it right beside the value.
Why is it important to save data in a spreadsheet?
If you don't save it, you will lose it. That could mean the loss of a huge amount of work and having to repeat it. Saving data can also be useful when doing a similar spreadsheet, in that you can use an old one that you have saved and make adjustments to it, rather than doing one all over again. It is also useful when you have formulas created that you want to use again. If you know they work on a spreadsheet you can save them and use them again. This is very commonly done as a lot of spreadsheets are repetitive, like having one to work out monthly totals. The actual results will be different each month, but the way it is calculated would be the same, so you can use the same formulas. So there are lots of reasons for saving spreadsheets.
What are sub headings used for?
Headings and subheadings are ways of showing your reader how your information is organized. They let your reader know what will be discussed in each section of a document, such as a contract.
How do you quiting in Microsoft Excel?
RANDY THE DINOSAUR RAWR You can quit in Microsoft excel either gracefully or not, by: 1) Choosing the option Exit under menu File, 2) Clicking the box with X at the right most portion of the excel screen, 3) Pressing alt+ctrl+del, 4) Pressing alt+f4, and 5) Shutting your computer directly but the data or updates made will be lost.
What features of Microsoft Excel are used for decision making?
Directly you can use functions like If, Lookup, Vlookup and Hlookup. Indirectly you can use the data available and forecasting of what is likely to happen to influence decisions. Excel has many ways of enabling you to do that. There are many specialised financial functions. There are graphs. You can also produce trends, both on graphs and in numbers. You have tools like the Scenario Manager which allows you to experiment with different possibilities and see how they compare to each other. These are just some of the things you can do. A spreadsheet like Excel is a very powerful application and with the correct knowledge it can be used to help making decisions in all sorts of ways beyond those already mentioned.
Text data is just words type into cells. On any spreadsheet you will have lots of numbers. In order to know what the numbers actually mean, you'll have lots of headings in cells. So you could have a cell with the heading "Total" beside a total of some set of figures. Maybe the months of the year or days of the week, or the names of products you are selling are needed. You could have a list of names of people or places in a spreadsheet. So while there is mostly numbers in spreadsheets, there is also lots of text data too.
How do you delete an embedded chart?
Click on it so that it is completely selected and then press the Delete key.
When might you use the sum function at school or workplace?
You use SUM any time you want to find the sum of a range of numbers. For example, you might want to find the total hours you worked during the week by finding the sum of the hours you worked each day in the week.
How do you you import a csv file into Excel?
Version 2003 and Prior: 1. Select from dropdown: Data; Import External Data; Import Data… 2. Navigate and select the file to import (make sure "Files of type:" is listed as "All Data Sources"), 3. On the prompt that comes up leave "Delimited" selected and hit Next, 4. On "Delimiters" select "Comma", 5. Finish Version 2007: 1. From Ribbon: Data, Get External Data, From Text, 2. Navigate and select the file to import (make sure "Files of type:" is listed as "All Data Sources"), 3. On the prompt that comes up leave "Delimited" selected and hit Next, 4. On "Delimiters" select "Comma", 5. Finish
What symbol do you use in a spreadsheet when you automatically want to add numbers?
There are two (2) ways to add up automatically in MS Excel. You can either use the syntax, =sum(number1, number2, number3,...numberX), or select the cells (containing set of numbers) and click the summation symbol.
When you look at a worksheet in Excel you can see all the cells, because of the lines around them. Those are gridlines. You can also add borders, to make heavier lines around cells. Gridlines can be turned off completely, by going to the Options menu and the View section and removing the tick beside Gridlines.
