25 min read

Percentages, Fractions, and Scientific Notation

Percent format multiplies display by 100. Fractions show parts of a whole. Scientific notation for very large budget variances.

Why Percent, Fraction, and Scientific Formats

Dr. Helen Marsh needs contingency rates as 5%, variance as 1/8 of a grant, and a national equipment bid in scientific notation. Each format must keep formulas correct.The contingency rate 0.05 in I1 already drives **=F2*(1+1). This lesson connects that decimal to 5% on screen — and explores when fractions and scientific notation help on NorthgateBudget.xlsx**.On Budgets, you will format I1, calculate quarter-over-quarter change as a percent, and preview scientific notation on large totals.

Percentage format multiplies the display by 100; the stored value stays a decimal. Select I1 (contingency rate 0.05). Home \to Number \to Percentage . Stored value Percent display 0.05 5% 0.125 12.5% 1 100% Formulas still use 0.05 — **=F2*(1+ I 1) does not change when you apply %** format.

Compare English Q2 to Q1: In L1, type Q2 vs Q1 % . In L2, type =(C2-B2)/B2 and press Enter . With B2=12500 and C2=12800, the result is about 0.024 (2.4% increase). Apply Percentage format with one decimal to L2 . Copy L2 down to L6 to see each department's Q1\toQ2 change. Science Q4 is 19000 vs Q3 18200 . The percent change formula =(E4-D4)/D4 shows roughly 4.4% — easier for Dr. Helen Marsh to scan than raw pound differences.

Home → Number → Fraction displays decimals as fractions — 0.5 as 1/2, 0.25 as 1/4.Useful when a grant line is "three-quarters spent": cell holds 0.75; Fraction format shows 3/4.Fractions are still numeric — =SUM works. They are display only, like currency.

Very large or small numbers use scientific notation : 1.25E+04 means 12,500 . Click F2 (English annual total 50500). Format Cells \to Number \to Scientific with 2 decimal places. The display changes; the value used in SUM does not. Switch back to Currency for the finance report. National research grants might use scientific notation in import files — convert to Number or Currency before school budget meetings.

Percent vs typing 5 in the cell

You type 5 in I1 and format as Percentage. The cell shows 500% . Every contingency total is wildly wrong. Type 0.05 for 5%, then apply Percent format — or type 5% and let Excel store 0.05. Return budget columns to Currency before printing for governors.

Practice

Swipe or use the arrows to move between questions.

1 / 2

I1 stores 0.05 and displays 5%. What does =F2*I1 calculate?

Two cells show 1/2 and 1/4 in Fraction format (stored as 0.5 and 0.25). What does =SUM(range) return?

Why Percent, Fraction, and Scientific Formats

Dr. Helen Marsh needs contingency rates as 5%, variance as 1/8 of a grant, and a national equipment bid in scientific notation. Each format must keep formulas correct.The contingency rate 0.05 in I1 already drives **=F2*(1+1). This lesson connects that decimal to 5% on screen — and explores when fractions and scientific notation help on NorthgateBudget.xlsx**.On Budgets, you will format I1, calculate quarter-over-quarter change as a percent, and preview scientific notation on large totals.

Stored value

Percent display

0.05

0.125

12.5%

100%

Quarter-over-Quarter Change

Compare English Q2 to Q1: In L1, type Q2 vs Q1 % . In L2, type =(C2-B2)/B2 and press Enter . With B2=12500 and C2=12800, the result is about 0.024 (2.4% increase). Apply Percentage format with one decimal to L2 . Copy L2 down to L6 to see each department's Q1\toQ2 change. Science Q4 is 19000 vs Q3 18200 . The percent change formula =(E4-D4)/D4 shows roughly 4.4% — easier for Dr. Helen Marsh to scan than raw pound differences.

Scientific Notation

Very large or small numbers use scientific notation : 1.25E+04 means 12,500 . Click F2 (English annual total 50500). Format Cells \to Number \to Scientific with 2 decimal places. The display changes; the value used in SUM does not. Switch back to Currency for the finance report. National research grants might use scientific notation in import files — convert to Number or Currency before school budget meetings.

Common Percent Mistakes

Percent vs typing 5 in the cell

You type 5 in I1 and format as Percentage. The cell shows 500% . Every contingency total is wildly wrong. Type 0.05 for 5%, then apply Percent format — or type 5% and let Excel store 0.05. Return budget columns to Currency before printing for governors.

Practice

Swipe or use the arrows to move between questions.

1 / 2

I1 stores 0.05 and displays 5%. What does =F2*I1 calculate?

Two cells show 1/2 and 1/4 in Fraction format (stored as 0.5 and 0.25). What does =SUM(range) return?