Why is it important to clean date-related data?
What will be an ideal response?
Dates that are stored in Excel as text will not be able to be used in calculations or in objects like PivotTables. Dates stored as text can be converted to numeric values using date functions or wizards such as Convert Text to Columns in some circumstances.
Computer Science & Information Technology
You might also like to view...
The FREQUENCY function in Excel is a(n) ________ function that creates a frequency distribution that calculates how often values occur within a bin
Fill in the blank(s) with correct word
Computer Science & Information Technology
WSUS configuration data must be configured to use SQL Server Express.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology