lab 3 exercise 5.2 PRINT

lab 3 exercise 5.2 PRINT - 67 Excellent LUSSIE F 54 120...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Comments Page 1 Comments The Fitness_Data worksheet contains the names, gender, age and pulse rate date for a group of individuals who are having their fitness analysed. The pulse rate test consists of doing a fixed amount of exercise, resting for a short period of time, and then measuring the individual's pulse rate. This gives an indication of the individual's fitness. In this model you'll develop various approaches to calculating the fitness rating using IF  functions.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Lab 3 Exercise 5.2 Raafia Siddiqui 211098936 Fitness Data (formula view) Name Fitness BUSHBY M 26 75 Excellent CAMPB M 52 97 Average CORRE M 33 86 Good DHILLO F 29 104 Average FERNAN M 56 75 Excellent FRASER M 35 87 Good GRAVAS F 22 111 Fair HALL F 23 96 Good JOHNSO F 29 102 Average JOLLY F 10 87 Good KALICH M 27
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 67 Excellent LUSSIE F 54 120 Fair MUHIC M 22 79 Excellent NACCI F 13 97 Good OLDFIE M 19 79 Excellent PARK M 51 135 Poor PAULSO F 56 124 Poor ROY F 46 127 Poor RUSSO M 11 91 Average SABHAR M 18 74 Excellent SHERRI F 17 75 Excellent SIMPSO M 35 124 Poor SIN F 34 84 Excellent SMYLIE M 22 98 Average THOMA M 33 101 Average TJANDR M 12 105 Fair TROTTE M 23 73 Excellent WONG M 45 113 Fair WRIGHT F 14 89 Good BERNIE F 52 79 Excellent BINCE M 26 98 Average CUKIER F 15 115 Fair DA-COS M 23 82 Good Gen der Ag e Pulse Rate Lab 3 Exercise 5.2 Raafia Siddiqui 211098936 Fitness Data (formula view) HUNT M 46 127 Poor IVANOV M 52 78 Excellent Men Women Fitness Rating Excellent 80 87 Good 90 100 Average 105 111 Fair 115 123 Poor...
View Full Document

Page1 / 4

lab 3 exercise 5.2 PRINT - 67 Excellent LUSSIE F 54 120...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online