Microsoft Excel

You can not use the keyboard to drag in Excel, but you can use cut and paste. Go to the starting cell and press Crtl-X to cut, then use the arrow keys to move to the cell where you would like to move the contents of the first cell and press Crtl-V.

I'm not sure why one would want to name a whole column, when the column is already 'named' by its letter/s, but

Select the column, and enter the desired name in the text-box in the Formula Bar.

When you have typed the name, press the enter key, or it will not retain the name.

1. Put your cursor on the row below where you would like to freeze the title row.
2. Select the View tab.
3. In the Window section, click on the Freeze Panesdrop-down menu.
4. Select the freeze option you want: both row and column, rows, or columns.

That depends on what way you use it. You can use it for dates and have the date increase by a year each time, so each successive cell would have the same day and month, but increase the year by one. You can also get it to increase by more than one, using the Series facility, so each date jumps by several years. You can also get the date to increase by a smaller amount, like a day, which may not change the year at all. So the Fill can be very flexible allowing you to determine what way it deals with dates and the year in those dates, meaning there is no definitive answer to your question.

If you make two or more cells into one cell, that is called merging the cells.

They can be very useful in working with Powerpoint. You can use them to jump to other slides, to jump to other slide shows, to jump to other documents, to jump to websites etc. You can attach them to buttons or text.

=B16 would be a relative reference

=$B$16 would be an absolute reference.

you can also highlight the cell reference and press F4 to add the "$" signs around the reference.

At the bottom of the open sheet are a series of tabs that say "Sheet 1", "Sheet 2", "Sheet 3", etc. Right click on the one you want to change and a pop-up menu will show up. One of the options in the pop-up menu is Rename - click on this and the phrase "Sheet 1" will change to a data entry field. Once you have finished typing in the new name, hit enter and the name will be fixed on the tab.

Without seeing your exact spreadsheet, it is not possible to be specific, but you would generally be making use of the SUM function to total up your individual revenues.

home, insert, page layout, reference, mailings, review, view

You can manipulate data in many ways with a spreadsheet like Excel. Mainly it is done using formulas and functions. You can also use some of the databasing capabilities, like Filters, to do it, or you could use Pivot Tables to help you analyse the same data in different ways. There are many other built in ways of doing it, like sorting, goal seeking, solvers, scenarios, macros, formatting, validating and many other things. There is a huge amount that can be done with spreadsheets, so there are all sorts of ways of manipulating data using them.

In the Name Box, which is at the left end of the Formula Bar.
In the Name Box, which is at the left end of the Formula Bar.

A row (numbers) and a column (letters) intersect at a cell. Example: A1, is the first cell in the top left-hand corner of a spreadsheet.

Hard Copy

page break

For Excel 2007, it is the button that looks like a paint can tipped over. You will find it on the Home tab in the Font section.

Another option is on the Home tab in the Cells section, under the Format option (Format Cells | Fill).

While holding down the CTRL key, press HOME once ... Voila, back to cell A1. or Press F5 and then type A1 or any cell name like c1, c12, b2 etc... You can go to which cell you want in this way.

They can be called a Range or a Block. This is only if it is a single selection of a rectangular block of cells. It is possible to select cells that are not together, known as being non-contiguous, but this is not a range or block.

what is the difference between relative and absolute location?

It could be the relationship that lets absolute memory relate to anything whiles relative memory is specific. When you remember something and its absolute then it means you can remember by any means so you have trained the brain to remember it by any means while relative memory is related by place or dimension. There is also such a thing as partial memory!

A Chart.

It is a at the top next to the the Bold B. It will be a U with a line under it.

It is used in specifying text in a function, and sometimes dates. It differentiates names for ranges and actual text. Functions use different kinds of data, such as numbers, dates, logical values and text. Text is indicated by enclosing it in quotation marks, and dates can be indicated that way too. See the following examples:

=FIND("A", C30)

=WEEKDAY("2/5/90")

If you had a range named Sales you could do this with Excel to sum the range, but you would not use the quotations marks to specify it, otherwise it would not work, as it would treat it as text. Assuming you did have a ranged named Sales, then the first of these two is correct and second will not work:

=SUM(Sales)

=SUM("Sales")

Because it is a faster and simpler way or referencing a group of cells. You could use the individual cells like this to sum them:

=A2+A3+A4+A5+A6+A7+A8+A9+A10

Using a range reference you could do it like this:

=SUM(A2:A10)