Question

Answer the following.

What precautions will you take when entering data in a spreadsheet?​

Answer 1

Answer:

Don't leave blank rows or columns when entering related data.Do save frequently and save in two places. Don't use numbers as column headings and don't include units with the data.Do use cell references and named ranges in formulas. Don't leave cells containing formulas unlocked.Do sort your data.

Answer 2

$\huge\pink{\mid{\fbox{{ANSWER}}\mid}}$

(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 nearly 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 dog' 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.