$2.$ Copy the original data set into another new tab. This tab will be called $$Custom Columns.$$ In this tab, you will add three custom columns to the data set as per the following instructions:

a$.$ Create a column titled $$contains$\_$bran.$$ For this column, write a formula which determines if the cereal name contains the text $$bran$.$ If the cereal name does contain $$bran$,$ return TRUE. If $$bran$$ is not in the cereal name, return FALSE.

b$.$ Create a second new column titled $$manufacturer$.$ For this column, return $$Kelloggs$$ if the value in the $$mfr$$ column is $$K$.$ If the value in the $$mfr$"$ column is $$G$,$ then return $$General Mills.$$ For all other cereal manufacturers, return $$Other$.$

c$.$ For the third custom column, make a column titled $$hot$/$cold$.$ For this column, return a value of $$hot$$ if the column $$type$$ has a value of $$H$.$ If the value in the $$type$$ column is $$C$,$ then return a value of $$cold$.2.$ Copy the original data set into another new tab. This tab will be called $$Custom Columns.$$ In this tab, you will add three custom columns to the data set as per the following instructions:

a$.$ Create a column titled $$contains$\_$bran.$$ For this column, write a formula which determines if the cereal name contains the text $$bran$.$ If the cereal name does contain $$bran$,$ return TRUE. If $$bran$$ is not in the cereal name, return FALSE.

b$.$ Create a second new column titled $$manufacturer$.$ For this column, return $$Kelloggs$$ if the value in the $$mfr$$ column is $$K$.$ If the value in the $$mfr$"$ column is $$G$,$ then return $$General Mills.$$ For all other cereal manufacturers, return $$Other$.$

c$.$ For the third custom column, make a column titled $$hot$/$cold$.$ For this column, return a value of $$hot$$ if the column $$type$$ has a value of $$H$.$ If the value in the $$type$$ column is $$C$,$ then return a value of $$cold$.$