Solutions Page

Basketball Problem

Player Game 1 Game 2 Game 3 Game 4 Points Per Game
Jordan 23 34 17 28 25.5
Stackhouse 29 31 19 44 30.75
Jefferies 10 8 17 13 12
Russell 9 9 11 12 10.25
Hughes 16 7 9 19 12.75
Whitney 6 4 5 10 6.25
Dixon 12 2 14 9 9.25
Brown 6 10 5 8 7.25
Thomas 2 4 0 2 2
Haywood 6 5 3 2 4
White 10 8 2 3 5.75
Lue 0 7 2 0 2.25
Lloyd 0 0 0 4 1
Team 129 129 104 154 129

The Average Function is =AVERAGE(B2:E2) or (B3:E3) and so on for each row.

The Sum Function is =SUM(B2:B14) or (C2:C14) and so on for each column.

 

Opening, Creating, Saving, and Printing Problem

This is a very basic problem that the user should be able to do.  If any problems arise, re-read the section on opening Excel and Opening, Saving, and Printing Excel files.  Remember that the way to print both a landscape and a portrait document is through the the Page Setup.

 

Height Problem

 

Height Table
Males Height
Kevin 6.2
Derrick 5.9
Zack 6
Lavar 5.8
John 6.6
Avg. Height 6.1
Females Height
Stephanie 5.8
Marissa 5.3
Kim 5
Joanna 5.2
Lisa 5.4
Avg. Height 5.34

The Average Function of the males is =AVERAGE(B4:B8).

The Average Function of females is =AVERAGE(B12:B16).

 

Height Problem 2

Height Table
Males Height
Kevin 6.2
Derrick 5.9
Zack 6
Lavar 5.8
John 6.6
Avg. Height 6.1
Females Height
Stephanie 5.8
Marissa 6
Kim 5
Joanna 5.2
Lisa 5.4
Avg. Height 5.48

The Average Function of the males is =AVERAGE(B4:B8).

The Average Function of females is =AVERAGE(B12:B16).

 

Cow Problem

Cow Problem
Cows Week 1 Week 2 Week 3 High Week Avg. Grass
Cow 1 1090 1120 1160 1160 1123.3333
Cow 2 990 970 1050 1051 1003.3333
Cow 3 1200 1220 1240 1240 1220
Cow 4 1350 1350 1370 1370 1356.6667
Cow 5 890 910 970 970 923.33333
Cow 6 800 900 920 920 873.33333
Cow 7 1100 1140 1160 1160 1133.3333
Cow 8 1200 1260 1180 1260 1213.3333
Cow 9 1400 1410 1430 1430 1413.3333
Cow 10 1140 1120 1140 1140 1133.3333
Average 1116 1140 1162 1170.1 1139.3333

The Average Function for the rows follows the pattern of =AVERAGE(B4:D4).

The Average Function for the columns follows the pattern of=AVERAGE(B4:B13).

 

GPA Problem

Name Sex GPA Fall GPA Spring Cumulative GPA
Mark  M 2.5 3.2 2.85
Dave M 1.9 2.4 2.45
Lindsay F 4 4 4
Dianna F 3.6 3.3 3.45
Greg M 4 3.9 3.95
Omar M 3.7 4 3.85
Melissa F 2.1 2.2 2.15
Sharon F 3.1 3.5 3.3
Doug M 3.5 3.9 3.7
Cindy F 3.3 3.8 3.55

The Average Function for the rows follows the pattern of =AVERAGE(C2:D2).

 

Josephine's Individual GPA Problem

Jospehine's Individual GPA Calculation
Course Credit Grade Quality Points GPA
BMGT 201 3 A 12 57/17=3.35
PHIL 140 3 A 12
HIST 113 3 C 6
BMGT 220 3 A 9
CPSP 218 1 C 2
ECON 201 4 A 16
Total 17
A = 4 Quality Points
B = 3 Quality Points
C = 2 Quality Points
D = 1 Quality Points

The total quality points will change from 56 to 57.  Therefore, the GPA will change from 56/17 to 57/17.

Week Total Solution

Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Average
Number of Hours of Sleep 6 8 9 5 10 6 5 7
Number of Hours Working with Livestock 2 3 4 5 1 2 3 2.857143
Number of Hours with Friends 2 0 3 1 1 1 2 1.428571

This is an example of a solution to this problem.

 

Practice Quiz Answers

1. B, To open a new Excel file, one should click Start.

2. C, To print a file, one should click File and then move down to Print.

3. True, a constant can never change.

4. False, a formula can change, but a constant can not change.

5. A, A worksheet is Excel's name for a spreadsheet.

6. Rows are the horizontal boxes throughout an Excel worksheet.

7. A cell reference is the name of the column letter and the row number, such as B7.

8. A, To open any Microsoft Office software, one should click the Start button.

9. True, The List View only shows the name of the saved file.

10. False, The Details View shows the name of the file and when it was last worked on.  The Properties View shows how many times the saved file has been changed.

11. C, The Average function will compute all of the cells between the specified areas, including the cells specified.

12. B, Saving an Excel file to a hard drive would be saving the file to the C Drive.

13. D  Page Setup deals with both Headers and Footers.

14. Rows can be inserted into worksheets by clicking Insert and moving down to Rows.

15. False, the Delete command does all of the described functions.

16.Functions of the Excel Office Assistant: Ask Questions, Get Answers, and Provide Suggestions.

The purpose of Excel’s Office Assistant is to provide help to the user when he or she may have question that needs clarification.  The Assistant will make suggestions about how to make your worksheet look more professional. The Assistant can be annoying at times, which is why it is recommended to only use it when you need help or have a question.

17. Worksheets combine to make workbooks.  A workbook is composed only of worksheets.

18. Answers may vary.  Common reasoning is that it makes information organized and easier to analyze.

19. The purpose of the AVERAGE function is to allow the Excel user to calculate the average of either entire rows or entire columns to calculate the average of the row or column.

20. Answers will vary.

Back to Practice Test

Continue to Review

Back to Lessons