Spreadsheet Functions and Conversions

The video tutorial explores units of measurement, focusing on converting height from centimeters to meters and then to feet. It explains the need for conversion when calculating BMI and demonstrates the use of formulas in Excel for these conversions. The tutorial also covers rounding techniques to express height in feet and inches, emphasizing practical applications and common usage in both metric and imperial systems.

Why is it important to convert height from centimeters to meters?

• To simplify addition

• For calculating BMI

• To match imperial units

• To make it easier to read

How many centimeters are there in a meter?

• 10

• 100

• 50

• 1000

What is the symbol used for division in spreadsheet formulas?

• Plus (+)

• Dash (-)

• Slash (/)

• Asterisk (*)

What is the conversion factor from centimeters to feet?

• 40.48

• 30.48

• 20.48

• 10.24

Why is it not natural to express height in decimal feet?

• People prefer whole numbers and inches

• It is not commonly understood

• It is too precise

• It is difficult to calculate

What function is used to ensure feet are rounded down in spreadsheets?

• ROUND

• ROUNDUP

• ROUNDDOWN

• FLOOR

What happens if you include spaces in spreadsheet formulas?

• It speeds up calculations

• It may cause errors

• It works fine

• It makes the formula more readable

What is the purpose of the ROUND DOWN function?

• To always round numbers down to the nearest whole number

• To convert numbers to fractions

• To round numbers up to the next whole number

• To round numbers to the nearest whole number

How do you specify no decimal places in the ROUND DOWN function?

• By using a dash and one

• By using a colon and zero

• By using a semicolon and one

• By using a comma and zero

What is the result of rounding down 5.9 feet?

• 5.5 feet

• 5 feet

• 4 feet

• 6 feet