Page 28 - Computer - 8

Knowledge Discovery Subject Enrichment

You can interchange the rows, columns, and summarised values in a pivot table to look at the data from
a different perspective. Drag the desired column names from one pane to another to change the layout
of the pivot table.

Database Subject Enrichment

The Transpose feature in Excel lets you transpose data arranged in rows and columns so that the rows
become columns, and vice-versa. This lets you view the data from a different perspective. To transpose
the data:
1. Select the range of data you want to rearrange, including any row or
column labels, and press Ctrl + C.
2. Choose a new location in the worksheet where
you want to paste the transposed data.
3. On the Home tab, click the Paste down arrow in
the Clipboard group, and select the Transpose
option.

Post-Processing   


 A database is an organised collection of structured information, or data, typically stored
electronically in a computer system.
 Tables in Excel is a simple way to organise data.

 You can automatically calculate subtotals and grand totals in a list of data for a column by using
the Subtotal command.
 Data Validation is a feature in Excel which is used to restrict the type of values that can be
entered in a cell and can provide the user with instructions for entering information in a cell.

 Goal Seek is a feature in Excel that determines what value you should enter in an input cell to
get the desired result in a formula cell.
 A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet.

 A Pivot Table is a powerful tool to calculate, summarise, and analyse data that lets you see
comparisons, patterns, and trends in your data.

26