Q:

What is a CVS file?

A:

Short for "comma-separated values," CSV is a common file format type that utilizes a text-based system that places commas to separate the values in each field of data. The CSV format is often used to transfer information from one software application to another.

Most spreadsheet and database programs, including Microsoft Excel and Microsoft Access, are able to open this type of file. A CSV file is also a commonly supported file format among several widely known accounting programs, including Quickbooks and Microsoft Money. Most software applications that can open these files are also able to export data in a CSV format.


Is this answer helpful?

Similar Questions

  • Q:

    What is a CSV file?

    A:

    A CSV (comma-separated values) file stores data tables in text format. This file uses an indicator, called a delimiter, to separate column names, row names and cell values in a data table.

    Full Answer >
    Filed Under:
  • Q:

    What is "data integrity" in Microsoft Access?

    A:

    In Microsoft Access, data integrity refers to the values that are used and stored in the data structures of an application. To ensure data integrity the application must be able to control every data-using process so that the information being produced continues to be correct.

    Full Answer >
    Filed Under:
  • Q:

    How do you calculate interquartile range in Excel?

    A:

    To calculate the interquartile range in Microsoft Excel, first enter the values for which you want to calculate the interquartile range in one single column. To calculate the first quartile, select a blank cell, and enter "=QUARTILE(cell 1:cell 2,1)," where cell 1 and cell 2 are the actual cell labels in Excel. To calculate the third quartile, select another blank cell, and enter "=QUARTILE(cell 1:cell 2, 3)." Subtract the value from the first quartile from the third quartile to get your interquartile range.

    Full Answer >
    Filed Under:
  • Q:

    What is the percentage increase formula in an Excel spreadsheet?

    A:

    While Microsoft Excel does not have a built-in function to find percentage increase between values, a user simply needs to enter the formula "=(B-A)/ABS(A)," where B is the baseline value, and A is the new value. The function "ABS" displays the result in its absolute form, or without a sign.

    Full Answer >
    Filed Under:

Explore