MS Excel Module 4

What is a table in MS Excel?

• A group of cells formatted in a column or row tabular format

• A single cell with data

• A chart representing data

• A formula used for calculations

What is a range of cells in MS Excel?

• A single cell with data

• A group of consecutive or nonconsecutive cells selected in a worksheet

• A chart representing data

• A formula used for calculations

What does the "sort" command do in a range or table?

• It filters data based on criteria.

• It sorts the contents by one or more columns.

• It deletes unwanted data.

• It duplicates the data.

What is the purpose of the "filter" command in a range or table?

• To sort data alphabetically.

• To filter data based on selected criteria.

• To add new data entries.

• To remove all data.

What is a style in the context of formatting cells or tables?

• A combination of preformatted attributes applied to a range of cells or a table

• A single attribute applied to a cell

• A type of font used in a document

• A color scheme for a presentation