When juggling with large amounts of data, the most frequent operation is creating new columns and applying custom formula's to the entire column. Even for newbies learning this operation will…