Get premium membership and access revision papers with marking schemes, video lessons and live classes.
Processing. Please wait.

 Form 2 Computer Studies Questions and Answers on Spreadsheets

Describe four cell data types as used in spreadsheets.

 (2m 10s)
1169 Views     SHARE

Answer Text:
i)Formulae: a formula is a use-defined mathematical expression that creates a relationship between cells to return a new value. It must start with an equal (=) sign.
ii)Function: a function is a predefined formula that is
used to perform calculations. It must start with equal (=) sign, have function name and data range.
iii)Values: values only contain characters that are manipulated mathematically. They include date, time, currency, fractions, scientific notation
and percentages among others.
iv)Labels: labels contain text or numeric characters that cannot be manipulated mathematically. For example, if a column has names of car model then the column title can be Cars