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

If you have clicked 'no' by mistake to save changes to and Excel document can you still retrieve this file?

That depends on the specific situation. If the document has been previously saved, you will have the file up to the point it was last saved, but without any of the new changes in it. If it is auto-saving you may have some more. If it is a brand new document that was never saved before, then you will have lost everything. If there was an error in Excel as you were working on it, you might get a recovered document, but if you just said you did not want to save it, as you've indicated in your question, then that won't happen.

As a general rule, if you are working on a big document, save it every so often, even before it is finished, so that if you do something like you did by hitting "No" you will have at least got some work back. Make sure the Auto save is on, by going into the Tools menu and then Options and then in the Save tab, you can turn on autosaving. That will help recover a document if there is an error in Excel, so you won't have lost everything.

What is a PEA chart?

I was not able to find any reference to a PEA chart related to MS Excel. Please check what you are trying to ask and provide more detail in your question to give a point of reference. Or, perhaps you need to ask the question using a different spelling (perhaps PIE?).

What column shows the sum as each new line of data is entered?

The sum total will not appear by default, unless you add the formula for it. If you are adding data just down 1 column, it is a good idea to place your sum formula at the top of the next column. That way you are not always moving your formula from row to row when you add new data to the column.

How do you do the max Word formila on Microsoft exel 2007?

You enclose the values or range inside the brackets, as in the following example. If you wanted to find the highest number in the range from A2 to A20, you would do it as follows:

=MAX(A2:A20)

What does destination cell mean?

It is the target cell where you want to put data. This term usually is used when talking about copying data from a source cell to a destination cell.

How can you draw a perfect circle in Excel?

You cannot. Excel can only work in approximations. You would ned an infinite number of cells to generate a perfect circle.

Does Microsoft Excel Apply to you?

Microsoft Excel can be used by anyone. It is a very versatile application with many uses, so anybody can make use of it, from business people to a child.

Where can you find a labeled diagram of Microsoft Excel on the Internet?

See related links for diagrams showing parts of the Excel screen for both Excel 2003 and Excel 2007.

What are the alignment in Microsoft Excel and where can they be found?

The main ones are left, right, center and justify. Go to the Format Cells dialog box, by pressing Ctrl - 1 and you can get to the Alignment settings from there.

What is the excel formula for a Z test?

Excel has a ZTEST function. It has the format ZTEST(array, µ0, sigma).

What is the hot key to close Microsoft Excel?

Alt - F4 is the main one, though you can also use Alt - F - X.

What is an embedded worksheet?

It is a worksheet built into another worksheet.

Can you term any spread sheet as excel sheet?

No. Excel is Microsoft's main spreadsheet application. It is the best selling and most widest used, but it is not the only one and it was not the first one. VisiCalc was the first one, launched in 1979, and others followed before Excel launched in 1985. So not all spreadsheets can be called Excel sheets. VisiCalc was the first one, launched in 1979, and others followed before Excel launched in 1985. Many others have come along since then.

When is the beginning of time in Excel?

In terms of dates, computers usually start dates for the 1st of January 1900. This is the way it works in Excel. For times, it starts at 00:00.

How are cell ranges identified?

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:

A3:B16

C10:C40

D12:K56

H13:N13

Which chart is created by default using the chart wizard?

It is normally a column chart. The default can be changed to whatever the user wants.

Total number of column in Microsoft Excel?

The total number of columns in versions of Excel up to Excel 2003 is 256 columns.

The total number of columns in Microsoft Excel 2007 and onwards is 16384.

The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.

Use of Microsoft Excel to a manager?

for working out budgets or any complex data which can be presented by rows and columns eg monthly expenses,sales

What does a new worksheet icon looks like in Excel?

There is a specific icon for a new workbook, which is a whole new file, but not a worksheet. To add a worksheet to the existing workbook, go to the Insert menu and choose Worksheet.

How do you enter more than one value into a cell on Microsoft Excel?

You can type whatever you like in a cell, but a cell has only one value to use for calculations. You can use a single cell to combine values of other cells, like =SUM(A1:A4), but the cell itself would have only a single value. If this does not answer your question, please ask another more specific question.

What is Office theme in Excel?

Themes change the overall design of the entire document, including colors, fonts, and effects. The default themes that come with Excel 2007 are:

Office

Apex

Aspect

Civic

Concorse

Equity

Flow

Foundary

Median

Metro

Module

Opulant

Oreal

Origin

Paper

Solice

Technic

Trek

Urban

Verve