Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Complete Guide To Property Finance

Authors: Richard W J Brown

1st Edition

1739832027, 978-1739832025

More Books

Students also viewed these Finance questions

Question

x-3+1, x23 Let f(x) = -*+3, * Answered: 1 week ago

Answered: 1 week ago

Question

4. Describe cultural differences that influence perception

Answered: 1 week ago