Quiz

  1. 1
    Intermediate

    How do you ensure that Jan 22, 2013 is displayed in the ISO-compliant format (2013-01-22)? (ISO stands for International Organization for Standardization.)

  2. 2
    Intermediate

    Suppose cell B6 contains the number 1234, and you want it to appear as 001234. Which method achieves this?

  3. 3
    Intermediate

    Suppose the value 134567 is in a cell. When this value is formatted with the custom number format ###-###-###, what does it look like?