310-610 Free Dumps Study Materials
Question 10: If you enable the entry Tools > Options > Openoffice.Org 3 Calc > General > Expand references when
new columns / rows are inserted. Which of the following statements is true?
A. If you insert a new entry to a column of values, a formula referencing this column (e.g., sum(A1:A4) )
will expand the reference (e.g. sum(A1:A5) )
B. If you insert a new row to the column of values, a formula referencing this column (e.g., sum(A1:A4) )
will expand the reference (e.g. sum(A1:A5) ) automatically
C. If you insert a new row to the column of values, a formula referencing this column (e.g., sum(A1:A4) )
will not expand the reference (e.g. sum(A1:A5) ) automatically, you have to do it by hand.
D. If you insert a new row to the column of values, a formula referencing this column (e.g., sum(A1:A4) )
will not be changed, this option takes only effect on styles.
Correct Answer: E