Question

1. Define the terms of MS-Excel: Data Table, Field, Record
2. What is Sorting is MS-Excel?

Answer 1

Answer:

A data table is a range of cells in which you can change values in some in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function with different loan amounts and interest rates to calculate the affordable amount on a home mortgage loan.

In Microsoft Excel, a cell is a rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet. Vertical columns are numbered with alphabetic values such as A, B, C. Horizontal rows are numbered with numeric values such as 1, 2, 3.

In database terminology, a record holds all the information or data about one specific object in the database. In Excel, each cell in a worksheet contains one item of information or value

2.. Sorting in excel is nothing but arranging data stored in excel according to your requirement. It can be done by depending on the value type stored in cells..

Answer 2

1.RECORD

In database terminology, a record holds all the information or data about one specific object in the database. In Excel, each cell in a worksheet contains one item of information or value.

FIELDS

Each item of information in a database record, such as a telephone number or street number, is referred to as a field. In Excel, the individual cells of a worksheet serve as fields, since each cell can contain a single piece of information about an object.

TABLES

A database table is composed of records and fields that hold data. Tables are also called datasheets. Each table in a database holds data about a different, but related, subject.

DATA

The workbook refers to an Excel spreadsheet file. The workbook houses all of the data that you have entered and allows you to sort or calculate the results.

2.Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest.