Use Functions, Formulas, and Charts in Google Sheets: Challenge Lab

\\ Task 1 \\

=PROPER(A2)

=ISEMAIL(D2)

Sort sheet A-Z


\\ Task 2 \\

=SUBSTITUTE(I2,"Oct-5","Oct-10")

=VLOOKUP(A2, A2:D16, 4, False)


\\ Task 4 \\

=AVERAGE(C2:C101)

=MEDIAN(C2:C101)

=MAX(c2:c101)-MIN(c2:c101)

=STDEV(C2:C101)


\\ Task 5 \\

'Customer Ratings'!A1:C101