An event planner for a large global company. You have been asked to prepare a report on the best time of year to visit one of three different cities: Rome, Miami, and Honolulu. You have researched their temperatures for the entire year and obtained them on a daily basis. You have decided to find the two week period during the year when the temperatures average 72 degrees. Explain in detail how you would develop a spreadsheet to find the average two week temperature and arrange the data so that the two weeks period most close to 72 degrees are presented for each city in the appropriate table.
You work for a cleaning company and your boss has asked you to create a report from the four different locations he manages.
(TCO 9) 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 and sales. You have been tasked to provide a few reports. Provide and describe an example of functions or formulas you will use to create each of the following reports. Make sure to not repeat the same formula or function.
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. Additionally, explain how you will provide a report with your findings.