Michelle W's
Programming Web Page
LINK
To see my excel spreadsheet quiz answers, you can click here :)
My other answers........
3.) You are actually putting the date in a date, but it thinks that you are dividing. For an instance, if the date is 2/4/1981, it will think that you are trying to do:
2/4 and then divided by the number 1981. It doesn't know what you are trying to do, so that is why it has the #### signs. There was an error.
4.) The cell G2 gives you the minimum charge, so you know what the cost is.
5.)I used the LEN function, a function that I have never used before. This function returns the number of characters in a text string.
6.) Cell I2 finds the calculated charge for you.
*Answers 1 and 2 are in my excel spreadsheet.