Excel Problem

A B C D E F G H _ J K L M N O P Q R 1 Import the Daily Rainfall.txt file. Separate the data fields into columns. 2 Which characters are used in the Flag1 field? 3 Copy all the records that have rainfall data (Prcp) greater than 0.3 and a minimum temperature greater than 70 (Tmin) into a separate block Include column headings and do not change the order of the records 4. Create a table, in a separate sheet, listing the maximum temperature (Tmax) for each month in each year. 5 Tmax Tobs Cdd Hdd Prop Flag 1 day 11 70 Tmin 86 80 79 Tmean 72 70 64 78 1 2 3 9 11 68 63 74 71 11 11 11 11 6 79 11 0.53 0.09 2006 11 11 11 7 COOPID WBANID year month 8 87886 92806 2006 87886 92806 2006 10 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 87886 92806 2006 27 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 31 87886 92806 2006 87996 02806 2006 OOOOOOOOo Vwoooooooooooo bwoo wowoOOOOOOOOOOOOOO 11 80 0 0 2006 11 11 0.03 0.03 29 11 0 A B C D E F G H _ J K L M N O P Q R 1 Import the Daily Rainfall.txt file. Separate the data fields into columns. 2 Which characters are used in the Flag1 field? 3 Copy all the records that have rainfall data (Prcp) greater than 0.3 and a minimum temperature greater than 70 (Tmin) into a separate block Include column headings and do not change the order of the records 4. Create a table, in a separate sheet, listing the maximum temperature (Tmax) for each month in each year. 5 Tmax Tobs Cdd Hdd Prop Flag 1 day 11 70 Tmin 86 80 79 Tmean 72 70 64 78 1 2 3 9 11 68 63 74 71 11 11 11 11 6 79 11 0.53 0.09 2006 11 11 11 7 COOPID WBANID year month 8 87886 92806 2006 87886 92806 2006 10 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 87886 92806 2006 27 87886 92806 2006 87886 92806 2006 87886 92806 2006 87886 92806 2006 31 87886 92806 2006 87996 02806 2006 OOOOOOOOo Vwoooooooooooo bwoo wowoOOOOOOOOOOOOOO 11 80 0 0 2006 11 11 0.03 0.03 29 11 0