Spreadsheet Cross tab VS. Pivot

A cross tab displays data in a row-and-column matrix, with a horizontal dimension and a vertical dimension.
The values of each dimension often belong to the same class. For example, the values of the horizontal dimension are all "years".

In a cross tab spreadsheet, each value cell is an intersection of a row field from the vertical dimension and a column field from the horizontal dimension.
For example, as shown in the cross tab spreadsheet below, the value "17.1" is described by "black female" from
the vertical dimension and "2005" from the horizontal dimension.

A pivot spreadsheet is a broader definition similar to cross tab.
While the cross tab assumes there is only one horizontal dimension and all the values belong to that dimension,
pivot assumes there might exist one or more horizontal dimensions.
For example, the spreadsheet shown below is a pivot spreadsheet where each dimension
(dimension gender or dimension age) can be "pivoted" into a new column in the spreadsheet table.

Example Questions.

Example 1.

Please look at the spreadsheets on the left and try to answer the following questions.

Is this spreadsheet a cross tab?
Answer: No
Is this spreadsheet a pivot spreadsheet?
Answer: No

Example 2.
Please look at the spreadsheets on the left and try to answer the following questions.

Is this spreadsheet a cross tab?
Answer: Yes

Is this spreadsheet a pivot spreadsheet?
Answer: Yes

Example 3.
Please look at the spreadsheets on the left and try to answer the following questions.

Is this spreadsheet a cross tab?
Answer: No

Is this spreadsheet a pivot spreadsheet?
Answer: Yes