(a) What is a function in MS Excel?
(b) List two categories of functions in MS Excel.
(c) What is the cell referencing in MS Excel.
(d)(i) State two types of cell referencing in MS Excel.
(ii) Give one example of each type in 1(d)(i)
Explanation
(a) Meaning of Function
A function is a predefined formula that performs calculations using specific values in a particulr order.
(b) Categories of functions in MS Excel
(i) Autosum (ii) Look up and Reference (ii) Maths and Trigonometry (iv) Date abd Time (v) Database (vi) Financial (vii) Statistical (viii) Compatibility (ix) Web (x) Information
(c) Cell referencing is the use of alphanumeric value to identify a specific cell in a spreadsheet application.
(d)(i) Types of cell referencing in MS Excel
- Absolute referencing
- Relative referencing
- Mixed reference
(ii) Examples of each cell referencing
$A3$1 (Absolute - with the $ sign)
A3*C3 (relative - withoute the $ sign)
$A3*B$2 (Mixed)