1. In range of data, data in the cells are not structured, they can be specified by the block of cells. Also the name of the table is manually done and not automatically set. In the structured range data, data is organized in columns and fields. The names of the table can be automatically set, and table headers can also be automatically set with drop down boxes.
2. A field is represented by the columns and a records are represented by rows. A field is single unit of data that is unique within each entry or row whereas a record is a row that contains distinctive data in each of the fields.
3. Freeze Panes buttons are used to freeze rows and columns in the excel sheet. It is helpful when working with a large sheet so that you keep the headers visible as …show more content…
5. The sort command is used to give commands to data. It is used to sort data in two different ways, either by ascending or descending order. Sorting also arranges data in a sequential manner. The subtotal command on the other hand is used to place subtotal values for a specific portion of the worksheet.

QUICK CHECK 5.3
1. In excel, if a table contains large data, it is difficult to understand. A Pivot Table is used to organize and summarize the data in different categories so that it becomes easy to find and understand. A Pivot table groups data into categories and then uses functions such as COUNT, SUM, AVERAGE, MAX and MIN to summarize the data.
2. You add fields to a Pivot Table from the Pivot Table Fields pane. From the exercise, fields can be added in the following steps.
• In the pivot table fields pane, drag the week # from the upper section to the rows area in the lower section.
• In the pivot table fields pane, click amount.
• Click Trn Date
• Click Segment
• All the fields will be