1) One might loosely definestructureddataby these characteristics:

1. The first row of the data is a header row.

2. Each row is a record, describing a single item or transaction.

3. Each column holds the same kind of data. For example, all dates or all decimal numbers.

4. The range the data occupies has no entirely blank rows or entirely blank columns.

True/ False

2) Structured data in Excel is suitable for analyses such as sorting, subtotaling, filtering, and grouping.

True/False

3) Indexeddata in Excel is structured data with an additional field in each record that holds an identifying value unique to that record.

For example, index values for the records in an Excel data set might be sequential numbers.

True/ False

4) Excel includes functions designed to check a cell's value and return TRUE or FALSE depending on the result of the check.

For example: TheISBLANKfunction returns TRUE if the function finds an empty cell; otherwise it returns FALSE.

Another example: TheISERRORfunction returns TRUE if the function finds an Excel error message* in the cell; otherwise it returns FALSE.

* Error message examples:#DIV/0!,#NULL!,#NUM!,#REF!, or#VALUE!

True/ False

5) These Excel functions return either TRUE or FALSE:

ISBLANK, ISERR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT

True/ False

6) The formula below returns this text:Problem with calculation.

=IFERROR(A1/A12, "Problem with calculation.")

Where:

Cell A1 contains the value 100 and Cell A12 contains the value 0.

The formula =A1/A12 returns this Excel error message:#DIV/0!

True/ False

7) The entries below are Excel error messages:

#VALUE!

#REF!

#DIV/0!

#NUM!

#NAME?

#NULL!

#N/A!(also spelled#N/A)

True/ False