Create a spreadsheet for the Height and Weight data given in below Weight Height StulD pounds (Ibs) Feet Inches BMI Category 10010 102 4 10 10020 135 5 4 10030 285 6 10040 194 6 10050 206 10060 190 6 2 10070 275 4 11 10080 175 4 5 10090 140 6 5 10100 150 2 10110 190 5 9 10120 120 5 10130 185 5 8 10140 190 5 10150 165 5 11 10160 205 6 4 Under Normal Over Obese Totals 1. Use word wrap for headings 2. Use borderes and fills to create good visual effects 3. Place the title (BMI Claculations) in merged cells centered across the top of the table 4. Rename the tabe at the bottom of the sheet as BMI 5. Enter the formula for BMI, using 1 decimal place accurarcy for the results. mass(lb) * 703 (height(in) BMI 6. Use https://www.nhlbi.nih.gov/health/educational/lose_wt/BMI/bmicalc.htm to create a VLOOKUP table. The given BMI categories are 1.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Use the attached images to create a spreadsheet and use appropriate formulas.. show how to do the steps?

Create a spreadsheet for the Height and Weight data given in below
Weight
Height
StulD
pounds (Ibs)
Feet
Inches
BMI
Category
10010
102
4
10
10020
135
4
10030
285
1
10040
194
6
10050
206
6
10060
190
6
10070
275
4
11
10080
175
4
5
10090
140
6
5
10100
150
10110
190
5
10120
120
5
5
10130
185
5
8
10140
190
5
5
10150
165
5
11
10160
205
6
4
Under
Normal
Over
Obese
Totals
1. Use word wrap for headings
2. Use borderes and fills to create good visual effects
3. Place the title (BMI Claculations) in merged cells centered across the top of the table
4. Rename the tabe at the bottom of the sheet as BMI
5. Enter the formula for BMI, using 1 decimal place accurarcy for the results.
mass(lb)
* 703
(height(in))
BMI
6. Use https://www.nhlbi.nih.gov/health/educational/lose_wt/BMI/bmicalc.htm to create a VLOOKUP
table. The given BMI categories are
2.
Transcribed Image Text:Create a spreadsheet for the Height and Weight data given in below Weight Height StulD pounds (Ibs) Feet Inches BMI Category 10010 102 4 10 10020 135 4 10030 285 1 10040 194 6 10050 206 6 10060 190 6 10070 275 4 11 10080 175 4 5 10090 140 6 5 10100 150 10110 190 5 10120 120 5 5 10130 185 5 8 10140 190 5 5 10150 165 5 11 10160 205 6 4 Under Normal Over Obese Totals 1. Use word wrap for headings 2. Use borderes and fills to create good visual effects 3. Place the title (BMI Claculations) in merged cells centered across the top of the table 4. Rename the tabe at the bottom of the sheet as BMI 5. Enter the formula for BMI, using 1 decimal place accurarcy for the results. mass(lb) * 703 (height(in)) BMI 6. Use https://www.nhlbi.nih.gov/health/educational/lose_wt/BMI/bmicalc.htm to create a VLOOKUP table. The given BMI categories are 2.
BMI Category
BMI range
Underweight
<18.5
Normal
18.5 – 24.9
Overweight
25 – 29
Obese
>29
7. Include totals for each category using COUNTIF.
Transcribed Image Text:BMI Category BMI range Underweight <18.5 Normal 18.5 – 24.9 Overweight 25 – 29 Obese >29 7. Include totals for each category using COUNTIF.
Expert Solution
steps

Step by step

Solved in 6 steps with 2 images

Blurred answer
Knowledge Booster
Search Engine
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education