Please type the Excel formula. If you have already answered this question, please don't answer. Previous submissions were incorrect, don't copy.

64 Required Homework Questions In the yellow box immediately below, use the MID function to select the third character of the text string. In the yellow box immediately below, use the SEARCH function to find what character in the stream matches 'cd', independent of case. In the yellow box immediately below, use the FIND function to find what character in the stream matches 'CD". In the yellow box immediately below, use the REPLACE function to replace the first 3 character of the stream with 'HIJ'. In the yellow box immediately below, use the TEXT function to convert the value 12 to a 4 character text string. In the yellow box immediately below, use the VALUE function to convert the four digit text string in the yellow box immediately above to a value. 82