Computer Applications
What are the rules to be followed while entering the following in OOo Calc ?
(i) numbers
(ii) text
(iii) formulas
Answer
The rules to be followed while entering the following in OOo Calc are as follows:
(i) Numbers — A number can contain only the following characters :
0 1 2 3 4 5 6 7 8 9 + - ( ) , / $ % . E e
(ii) Text — Text is any combination of numbers, spaces, and non-numeric characters.
(iii) Formulas — A formula begins with an '=' sign and can contain values (entries that can be used for calculations), operators (e.g., +, /, *) and cell addresses (e.g., C9, B14).
Related Questions
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.
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.
Explain what are the different methods of cell referencing in OOo Calc ?
Differentiate between mixed referencing and absolute referencing by giving suitable examples.