Describe four cell data types as used in spreadsheets.
Answer:
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
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
Share To Friends Via:
Define the term word processing as used in computing. 
