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

Task 1 ------------------------------------------------------

=PROPER(A2)

=ISEMAIL(D2)


Task 2 ------------------------------------------------------

=SUBSTITUTE(H2,"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