(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.
(a) A function in MS Excel is a pre-built formula that performs a specific calculation or task on data in a worksheet. It helps simplify complex calculations by allowing the user to use built-in formulas rather than manually writing out the calculation.
(b) Two categories of functions in MS Excel are:
- Mathematical Functions: These functions perform basic arithmetic calculations such as addition, subtraction, multiplication, and division. Examples of mathematical functions include SUM, AVERAGE, MAX, MIN, and COUNT.
- Logical Functions: These functions help evaluate conditions and return true or false values based on the outcome of the condition. Examples of logical functions include IF, AND, OR, NOT, and IFERROR.
(c) Cell referencing in MS Excel is a way to refer to a specific cell or range of cells in a worksheet. It helps identify the location of the data that needs to be used in a formula.
(d) (i) Two types of cell referencing in MS Excel are:
- Relative Cell Referencing: This type of referencing is used when the formula needs to be applied to multiple cells in a worksheet. It adjusts the reference based on the position of the cell relative to the formula's location.
- Absolute Cell Referencing: This type of referencing is used when the formula needs to refer to a fixed cell reference that does not change when the formula is copied to other cells.
(ii) An example of relative cell referencing is if we have a formula "=A1+B1" in cell C1, and we copy this formula to cell C2, it will automatically adjust to become "=A2+B2".
An example of absolute cell referencing is if we have a formula that multiplies the value in cell A1 by the value in cell B1, and we want to always refer to cell B1 regardless of where the formula is copied, we can use an absolute reference by adding a "$" sign before the column letter and row number of the cell reference. For example, "=A1*$B$1". Here, the reference to cell B1 is fixed, and it will not change when the formula is copied to other cells.