(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)
(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)
Take Free Practice Test On 2026 JAMB UTME, Post UTME, WAEC SSCE, GCE, NECO SSCE
Correct Answer: Option
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)
(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)