Mr. thoreau uses an excel file to manage his grade book. he wants to average his homework grades for each term so that he can compare the subtotals for each class period. what steps could he follow so he can compare these averages?

select the data → click the data tab → select “subtotal” in the outline group → choose average in the use function
select the data → click the data tab → select “consolidate” in the data tools group → choose average in the function box
select the data → click the formula tab → select “calculation options” in the calculation group → choose automatic
select the data → click the formula tab → select “equation options” in the symbols group → select “insert new equation” → type in new equation

Multiple choice project create a program with two multiple choice questions. 1. users have two attempts only, show attempt number each time. hint: while loop with break control. (20%) 2. only one correct answer for each question, use switch case for each question. (20%) 3. show total score after the two questions are answered. hint: . (20%) 4. user have options to answer the two questions again if first attempt score is not 100%. hint: if statment. (20%) 5. use string method .toupper() to allow users to enter with lowercase or uppercase letters. (20%) 1. where is the capital of the state of florida? a. orlando b. tallahassee c. miami d. tampa b 2. where is walt disney world park located in florida? a. orlando b. tallahassee c. miami d. tampa a