Microsoft Excel

Sounds like you might have a keybord with multiple functions. Look on the K key to see if the number 2 is printed on the front. If so, figure out what key you need to press to toggle between letters an numberpad (you can try the Num Lock key).

The best thing is to copy it to another workbook and e-mail that one. You can either copy the data to a new sheet, or copy the entire sheet to another workbook. Then you could delete the other worksheets in the new workbook and save and e-mail the workbook.

Empty cells are ignored completely when calculating an average in Excel. If a cell contains a zero, then it is included in the calculation of the average because zero is a number and it is relevant to include it. If you want to exclude zero values in the calculation, then you could use the AVERAGEIF and set it to only include values that are above zero.

Yes, it does this as its default action.

=A1

This for example is a very simple function, if put in cell C1; this will make that cells value equal to that of A1.

If you were to copy, or drag this cell down, the row number would automatically increment (Or decrement if you were to it in reverse).

If you were to copy, or drag this cell across, the column letter would automatically increment (Or decrement if you were to it in reverse).

=$A1

Would prevent the Column from incrementing or decrementing

=A$1

Would prevent the Row from incrementing or decrementing

=$A$1

Would prevent both the Row and Column from incrementing or decrementing, forcing the cell reference to stay the same regardless of where it was copied.

Rows are a horizontal arrangement of cells. All rows are numbered. The amount of rows depend on the version of Excel you have. Versions of Excel from 2007 have 1,048,576 rows. Before that, there was 65,536 rows.

A lot of the things work in the same way in each application, like formatting. If you know these common elements then you can work faster and have less to learn when you start using the other applications. Your knowledge of one will help when using another. You can then concentrate on learning the things that are unique to each application.

Any kind of software or anything to do with computers is related to computer science. With Excel, there are a huge range of things that relate to computer science. It has functions and formulas and programming through VBA. The amount of rows and columns is related to binary, which is fundamental to computing. The amount of them are all powers of 2. If you keep doubling up from 2, you will eventually come to the number 256, which was the amount of columns in versions of Excel up to 2003. That is 2 to the power of 8. It had 65,536 columns, which is 2 to the power of 16. That is now the amount of columns in versions 2007 onwards. It has 1,048,576 rows, which is 2 to the power of 20. There are so many other things that relate to computer science, that it is impossible to list them all.

Macros and the Control Toolbox are completely different. Macros are for writing code to do automated tasks. The control toolbox has the controls you can put on your worksheet and forms, like buttons, drop down lists, text boxes, labels etc. You can assign a macro to a control, like having a button run a macro when it is clicked.

When the word art button is clicked in Microsoft Word, the different types of font opens up. The list will include a visual of all word art fonts.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.

Any action specified, through something like an IF function or Conditional Formatting, will happen.

You can hide all the worksheets in the workbook. A workbook can have as many worksheets as your computer's memory will allow, so there is no set maximum.

The Average function. For example, to get the mean of the cells from A2 to A15, you would use it this way:

=AVERAGE(A2:A15)

Text and graphics can be entered into a footer.

Yes. There are 3 main functions for doing lookups. They are LOOKUP, VLOOKUP and HLOOKUP. You can also use a combination of the MATCH and INDEX functions to achieve a lookup.

First I'd like to keep track of my income my monthly income secondly I'd like to keep track of expenses via holding onto receipts and putting them in my spreadsheet so that I can follow my expenses versus my income and not go over

You have to use the Split Screen option, which will allow you to split the window into four areas. You will find it on the View tab.

Columns go up and down, try to think of the White House and how it has the Roman like pillar.

Rows go across the page like this -------, why don't you try to think of the horizon of the sun. For example, if your at the beach looking out across the water you see a horizontal line, that is called a row.

See if that helps you. That is how I think of rows and columns

I am not sure of options within ADABAS to export data directly to excel.

But using a programing language (eg: Natural) mainframe ADABAS data can be read and then ConnectDirected to excel.

Please revert in case of any details qureies

Backspace?

First, open the relevant worksheet. Right click on the sheet tab and select the "Select all sheets" option. Input your titles on the first sheet and these will then be applied to every sheet. Don't forget to save the work!

No. Rows are identified by numbers in a spreadsheet. Columns are identified by letters.

Ctrl and the ` key will show or hide formulas. The `is the apostrophe key, not the single quote key.

The easiest way is to press Ctrl - Home. You could also click on A1 using the mouse, or using the arrow keys, move the cursor to A1. You could also press the F5 key and use the Goto command to go to A1. You could also type A1 in the Name Box.