Seasonal spreadsheet good for basic spreadsheet terminology and use of goal seek
Something went wrong, please try again later.
Thanks for sharing. Amazing content.
An engaging resource and it is good to have a spreadsheet that checks that the input matches the expected result. Unfortunately the answers can be found by clicking the face next to where each formula is to be input so 'cheating' is easy. <br /> The 'Goal Seek' sheet is locked so it is difficult to use the 'Goal Seek' feature to solve the problems and there does not appear to be any advantage to doing this rather than inputting a formula of the form =TRUNC('Goal Seek'!C5/'Santa Model'!$E$11). If the 'Goal Seek' feature is used then the answers produced are not truncated at 0 decimal places and so are marked incorrect. Additionally on the 'Goal Seek' tab answers 4 and 8 are incorrectly rounded up so would exceed the stated budget, admittedly only by £0.06 and £0.04 respectively but...
Lovely simple little tool for demonstrating the benefits of GoalSeek. Thanks for sharing!
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£0.00