2 little problems

[Bormans Erwin]

Hello, i must teach some lessons of excel and i get some questions that i
don't know the answer, so maybe you can help me.

1) When you select a row or a kolom and want to change the height or width,
with me the standard value's are 12,75 and 8,43 but i don't know what it is.
Is it milimeters, centimeters (but that's not possible), pixels, ...

2) When you enter 3 numerical value's, leave then one row open and then you
put there a function to count them up, it works just fine. But when you
enter a fourth numerical value it automatic recalculated and takes the fouth
value with: for example
A1 100
A2 200
A3 300
A4
A5 = SOM(A1:A3)

Is this an option or is this always like that, i use MS Excel 2000 SP-3. And
i think that excel has no right to do that so i want it to be undone. Is
this possible?

I'm sorry for my bad englisch, but i still hope you understand me!

Kind regards Erwin

Erwin Bormans
Docent Aron
www.aron.be
(e-mail address removed)

 

[Paul Falla]

Dear Erwin,

Hopefully I can help answer your queries

1) The height of a cell is measured in points (the same as
fonts)ie 1 point is one 16th of an inch if I remember
correctly.

with regard to your second query, the reason excel changes
the formular to include the cell you had as a blank then
put a value into, is that excel assumes that if you have
put a value in that cell, you must want it included in
your calculation, otherwise why would you put the value in
there in the first place? If there is a reason that you do
not want the extra number included, then put a quotation
mark in front of the number (eg '400 )

I hopes this helps, and good luck with your teaching

Paul Falla

 

[Bormans Erwin]

Thanks for the quick reply!!

And yes your answer helps

But maybe i can help you also a little bit with my second query, it is an
option that you can uncheck, so that he doesn't do it anymore. The reason
herefore is that when you have users that are half asleep and they enter
wrong information into wrong cells, he does not calculated something wrong.

If you want to uncheck it just go to Tools, Options, Edit,
Extend Data Range Format and Formulas.

Kind regards Erwin

 

[Ed]

A "point" is 1/72-inch -that is, a letter or a row 72 points high would be 1
inch tall.

If you enter your SUM formula with absolute cell references (as in
=SUM(A$1:A$3) ), Excel will not change the formula to include anything else
you put in the middle.

HTH
Ed