Computer Applications
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.
Related Questions
State whether the following statements are true or false :
(i) When you increase the font size, the row height is automatically adjusted.
(ii) By default, the numbers are left aligned and text values are right aligned.
Write cell references for the following :
(i) Cell formed by intersection of row 18, and column Z.
(ii) The right most cell in row 32 in a worksheet.
(iii) If you select an entire worksheet, which range of cells gets selected.
(iv) Reference (Fixed Column and Relative row) formed by row 134 and column BD.
(v) Mixed Reference (Relative column and Fixed row) formed by row 120 and column IA
(vi) Absolute Reference formed by 45 and column Z.
(vii) Relative Reference formed by row 19 and column AB.
What are the rules to be followed while entering the following in OOo Calc ?
(i) numbers
(ii) text
(iii) formulas
Explain what are the different methods of cell referencing in OOo Calc ?