Quiz

  1. 1
    Intermediate

    Assuming that your version of Excel doesn't give you a default option formatting dates in a year-month-day format, how would you format the "Sales up to" column to display the dates as 2018-12-09, 2018-12-11 and 2018-12-10?

  2. 2
    Intermediate

    By default, the values in the Product # column of the table shown below will not have leading zeros. How would you force Excel to show them?

  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?