G18 X V fx A B C D E F G H H K L M AMS1000 2016-17 Semester 2 W N Name Overall 4 Student ID Quiz 1 Quiz 2 Test Exam Grade Score 5 Amy Au 104144 75 65 65 63 6 Ben Bai 106508 90 90 85 72 Donald Ding 107852 90 75 52 80 Edith Edwards 115399 80 90 60 42 Average Max Min WeightsLesson 1 Quiz Introduction and Excel Tutorial Follow steps ('1) to (viii) and answer Questions (1) to (9). (i) Open Lesson 1 Quiz Excel.xlsx and you should see a spreadsheet as follows: ----_-nn __----_- 2 5 7 ----- ------ ---- mm\" mm\" "WI _----_ _----_ Note: When you enter the information in the first column, the text \"runs over\" into the next column. To uojiust the width of Column A, doubleclick on (or click and drag) the edge of the column heading between Column A ant!T Column B after all the information is entered for the column. (ii) In Row 10, calculate the average of Quiz 1, Quiz 2, Test and Exam, respectively. (iii)ln Row 11 and 12, nd the maximum and minimum of Quiz 1, Quiz 2, Test and Exam, respectively. (iv) The weights of each of the assessments are given in the course outline. Enter them in Row 14. om (v) In Column G, calculate the Overall Score (using relative reference ! absolute reference) for all of the students. (vi) Using the IF or IFS function, assign letter grades to the students in Column H. "u\" (vii) You found that a student, Carmen Chu, was missing from the grade sheet. Insert a row such that the names of the students are in alphabetical order. mm \"m. g iestions (1) What grade did Ben Bai get? (2) What is the average score of Quiz 1 for these 5 students? (3) Which student has the highest Overall Score? (4) Suppose you found a typo on the exam score when you double-check, Amy Au scored 36 instead of 63. What is her \"real" grade? (5) If the weights of Quiz 1 and Quiz 2 are changed to 15% each instead, whose grade will be affected? (viii)Submit the nal version of the Excel le after all the necessary changes. (6) Chinese abacus is not used by any people in any countries nowadays. - True 0 False (7) Which of the following is not an example of mechanical calculator? - Arithmometer 0 Comptometer 1- Pascal's calculator I Sundsu'and 1- Salamis tablet (8) According to Dan Bricklin, which of the following is the reason that the co-creator of VisiCalc did not patent VisiCalc? - They forgot about ling a patent. - They do not have the legal knowledge about patent. 0 It was too expensive to obtain a patent at that time. ('1 0 It was very difcult to obtain a patent on software at that time. c All of the above 0 None of the above (9) Which of the following is not a spreadsheet software? 0 Neroso Excel 0 Numbers - Wolfram Alpha O Lotus 1-2-3 - VisiCalc