Science, asked by priyeshmhatre2, 1 year ago

what precautions we must take while entering data in a spreadsheet

Answers

Answered by Anonymous
8

Two rules when entering dates in spreadsheets:

Before you start entering data, always format all the cells in the date column as 'Date' with an unambiguous display format such as '1 May 2014' (or 'May 1, 2014' if you wish) or '2014-05-01'.

(In Excel: Click on the letter at the top of the column to select the whole column, then go to Format > Cell... and the Number tab, then select 'Date' and your chosen format. Calc is similar. This will not prevent you putting in text as column headings, etc.)

 

Type in dates in a short format, not the same format they are displayed: eg. type '1/5' or '1/5/14', not '1 May 2014', then check that the program has interpreted it correctly. This will also catch mistakes such as typing '31/4'.

Hope it helps,

plz mark as the Brainliest


Similar questions