UCI Excel Exercise

Instructions LAB QUIZ 3: 1) Please save your excel file as “SS3A_’firstname_lastname” before submitting on canvas.

2) Make sure to write your name, and student ID on the excel file.

3) Show your work; that means formulas. If we cannot see how you solved a problem, you will not get credit.

4) This is not a group assignment! Do not discuss the quiz with other students, either over email or Canvas. If you have questions email your TA.

_____________________________________________________________________________

Question 1 (15 points): Using the data in Sheet 1, make a pivot table that shows both the sum and percent of their total spending that each person spent in each category.

Question 2 (10 points):

• Use a VLOOKUP command to find how much money James spends on entertainment.
• Use an HLOOKUP command to find how much money Nathan spends on Groceries (hint: you need to transpose the data first).

Question 3 (15 points): Make a scatter graph with the data in sheet 2. Put hours exercised per day on the x-axis and total cholesterol on the y-axis (if you’re not sure you have the axes right, check the select data section to see what range you have in the x and y values). Using the add chart element button, add a linear trendline. Label the axes and add a chart title.

Question 4 (10 points): How would you describe the relationship between the number of hours people exercise per day and their cholesterol levels (what is the direction of the trendline)? If someone increased their level of exercise, what would we expect to happen to their cholesterol level based on this data?