FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A worksheet is an electronic grid in which you can perform numeric calculations. Blank workbook is a type of Excel template you can choose. The active cell is always highlighted in yellow. A scatter chart is used for showing relative importance of values over a period of time.

Detailed explanation-2: -A spreadsheet is a configuration of rows and columns. Rows are horizontal vectors while columns are vertical vectors. A spreadsheet is also known as a worksheet. It is used to record, calculate and compare numerical or financial data.

Detailed explanation-3: -A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook. A workbook can contain many worksheeks. Think of it as a book.

Detailed explanation-4: -A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Detailed explanation-5: -The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.