You need to divide the number of cars by the number of people to calculate cars per person on Day 1.

You need to divide the number of cars by the number of people to calculate cars per person on Day 1.

Image not displaying? Which formula can you type in Cell D92 to do this?

O =B92/C92
O =A92/B92
O =10*3
O =B93/C92
O =31
Rank the compounds below from lowest to highest melting point.

Identify the carbon atoms in the three amino acids.

The Correct Answer and Explanation is:

Let’s break this into two parts:

---

Part 1: Excel Formula for Cars Per Person in Cell D92

The correct formula to calculate cars per person on Day 1 using values in cells B92 (number of cars) and C92 (number of people) is:

✅ =B92/C92

Explanation:

In Excel:

• B92 contains the number of cars.
• C92 contains the number of people.
• To get cars per person, you divide the number of cars by the number of people.

This formula directly divides the number in B92 by the number in C92, giving you the desired “cars per person” figure.

Incorrect options:

• =A92/B92: This uses the wrong column (A92) which might not contain relevant data.
• =10*3: This multiplies two constants; it’s unrelated to your data.
• =B93/C92: This uses data from the wrong row (B93 instead of B92).
• =31: This is a constant, not a calculation.

---

Part 2: Ranking Compounds by Melting Point

To rank compounds from lowest to highest melting point, we need to understand molecular structure and intermolecular forces:

General Ranking Rule (Lowest to Highest Melting Point):

1. Nonpolar molecules (only London dispersion forces)
2. Polar molecules (dipole-dipole forces)
3. Hydrogen bonding molecules
4. Ionic compounds (strongest attractions)

Example ranking:

• CH₄ (methane) – Nonpolar, very low melting point
• CH₃OH (methanol) – Polar with hydrogen bonding
• NaCl (sodium chloride) – Ionic, very high melting point

Ranking: CH₄ < CH₃OH < NaCl

---

Part 3: Identify Carbon Atoms in Three Amino Acids

Let’s take three common amino acids:

1. Glycine (Gly) – Simplest amino acid
2. Alanine (Ala) – Contains a methyl side chain
3. Phenylalanine (Phe) – Contains a benzyl side chain

Each amino acid has:

• Alpha carbon (Cα) – Central carbon bonded to:
  • Hydrogen
  • Carboxyl group (–COOH)
  • Amino group (–NH₂)
  • R group (side chain)

Carbon Atoms in Each:

1. Glycine: 2 carbon atoms
   • 1 α-carbon
   • 1 carboxyl carbon
2. Alanine: 3 carbon atoms
   • 1 α-carbon
   • 1 carboxyl carbon
   • 1 methyl side chain carbon
3. Phenylalanine: 9 carbon atoms
   • 1 α-carbon
   • 1 carboxyl carbon
   • 1 β-carbon (attached to phenyl ring)
   • 6 carbons in the phenyl ring

In conclusion:

• Excel: Use =B92/C92.
• Ranking melting points: Based on forces.
• Carbon atoms: Identified by molecular structure and side chains.