answersLogoWhite

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 make a graph in Excel 2007 fill a whole sheet?

Sure. Just click on the graph, then click and drag on one of the edge handles (either a small box in each corner, or a double-headed arrow when you hover over one of the graph border lines). Repeat, as needed, to position the graph where you like.

Are Lesson plan and worksheet the same thing?

No. A lesson plan is an outline of what will happen during a lesson, covering things like what will be taught and covered during a lecture. A worksheet is a grid of columns and rows in a spreadsheet, or it could also be a set of exercises for students based on a lesson. A worksheet in a spreadsheet could be used to create a lesson plan, as it is good for setting out tabular data. A lesson plan could be created in other applications, like a word processor.

The save as dialog box appears every time you save a file?

The very first time you save, you will get the Save As dialog box. After that, as long as you use the Save option from the File menu, as opposed to the Save As option, you will not see the Save As dialog box again. You can also do it by pressing and holding the Ctrl key and pressing S, or by clicking on the icon on the toolbar. Only if you want to change the way you are saving it, like using a different name or a different location, do you need to use Save As again.

What is a quick method of copying and moving data a short distance with Excel?

Select the range containing the data you want to move. Point the mouse at the border of the selected area and drag it to its new location. If you want to leave the original in place and make a copy in the new location, hold down Control on the keyboard as you drag.

To move it a greater distance or onto a different worksheet use cut or copy. Press Control plus X on the keyboard to cut it or Control plus C to copy it.

Click in the first cell where you want it moved to and press Enter on the keyboard to paste it into place.

Which key enters data and makes te next cell in the column active?

Pressing the Return or Enter key, will move the cursor to the cell below the current one. You can actually change that in the settings to stay in the same cell or move up, left or right. Go to the Tools menu and then to Options and then to Edit and you will the option to change it there. The Tab key will move the cursor to the cell in the next column.

Why do accountants like to use the if function?

It enables them to make decisions in the spreadsheet, like working out the correct amount of tax to pay depending on the amount earned. Using an IF function that kind of thing can be done automatically, saving the accountant time. Check the related questions below.

Why does excel keep on making weird graphs?

If you are talking about the types of charts they offer, then all chart types have their particular uses. Some are specialised, like ones for monitoring prices on stocks and shares. Different people will know how to use the specialised ones, so they are provided. They may seem weird to some people, but others will know exactly what they are for.

If you are talking in terms of charts looking weird when you are trying to make them, then it is down to the data you are selecting to chart. Some of the charts need the right kind of data to work properly. There are different charts there, for different reasons. If you don't know how to use them properly then you may get charts that look odd.

What is done prior to beginning to create a chart?

You make sure all your data is correct and you have whatever headings you may need. You then select the data that you want in your chart, with the headings if necessary. You then start the Chart Wizard by clicking on its icon. Pressing the F11 key or pressing and hold the Alt key and the pressing F1, will create a chart immediately from the data. You can then make adjustments with it to change it to the way you want using the options in the Chart menu.

What is the width of the default column in Excel when it first starts?

64 pixels or 8.43 characters of the default font.

See related links.

What is the formula for average?

you add all the numbers and divide by how many numbers there are by the answer you get when tou add all the numbers

Who invented micsoft Excel?

I assume you mean "Microsoft Excel". Microsoft did, evolving out of the original Multiplan product. Refer to the wikipedia link here: http://en.wikipedia.org/wiki/Microsoft_Excel

If you mean who invented spreadsheets, the first spreadsheet I recall using that seemed to 'invent' a lot of the layout and functionality we see today was 'visicalc' (http://en.wikipedia.org/wiki/VisiCalc).It was certainly ahead of it's time and brought many business people into the personal computer world.

How to use a formula as criteria in sumif?

A short explanation of the question: Sometimes it is needed to use a formula as criteria instead of a given criteria. For example if you need to find the sum of numbers that are above or below the average in the range.

For both COUNTIF and SUMIF formulas, the way to use another formula for criteria is the following (pretext: range of numbers is A1:A15):

=countif(A1:A15;">"&average(A1:A15))

or

=sumif(A1:A15;">"&average(A1:A15);A1:A15)

And for the case that any number should be exactly the same as the average, use the "=" sign after the ">" or "<" sign.

What is a job costing spreadsheet?

It will contain the data need to work out the pricing of a piece of work to be done. To do any job there are costs involved. There would be things like how many people have to be paid, how much they get paid per hour, how many hours they worked, the materials need for the job, the amounts of them needed, the cost of them and so on. If you were doing something like decorating a room, you may need paint and wallpaper, furniture, all of which have to be costed. You would also want to work out how long the job will take to do and how much you will have to pay someone to do it. The people that do these kinds of jobs would need to work out these things too, in order to give you the price for the job.

What is the Primary benefit of a spreadsheet program?

A spreadsheet program is a great way to organize multiple layers of information all in one place. It can track expenses or personnel as well as anything else you need to keep track of. At one quick glance, you have your data laid out before you.

Calculate project end date in Excel 2003?

There is no simple answer to that, as it will depend on various factors. Each project is different. Without all of those factors, it is not possible to start to answer the question. It could be done in Excel, but a better application for managing a project is Microsoft Project.

What does average item revenue mean on Excel?

The revenue is how much is earned on each item. If you total up the revenue of all items and then divide by the amount of items there are, you will get the average revenue. You could use the Average function in Excel to do this.

Why left hand side is not used in calculation using Microsoft excell?

Because numbers are normally right-aligned, so that the units, tens, hundreds and so on are all underneath each other. If you have numbers that have different amounts of digits in them and left align them, then this won't happen.

When a excel worksheet is active its tab color displays as an?

Normally it appears white with black text. Tabs can also have colours set for them. When you click on a tab that has this done, a thin line of that colour will be on the bottom of the tab, with the rest of it being white.
The tab of an active worksheet is highlighted and the text is bold. It can display whatever color you choose. When you click on a tab that is colored it displays a color that faded from white at the top to the selected color at the bottom.
The title tab is highlighted in white.
As the page above the tab with a bold title.

If this does not answer your question. Please reword and ask again.

You have 2 columns in excel column A has a list of 10000 user ids column B has 1000 random user ids from column A how do you match the user id in column a with the user id in column b?

The simplest way to do this is to use the VLOOKUP function.

VLOOKUP($A1, $B$1:$B$1000, 1, 0)

This will look up the value of cell A1 in the range B1:B1000. If it is found, it will return the value of the first column in the range (in this case there is only one column in the range). If the value is not found, it will return #N/A.

You would need to use this function on every cell in the range A1:A10000 to see which ones match. I would insert a column before A:A and use the function there (just be sure to adjust your formula appropriately). Sorting will bring the matches to the top.

In Excel can you create a worksheet that will be able to make decisions based on the information that appears in other cells?

Yes you can do that. The main function to do that is the If function. See the link below for more information on it.

In excel what is the heading above the worksheet grid?

The letters in the heading above a worksheet grid are called column names.