Excel Tables, Data Lists and Conditional Formatting

If I want to create a drop down list of items, where should I go?

• Data - Data validation

• Insert - Objects

• Data - Group

• Insert - Table

It is a formatting style that allows different data analysis.

• Simple formatting

• Conditional formatting

• Layout design

• Data analysis

Table-like format done by adding cell borders allows sorting of data.

• True

• False

Expanding and collapsing groups of data can be done by hiding and unhiding rows or columns.

• True

• False

Grouping and ungrouping data sets are under Insert Ribbon.

• True

• False

Large datasets always involves more than two worksheets.

• True

• False

Collapsing and expanding data groups are represented with what symbols?

• + / +

• * / -

• + / -

• > / <

Which is true?

• Grouping and ungrouping of data cannot be reversed once set.

• Grouping and ungrouping doesn't affect overlapping rows or columns taken under the same command.

• Grouping and ungrouping can be done in specific cells.

• Grouping and ungrouping can be applied in one row or column.

Tables under Insert Ribbon can be created even without data yet.

• True

• False

Tables can only be formatted in the Insert Ribbon.

• True

• False