Suggest the Calc functions that can be used for carrying out following operations :

(i) To calculate total marks of a student if his marks in five subjects are given in five different cells.

(ii) To calculate average sales made by salesman of a company, if sales made by each of the salesmen is available.

(iii) To find out the marks of top scorer in a class, if marks of all the students are available.

(iv) To find out minimum quoted rate from various quotations available.

What are the rules to be followed while entering the following in OOo Calc ?

(i) numbers

(ii) text

(iii) formulas

Differentiate between mixed referencing and absolute referencing by giving suitable examples.

What is the difference between copying and moving a range ?