As a weather analyst, you have been tracking daily high and low temperatures for Oklahoma City,…

As a weather analyst, you have been tracking daily high and low temperatures for Oklahoma City, Tulsa, and Lawton during June, July, and August. Each month’s data are stored in their own workbooks with each city’s data stored in its own worksheet. You need to apply consistent formatting and enter formulas for all worksheets. On each workbook, you need to create the summary worksheet to identify the record high and low temperatures by day and identify the respective cities. Finally, you will link the data to a master workbook.

a. Open e08m2june, and then save it as e08m2june_LastnameFirstname.

b. Group the city worksheets, and then do the following:

• Fill the formatting of cells A1, A2, and A5:C5 from the OKC worksheet to the other city worksheets. • Enter dates 6/1 to 6/30 in this date format (no year) in the Date column. Apply Orange, Accent 6, Lighter 80% fill to the dates.

• Split the window after 6/10. Scroll down in the second window to see the Monthly Records section. Note that only the active window in the grouped worksheets is split.

• Enter a function in cell B39 to calculate the highest temperature of the month. Enter a function in cell C39 to calculate the lowest temperature of the month.

• Use a nested MATCH function within the INDEX function in cell B40 to identify the date for the highest temperature. The dataset may contain several identical highest temperatures, but the nested function will identify the first date containing the match.

• Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature.

c. Use a Web browser to go to www.wunderground.com, a weather Web site. Locate and click the History Data link below the Local Weather menu, and then do a search for OKC. Copy the URL, and then create a hyperlink to this Web page for cell A3 in the OKC worksheet. Add a ScreenTip stating Click to see weather history for Oklahoma City.

d. Adapt step c to create hyperlinks for the Tulsa and Lawton worksheets as well. Use the Lawton-Fort Sill Airport (LAW) location for the weather link. Check each hyperlink to ensure it works correctly.

e. Enter the following 3-D formulas in the appropriate cell in the Summary worksheet:

• Calculate the highest temperature from the three cities for 6/1. Copy the formula down the High column.

• Calculate the lowest temperature from the three cities for 6/1. Copy the formula down the Low column.

• Enter a nested IF function in cell C6 to determine which city had the highest temperature. Remember to enclose city names in double quotation marks. Use Help if needed to help you understand a nested IF statement. Copy the formula down the High-City column.

• Enter a nested IF function in cell E6 to determine which city had the lowest temperature. Copy the formula down the Low-City column.

f. Enter formulas in the shaded Monthly Records section (below the daily data) to identify the highest and lowest temperatures. Enter nested INDEX and MATCH functions to identify the dates and cities for the respective highest and lowest temperatures.

g. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of each worksheet. Select the option to center the worksheet data horizontally on each sheet. Save the workbook.

h. Open e08m2july, and then save it as e08m2july_LastnameFirstname. Open e08m2august, and then save it as e08m2august_LastnameFirstname. Study the workbooks, and then adapt steps b and e above as necessary to enter formulas on grouped city worksheets and to enter 3-D formulas on the Summary worksheets for these two workbooks. The formatting and hyperlinks are done for you. Add your name on the left side of the footer for each worksheet.

i. Split the Summary sheet worksheets to show the first eight days in the top windows and the past four or five days and the summary data in the bottom window. Arrange the open workbook windows vertically with June on the left side, July in the middle, and August on the right side. Save this arrangement as a workspace file named e08m2workspace_LastnameFirstname.

j. Open e08m2summer, and then save it as e08m2summer_LastnameFirstname. Insert external reference links to the respective cells on the monthly Summary worksheets. Format dates and labels appropriately. Enter your name on the left side of the footer. Save the workbook.

k. Save and close the workbooks, and submit based on your instructor’s directions.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyhomeworkGeeks
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Criminal Justice
This has been the greatest help while I am recovering from an illness. Thank your team so much.
Customer 452671, May 2nd, 2021
Emergency Management
Overall, I think it's a great service. I have yet to submit the assignment, so I don't know what kind of grade I'll get. But customer service was excellent. Reviews were made and the assignment proofed for satisfaction.
Customer 453015, December 15th, 2021
Business Studies
Amazing!
Customer 452985, November 11th, 2021
Business and administrative studies
awesome work
Customer 453201, June 15th, 2022
English 101
Thank you for this excellent analysis of the Alchemist.
Customer 453213, June 15th, 2022
Health Care
The writer did not follow my choice of topic (Food/Water Insecurity, Hunger, & Poverty), the paper was instead written about Climate Change in Africa. However, the paper was still great and informative. Thank you!
Customer 452777, January 28th, 2022
Education
N/A
Customer 453057, May 23rd, 2022
Business Studies
Thank you so much! I had to take my dog to the ER and had no time for the assignment. I really appreciate your help! I can't thank you enough! I really appreciate the work and integrity put into it. Thank you for taking it seriously and not bullshiting the paper.
Customer 452815, July 26th, 2021
IT, Web
Awesome paper in such a short amount of time. Was in a jam with another service who didn't deliver, but Theresa did the job correctly. I will use her again to do my essays for sure!
Customer 452967, November 27th, 2021
Economics
Nice work
Customer 453185, May 21st, 2022
Humanities
Thank youuuu
Customer 452729, May 30th, 2021
Business Studies
Thank you very much for a good job done and a quick turn around time.
Customer 452615, March 31st, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp

Are You Looking For Assignment Help? We Can Certainly Assist You