Homework 2: =if(know how, "do problem", "ask for help")
The goals of this homework are:
- Practice with if and ifs
- Practice with text functions.
Do not solve these problems with text to column. Use if and text functions to accomplish these tasks.
Starting with this file
- Add a column after C and compute the actual rating.
- The rating is all of the numbers to the left of the first space.
- A value function wrapping everything will make it a number.
- Add three columns after E
- In column F extract the day form column E. Notice that the date may be one or two digits. Mid difficulty.
- In column G extract the month, (This was hard)
- In Column H extract the year, if you do this right it is easy.
- Add a column after J
- In cell P2 put a word that might be in the comments.
- I column K, repeat this word if it is in the comment in column j
- Insert a column after L
- Find the number of people who found the comment helpful.
- Cover all cases.
- ifs was really helpful here.
-
- While a full about page is not required, please make sure you add your name to an about worksheet.
Submit
Upload the final worksheet to the Assignment Submission section of Dropbox by the due date.