Bird
Raised Fist0
Excelspreadsheet~5 mins

Number formats (currency, percentage, date) in Excel - Cheat Sheet & Quick Revision

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Recall & Review
beginner
What does the Currency number format do in Excel?
The Currency format shows numbers with a currency symbol (like $, €, £) and two decimal places by default. It helps show money values clearly.
Click to reveal answer
beginner
How does the Percentage format change a number in Excel?
The Percentage format multiplies the number by 100 and adds a % sign. For example, 0.25 becomes 25%. It shows parts of a whole.
Click to reveal answer
beginner
What happens when you apply a Date format to a number in Excel?
Excel treats dates as numbers counting days from a start date. The Date format shows that number as a calendar date like 4/27/2024 or April 27, 2024.
Click to reveal answer
intermediate
How can you change the number of decimal places shown in a Currency format?
You can set decimal places in the Format Cells dialog under Currency options. More decimals show more detail, fewer decimals round the number.
Click to reveal answer
intermediate
Why is it important to use number formats instead of typing symbols manually?
Number formats keep data consistent and allow calculations. Typing symbols manually makes numbers text, which can break formulas and sorting.
Click to reveal answer
What symbol does Excel add automatically when you apply the Currency format?
AA date format like MM/DD/YYYY
BA percent sign (%)
CA currency symbol like $ or €
DNo symbol is added
If a cell contains 0.5 and you apply Percentage format, what will the cell show?
A50%
B0.5
C5%
D500%
Which format should you use to display a date like April 27, 2024?
ACurrency
BPercentage
CGeneral
DDate
What happens if you type a dollar sign manually before a number without formatting the cell?
AExcel treats it as a number with currency format
BExcel treats it as text, which may break calculations
CExcel automatically formats it as currency
DExcel removes the dollar sign
How can you show more decimal places in a currency formatted cell?
AUse the Increase Decimal button or Format Cells options
BType decimals manually
CChange the cell font size
DChange the cell background color
Explain how the Percentage number format works in Excel and give an example.
Think about how parts of a whole are shown.
You got /3 concepts.
    Describe why using built-in number formats is better than typing symbols manually in Excel.
    Consider what happens when Excel treats data as text.
    You got /4 concepts.

      Practice

      (1/5)
      1. Which number format should you use in Excel to display a value as money with a dollar sign and two decimal places?
      easy
      A. Date format
      B. Percentage format
      C. Currency format
      D. General format

      Solution

      1. Step 1: Understand the purpose of currency format

        Currency format shows numbers as money, adding a currency symbol like $ and two decimals.

      2. Step 2: Identify the correct format for money

        Since money needs a dollar sign and decimals, currency format is the right choice.

      3. Final Answer:

        Currency format -> Option C

      4. Quick Check:

        Money = Currency format [OK]
      Hint: Money values use currency format with $ and decimals [OK]
      Common Mistakes:
      • Choosing percentage format for money
      • Using general format which shows plain numbers
      • Selecting date format for currency
      2. Which of these is the correct way to format a cell as a percentage in Excel?
      easy
      A. Right-click cell -> Format Cells -> Date -> Percentage
      B. Right-click cell -> Format Cells -> General -> Percentage
      C. Right-click cell -> Format Cells -> Currency -> Percentage
      D. Right-click cell -> Format Cells -> Number -> Percentage

      Solution

      1. Step 1: Locate the Format Cells dialog

        Right-clicking a cell and choosing Format Cells opens options to change number formats.

      2. Step 2: Select the Percentage category under Number tab

        Percentage is found under Number, not Date or Currency or General.

      3. Final Answer:

        Right-click cell -> Format Cells -> Number -> Percentage -> Option D

      4. Quick Check:

        Percentage format is under Number tab [OK]
      Hint: Percentage format is under Number tab in Format Cells [OK]
      Common Mistakes:
      • Choosing Date or Currency tab for percentage
      • Selecting General which does not format as percentage
      • Confusing tabs in Format Cells dialog
      3. If cell A1 contains the number 0.25 and is formatted as Percentage, what will the cell display?
      medium
      A. 25%
      B. 2500%
      C. 0.25
      D. 0.025

      Solution

      1. Step 1: Understand percentage formatting

        Percentage format multiplies the number by 100 and adds % sign for display.

      2. Step 2: Calculate display for 0.25

        0.25 x 100 = 25, so it shows as 25%.

      3. Final Answer:

        25% -> Option A

      4. Quick Check:

        0.25 as percentage = 25% [OK]
      Hint: Percentage format multiplies value by 100 and adds % [OK]
      Common Mistakes:
      • Showing raw decimal instead of percentage
      • Multiplying by 10000 instead of 100
      • Confusing decimal and percentage display
      4. You entered the date 12/31/2023 in a cell, but it shows as 44926. What is the likely cause and how to fix it?
      medium
      A. Cell is formatted as General; change format to Date
      B. Date entered incorrectly; retype as text
      C. Cell is formatted as Currency; change format to Percentage
      D. Excel does not support dates; use text format

      Solution

      1. Step 1: Recognize date serial number display

        Excel stores dates as numbers; 44926 is the serial for 12/31/2023.

      2. Step 2: Fix by changing cell format to Date

        Changing format from General to Date shows the date properly.

      3. Final Answer:

        Cell is formatted as General; change format to Date -> Option A

      4. Quick Check:

        Date serial number shows if format is General [OK]
      Hint: Change cell format to Date to show calendar dates [OK]
      Common Mistakes:
      • Retyping date as text instead of formatting
      • Changing to percentage or currency format
      • Thinking Excel can't show dates
      5. You have a sales report with amounts in column A and a commission rate of 5% in cell B1. Which formula and format combination correctly calculates and displays the commission as currency?
      hard
      A. =A2*B1 with Percentage format on the formula cell
      B. =A2*$B$1 with Currency format on the formula cell
      C. =A2+B1 with Currency format on the formula cell
      D. =A2*$B$1 with General format on the formula cell

      Solution

      1. Step 1: Use absolute reference for commission rate

        Using $B$1 locks the commission rate when copying formula down.

      2. Step 2: Multiply sales amount by commission rate and format as currency

        Formula =A2*$B$1 calculates commission; Currency format shows money properly.

      3. Final Answer:

        =A2*$B$1 with Currency format on the formula cell -> Option B

      4. Quick Check:

        Correct formula + Currency format = commission in dollars [OK]
      Hint: Use $ for fixed cell and Currency format for money display [OK]
      Common Mistakes:
      • Not using $ to fix commission cell
      • Using addition instead of multiplication
      • Formatting result as Percentage or General