Question

An Excel Workbook is a collection of .......
Workbooks
Worksheets
Charts
Worksheets and Charts

Answer 1

Answer:

An Excel workbook is a collection of worksheets.

A worksheet is a collection of rows and column.

A cell is the intersection of rows and columns

An active cell is a cell on which the cursor is placed on. It gets highlighted when the cursor is placed on it.

Charts are used to represent the data written in different workbooks and worksheets in a more precise and user-friendly manner.

It basically helps in representing the data in a graphical interface.

There are also different options which helps in retrieving and arranging the data.

For example:- Sort and Filter option.

The sort option helps in arranging the data in either increasing or decreasing manner.

The filter option helps in retrieving the data on the basis of certain criterias.

There is one more option related to filter - Advanced filter. This helps in filtering the data in multiple fields by using specified criterias.