Page 89 - Computer - 6

DATE AND TIME FORMATTING 1
You can change the format of date or time values as per your choice.

To change date and time format:
1. Select the cell containing the date or time.
2. On the Home tab, click the dialog box launcher button in
the Number group.
The Format Cells dialog box opens.

3. On the Number tab, in the Category list, select the Date or Time option.
The various formats for date or time are displayed under the
Type list box.
4. Select the desired format
5. Click the OK button. 3 4

Excel applies the selected date or time format to
the selected cells.

5

Database Subject Enrichment

73-year old Japanese Tatsuo Horiuchi decided to try digital art using Microsoft Excel
spreadsheet because he found other graphics software can be quite expensive. He
used the Autoshape feature of Excel to create his highly detailed works of art. His
creative use of Excel earned him first prize at the Excel Autoshape Art Contest in 2006.
He has made numerous digital artworks since then, gaining attention not only in Japan
but also in different parts of the world.

Post-Processing  



 Excel provides options to enter, edit, and format data in a worksheet.
 The AutoComplete feature in Excel 2019 allows you to quickly enter similar text in different
cells of the same column.
 The AutoFill feature in Excel 2019 allows you to quickly fill a range of cells with a series of data
without typing each value one by one.
 Excel provides options to create and manage custom lists of data values that can be inserted in
a worksheet using the AutoFill feature.
 You can edit the contents of a cell partially or completely.
 New cells, rows, and columns can be added to a worksheet to add more content.

 Excel lets you change the height and width of cells to view content properly.

87