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

What is the shortcut key to insert current date in a cell?

Hold down the Ctrl key and press they key with the ; on it. If you do the same while also holding the shift key down, you will get the current time. If you enter the formula below into a cell it will put in the current date:

=TODAY()

What is it called when you organize a spreadsheet alphabetically?

Sorting.

Sorting.

Sorting.

Sorting.

Sorting.

Sorting.

Sorting.

Sorting.

Sorting.

Sorting.

Sorting.

How do you edit the contents of the active cell in Excel?

  1. Select the cell you want to change.
  2. Right-click and choose format cell.
  3. Make the changes you want.

What is a set of formatting attributes that you can apply as a group to a selected cell or range of cells?

A style.

A style.

A style.

A style.

A style.

A style.

A style.

A style.

A style.

A style.

A style.

What is a sum in Excel?

SUM() is a function within Excel which adds up the values of the cells that are passed to it. You can pass individual cells, a list of cells or a range of cells. e.g.

=SUM(A1) returns the same value as the cell A1
=SUM(A1,B2) return the sum of A1 + B2
=SUM(A1:B2) returns the sum of the range A1:B2

Ranges are effective squares of cells, so the range A1:B2 is a small 2x2 square consisting of A1, A2, B1 and B2.

How can a worksheet have maximum number of rows?

Worksheets have to have a limit on the amount of rows you have. A computer only has a limited amount of memory, so it cannot be infinite. The vast majority of spreadsheets will not come anywhere close to using them, so you have more than enough. While you can insert extra rows, the amount of rows stay the same and the bottom row is pushed off the spreadsheet. The same applies to the final column. As no data is likely to be there or anywhere near the last row or column, there is no problem in pushing them off. Up to Excel 2003 there were 65536 rows and 256 columns. From versions 2007 on there are 1048576 rows and 16384 columns as modern systems do tend to have more data than the earlier versions were capable of dealing with.

In excel 2007 what is the menu off of a right arrow?

When you right-click, you will get a sub-menu appropriate for the context on which you clicked.

How do you merge multiple spreadsheets in Microsoft Excel?

In the destination spreadsheet (the one that you'd like values/formulae to be brought in to) select the cell that will receive the link, hit the "=" button, go to the origin spreadsheet and select the cell that you're linking to, and finally hit the "Enter" key. An alternative to this approach is to go to the origin spreadsheet, highlight and copy the cells you'd like to link to the destination spreadsheet, go to the destination spreadsheet and paste special link cells.

Why do we learn Microsoft excel?

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

If you mean why do we use it when there are more recent versions, it is because it still does the most common things we need to do with a spreadsheet. There are fundamental things that all spreadsheets do, right back to the earliest ones. Most things we do on a spreadsheet still consist of those fundamentals. Newer versions of spreadsheets have added more functionality, changed the layout and interface, but for the vast majority of things we do with a spreadsheet you could do them on a very old spreadsheet. If you mean what does a spreadsheet do that makes us want to use it, then look at the related questions below.

The box where the row and a column intersect is called a cell?

Yes, that is correct. Where a row and column intersect, you get a cell. It is then identified by the column and row. So the cell where column C meets row 14 would be C14 for example.

What is a text that you want printed at the bottom of a page?

Text at the bottom of all the pages is called the "footer"

At the top of the page it is called "header"

These can be identical on all pages or first page different or different on even and odd pages.

Which formula can add the all the numeric values in a range of cells ignoring those which are not numeric and place the resulting a difference cell?

The alphanumeric values will already be ignored during a calculation in Excel sheet. So, any formula works. For example, if you got to take out the sum of cells A1 to F1, write =SUM(A1:F1).

How do you close an excel workbook without exiting excel?

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

Go to the File menu and pick Close. You could also click the X in the top right corner, just below the X for the application. You could also press and hold Ctrl and then press W.

How do you get Excel to atuomatically display a number as currency or percent?

You format the cells to currency and then when numbers are put into them, they will automatically display as currency. to format a selected range of cells in Excel, press the Ctrl-1 key combination. This will bring up a dialog box. Click on the Number tab, then choose "Currency". Choose from a large range of symbols for the particular currency you want. The click OK.

When you enter data into a form where does it go?

In Microsoft Excel, the data stays in the cell where it was entered. If that cell is referenced by an external source, it will also be copied to that external source. The location cannot be determined from Excel, only from the external source.

What is trace precedents in Excel?

Precedents are the cells that a formula uses. Say you have the following formula in a cell:

=A2+C12-D10

Then the cells A2, C12 and D10 are the precedents of the formula. The formula is using values that are in them. You use Trace Precedents to find those cells and highlight them on the Spreadsheet. If you are having a problem with formulas you can highlight the cells to be able to see which ones are being used. One way of doing it is to select the cell and then press the CTRL key and also the [ key. You can also use the Auditing toolbar to do it.

What happen if a hyperlink is incapable of showing a file?

You see an error message: Unable to openhttp://whatever... The Internet site reports that the item you requested could not be found. (HTTP/1.0 404)

What is print area in Excel?

It is a part of a document that has been selected in order to be printed. On a spreadsheet there may be a section of the sheet that a user wants to print, so they select it and make it the print area. When they go to print, just that section will be printed.

Which feature on Excel show me how a fill color wiill look before you apply it?

Live Preview will show you how a fill color will look before it is applied.

If you were working with two computer applications or programs for example Word and Excel at the same time how would you switch from one to the other?

Use the Alt-Tab key combination, which switches between open applications. You could also click the particular application on the taskbar.