Mastering Excel QUIZ San Jose State University ENGR 10

Mastering Excel QUIZ Due Sep 16 at 11:59pm Points 15 Questions 15 Available Sep 2 at 11:59pm ­ Sep 16 at 11:59pm 14 days Time Limit 30 Minutes Allowed Attempts 2 Instructions Attempt History Attempt Time Score KEPT Attempt 2 3 minutes 14 out of 15 LATEST Attempt 2 3 minutes 14 out of 15 Attempt 1 11 minutes 13 out of 15 Score for this attempt: 14 out of 15 Submitted Sep 16 at 11:30am This attempt took 3 minutes. Take this quiz only after you have done the second Excel lab. You need information on plotting to complete this quiz. Be sure to click on the "submit" button at the end of the quiz. 1 / 1 pts Question 1 The number 90 is currently in cell A1. If you now click on the % sign in the Excel menu, what will the number in cell A1 be? 900% Correct! 9000% 90% 0,90 1 / 1 pts Question 2 What answer will appear for the equation in cell C1? ­5 ­20 Correct! 140 sum(A1:A4) = 14 and 14*10=140 10 160 Q 1 / 1 pts uestion 3 The spreadsheet shown below is being used to calculate the area of a circle with different diameters(D). What is the equation that is written in cell B3? Correct! =PI()*A3^2/4 =PI*A3^2/4 =PI()*A3*A3 =PI*D*D/4 0 / 1 pts Question 4 If you drag cell C1 to cell C6, what will the answer be? 18 This equation has an error. The $ shouldn't be there. Correct Answer 9 You Answered 4 A6+B$1­A$4 = 6+7­4 = 9 1 / 1 pts Question 5 The spreadsheet shown summarizes the inventory of swtiches in VEX kits in the ENGR 10 lab. Which of the equations below would be an INCORRECT equation in cell C8 to determine the total number of limit switches? =SUM(B2:B6) All of these equations are correct =SUM(B2+B3+B4+B5+B6) =B2+B3+B4+B5+B6 Co =COUNT(B2:B6) rrect! 1 / 1 pts Question 6 The spreadsheet shown contains data from an experiment. What equation should the student type in cell C11 to determine the maximum gas mileage?