You have been provided with an Access database that contains sales data from a small bakery. The data has information about the client, bread type, cost to produce the bread sales. You have been asked to complete analysis in Excel and provide a few reports.
Provide and describe an example of functions or formulas you will use to create each of the following:
PART 1 Identify most sold bread type
PART 2 Determine which bread gives you most revenue
PART 3 Determine whose client is most loyal
PART 4 Additionaly explain how you will provide a report with your findings