Answer Happy

54 A 8 C D E F G H 1 K L M N con 3 A 4 5 C 6 Instructions: Attempt ALL questions. ALL questions to be answered in the Excel sheet. Time allocated-1 hour 7 8 9 10 Q1: Do the following steps to show your ability to use MS Excel basic skills 11 12 13 14 15 a) Download this file and save it with your name. b) Copy/paste each question in a new sheet. c) Rename each sheet with the question number. d) Answer the questions and make sure to do the required layout. e) Save your work and upload it within the allowed time. 20 Points Use MS Excel to: 16 17 18 19 20 02: 21 22 a) Create a formula that finds the area of a circle given the radius r as an input b) Use your formula to find the area of a circle with r = 15cm 23 24 4 Sheet1 +

20 Points 25 26 27 28 29 B FO 30 Q3: 31 32 33 34 35 36 Given that the volume and the total surface area of a cylinder is: V = arh A = 2rr2+2nrh a) Design a program that can find the volume and the total surface area for any cylinder given r and has an input b) Use your program to find the volume and the total surface area of a cylinder with r = 15cm and h = 25cm c) Make sure to do the following: Use font size 18 Use font name: Arial Use font color black and make it bold Highlight the input cell with red Highlight the output cell with green Use borders and thick border for the outer edges Set your alignment on "Middle Align" and "Center" Merge some cells whenever needed 37 38 39 40 41 42 Mac

53 16 47 48 49 04: Use MS Excel to: 50 དྲ། a) Design a program that can convert any decimal number to any other number system. 52 b) Use your program to convert 459 from decimal to all other number systems c) Make sure to do the following: Use font size 18 Use font name: Ariel Use font color black and make it bold Highlight the input cell with red Highlight the output cell with green Use borders and thick border for the outer edges Set your alignment on "Middle Align" and "Center" Merge some cells whenever needed 54 55 56 57 58 59 50 51 52 53 30 Points 55