Question 16 Tabular data formatted as can be converted into columns using the Convert Text to Columns Wizard. comma-separated values special characters Question 17 The function is used to calculate the average of a range of cells that meet one criterion. \fQuestion 19 A cell value that is referred to in a formula or function is a(n) cell. argument precedent Question 20 To display records in a table that meet certain criteria, you would apply a Question 21 The standard way that information in a file is encoded for storage is called the (9 software version (D) worksheet template Question 22 4 Points A(n) can be used in or returned by a function to indicate the position of a value in a series. A parameter B serial number C auto number D indexQuestion 23 Atool used with a PivotTable to filter data based on distinct values in columns is a (9 calculated field (D) group Question 24 The function defines the values derived from the cross-tabulation of the categories in an OLAP cube. Question 25 The add-in assists with analyzing and reviewing workbooks to understand their design function and data dependencies