Q14 Spreadsheets [18 marks) Last summer, I went for a trip to the Yosemite National Park, USA, to do some rock climbing with friends. There are several grading systems to evaluate how hard the rock-climbing routes are. Two of the most used systems are the YDS (Yosemite Decimal System) and the French System. I noted the YDS grade of the routes I have passed. I want to create a spreadsheet to quickly translate the YDS grades into the French System so I can relate them to what I am used to climbing in France. D E My routes YDS French System Goal reached? 5.8 5.10a 5.9 5.10 5.11a 1 Rock Climbing Grades 2 YDS French System Level 3 5.2 1 Beginner 4 5.3 2 Beginner 5 5.4 13 Beginner 6 5.5 4 Beginner 7 5.6 Sa Beginner 8 5.7 Sb Beginner 9 5.8 5c Beginner 10 5.9 Beginner 11 5.10a 6a Intermediate 12 5.100 6a+ Intermediate 13 5.10c6b Intermediate 14 5.100 6b Intermediate 15 5.11ac Intermediate 16 5.11b6c+ Intermediate 17 5.11c7a intermediate 18 5.11d Za Intermediate (a) [7 marks] What formula, using the VLOOKUP function, should I use in F3 to obtain the French System grade corresponding to the YDS grade that I entered in E32 Note: The formula must be able to be filled down from F3 to F7. (b) (4 marks) What function would I use if my data was transposed (i.e. organised horizontally instead of vertically)? () [7 marks] Hurrah, the formula works, and I got all the grades translated into the French System. Here are the results: Page 5 of 6