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.