Create a line chart showing temperature variations over time with appropriate titles and legend.

Welcome back Samantha — missed you this week. Here are the steps to complete your project: Step 1: Create the Worksheet • Open your spreadsheet software (e.g., Microsoft Excel, Google Sheets). • Enter the provided data into the worksheet. Ensure that days and times are in appropriate columns/rows and temperatures are entered accurately. • Apply any specific formatting (e.g., font, cell colors, borders) as instructed in the original task (which is not fully visible here). Step 2: Create a Line Chart for Temperature Variations a) Select the data range that includes the days, times, and corresponding temperatures. • Go to the Insert tab (or equivalent menu). • Select Charts and choose a Line Chart (e.g., Line with Markers). b) To insert the chart title: • Click on the chart to select it. • Go to Chart Design or Chart Tools tab. • Select Add Chart Element > Chart Title > Above Chart. • Type "Temperature Variations" as the title. c) To add axis titles: • With the chart selected, go to Chart Design or Chart Tools. • Select Add Chart Element > Axis Titles. • Choose Primary Horizontal and type "Time (Hours)". • Choose Primary Vertical and type "Temperature (degree Celsius)". d) To displace the chart legend: • Click on the legend in the chart to select it. • Go to Chart Design or Chart Tools. • Select Add Chart Element > Legend > Right. Step 3: Calculate Average Daily Temperatures • Assume Monday's temperatures are in a column, for example, cells B2 through B8. • In cell B9, enter the formula to calculate the average temperature for Monday: =AVERAGE(B2:B8) • To copy this formula across to other days: • Click on cell B9. • Drag the fill handle (a small square at the bottom-right corner of the selected cell) horizontally across the row for the number of days you have data for (e.g., to C9, D9, etc.). This will automatically adjust the cell references to calculate the average for each subsequent day. Step 4: Create a Bar Chart for Average Daily Temperatures • Select the range containing the days (e.g., A9:A13 if you have 5 days) and their corresponding average temperatures (e.g., B9:F9). • Go to the Insert tab. • Select Charts and choose a Bar Chart (e.g., Clustered Column). • Add axis titles as described in Step 2c, labeling the horizontal axis as "Days" and the vertical axis as "Average Temperature (degree Celsius)". Step 5: Create a Pie Chart of Days versus Average Daily Temperatures • Select the range containing the days (e.g., A9:A13) and their corresponding average temperatures (e.g., B9:F9). • Go to the Insert tab. • Select Charts and choose a Pie Chart. • Ensure the chart labels show the days and their respective average temperatures or percentages. Step 6: Save and Print • To save your work: • Go to File > Save As. • Navigate to your working directory. • Name the file "project 2". • Click Save. • To print a copy: • Go to File > Print. • Adjust print settings as needed (e.g., print area, orientation). • Click Print. What's next? Send 'em! 📸