Assignment #11

1. Watch the video Reformatting Data (Google Sheets)   (CC).

2. Create a Google Sheets spreadsheet similar to the document developed in the video and shown below. (Data/code). In particular, create an "Extract Addresses" command button that when pressed extracts the address, city, state, and zip code. Insert your name somewhere in the document. Rename this sheet "Assignment 11A".
   
   
   
   

   Complete either Step #3 or Step #4 below.

3. Create a new tab in the Google Sheets document created in the previous step. Rename this sheet "Assignment 11B". Enter the data as shown in the image below. Create an "Extract Names" command button that when pressed extracts the first and last names.
   
   
   
   
4. Explore the tutorial JavaScript Tutorial. Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step.
   
   
5. Save your work as "assignment11". Share this document with your instructor: rosener@nsuok.edu.
   
   
6. Create a link to this document on YOUR-CLASS-WEBSITE.   Help

OR

Convinced the instructor that you understand the key concepts covered in the tutorial listed in Step #4.