1. As far as possible, the data should be kept in tabular form. Different types of data should be entered in different cells. Data should be entered neatly and in one ‘flow’. Unnecessary space and special characters should not be used.
2. Many times we ‘drag and fill’ data. At such times, the ‘smart tag’ can be used after ‘drag data’ to fill any data in any manner as required.
3. Once the data has been entered, it can be formatted in different ways. Similarly, we can perform different types of calculations, using different formulae.
4. While using a formula, the ‘=’ sign should be typed first. Similarly, no space should be inserted while typing any formula.