QUESTIONS The data provided here shows daily sales (in quantity) of a bakery. Using this dataset and Excel functions, answer the following questions. 1) If a typical cake is $5.50, a pie is $10.50, a cookie is $1.99, smoothie is $3.99, and coffee is $2.50, then calculate Sales column (in dollars) for each day. HINT: cell freezing 2) "Weekday" column is numeric and shows the number of the day. For example, Monday is 1, Tuesday is 2, etc... Create a lookup table and use vlookup() to populate Weekday with the corresponding number for each day.

Fig: 1