Question
Open the workbook Task2-1. Save it as Task2-3.xlsx. AutoFormat the cells the months to the total and the columns for the date through to December:
Open the workbook Task2-1. Save it as Task2-3.xlsx. AutoFormat the cells the months to the total and the columns for the date through to December: Select the cells. Select the Home tab on the Ribbon. Select Format as Table from the Styles group. Select Table Style Medium 2 from the displayed styles. Accept the default data range and header setting from the dialog box. Select the Table Tools -> Design tab on the Ribbon. Select Convert to Range from the Tools group to remove the filter buttons from the month headers. The gauge used to capture the figures in Task2-2.xlsx is inaccurate. The person collecting the figures wants you to add 7%, but you should set up a conversion that lets you change the correction easily. Copy the layout of Task2-2.xlsx to a new page in Task2-3.xlsx. Update the links so the cell references point to the original rainfall data in Task2-3.xlsx. Create a column for the adjustment, and another for the adjusted figure. Calculate the total adjusted rainfall for the year. Use conditional formatting on the daily rainfall to highlight any day where the rainfall is greater than 25 and redyellowgreen colour scale to show the differences in the monthly totals. Resave Task2-3.xlsx.Create a test plan you can use for the rainfall spreadsheet, Task2-3.xlsx.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started