Microsoft Excel

They are all applications software.

If you add a number to a date it will take it as being an amount of days and give you a new date that is that amount of days after the first date. So if you had today's date in cell B2 and wanted to see what date it is in 60 days from now, in any other cell you could type the following formula:

=B2+60

It is the "Format" that is applied to that cell's contents. Go to Excel Help and type "Format." There are lots of things including numbers which can be formatted. Numbers are in red if they are negative or greater or less than a limit.

The formula will become:

=B5+B6

What the actual total it shows will be, will depend on what is in B5 and B6.

Use the Backspace key. It usually is labeled as Backspace or has an arrow pointing to the left. On most keyboard layouts, you will find the key above the Enter key in the right corner of the top row of keys (just below the function keys).

A bubble is a circle on a bubble chart. It is a type of chart in Excel, similar to an XY chart. They can be complicated to create and understand, as you need 3 series of data to do so. The can be used for analysis of statistics, so it helps to have some statistical knowledge and to know when it is appropriate to use a bubble chart. For most Excel users, it is a chart that is not used very often.

Pressing the spacebar by itself does not do anything special in Excel, except enter a space. In conjunction with other keys, it does a lot more. Ctrl-Spacebar selects and column and Shift-Spacebar selects a row for example

It is used to store any templates you may create. Templates are predefined structures of files with their layouts and formatting all done. Even when you open a new blank worksheet, it is a template, having cells set to certain widths and having them certain colours and with certain font settings. You can create more complex templates for types of document that you may regularly use instead of having to design them from a blank format each time. Templates you create will then be stored in the template folder.

profit-and-loss statement

Microsoft

Yes, you can do that. If you have a series of columns, you can highlight all of the column to select the range. When you click on the auto-sum button, Excel will insert =SUM(XX:XX) at the bottom of each column in the range.

Dependents are the cells that are used by formulas in other cells. Say you have the following formula in a cell B3:

=A2+C12-D10

Then the cells A2, C12 and D10 are the dependents of the formula in B3. The formula is using values that are in them. If you go to any of those cells, you use can use Trace Dependents to find the cells that depend on them 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.

Excel is an application numerical analysis and manipulation. With it you can create spreadsheets. There are many things you can do with it. See the related questions below.

That will depend on what exactly you mean. If you have totals for numbers in column A and also for column B and wanted to know the difference, you would subtract one from the other. So if your total for figures in column A was in cell A20 and those for column B were in cell B20, then you could have a formula in your spreadsheet, maybe in cell B22, to find the difference like this:

=B20-A20

If you then had totals for column C and for column D and so on, you would have a corresponding formula each time, like:

=C20-B20

=D20-C20

=E20-D20

To get those you could just copy the first formula across into each column. A similar formula would be used if it was for individual values rather than totals that you were checking differences for. So if you wanted to get the difference between A2 and B2, then in C2 you could have the formula:

=B2-A2

That formula could be copied down to get the corresponding differences for the other cells.

Sometimes these formulas will give you positive values, but sometimes you will get negatives, indicating the change is a downward one. So if one total was 20 and the next was 16, then the difference would be -4 when you do your calculation. If you are not concerned with whether it is higher or lower, but just the amount of the difference, so in this case all you would want is to know that the difference was 4, then you could use the ABS function around the formula that was getting the difference. ABS gives you the absolute value, ignoring whether it is positive or negative. So taking the last formula shown, you would have something like this:

=ABS(B2-A2)

That will give you 4.

The correct answer is: the remainder of the worksheet, including notes and embedded charts

It is called a spreadsheet.

Ionic columns. These were made by the ancient Greeks to decorate their temples and tombs. These columns were by far the most royal of the time. - question answered by Kerrigan Pruett. info gotten from book.

The Range Finder feature is enabled when a user creates a new formula or edits an existing formula. The Range Finder gives users better visual feedback for moving and resizing the Range Finder range. You can see the ranges included in the formula are highlighted by different color border lines.

You can display formulas by using the keyboard Shortcut CTRL + ` in Excel. (The ` Grave Accent key is below the ESC Key on the upper left side of most keyboards.)

Change the formula to use absolute references instead of relative references. Instead of =A2+B3, use =$A$2+$B$3.

cut with scissors until it get to the size you want

It fills cells to the right of the current cell, when you have selected some to copy something into. So if you select a cell and some cells to the right of it, what is in the first cell can be copied into the others, using the fill right facility.

TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom ends of a data set. You can use this function when you wish to exclude outlying data from your analysis.

=TRIMMEAN(array, percent)

Array is the array or range of values to trim and average.

Percent is the fractional number of data points to exclude from the calculation. For example, if percent = 0.2, 4 points are trimmed from a data set of 20 points (20 x 0.2): 2 from the top and 2 from the bottom of the set. It does not matter what order your values are entered in. It will remove some of the highest and some of the lowest.