Describe four cell data types as used in spreadsheets.
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 isused 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 notationand 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
Get premium membership