Question

10.The technique to summarise given data
by transferring rows to columns is
called
*​

Answer 1

Answer:

'Excel' is the right answer

Answer 2

The technique to summarise given data by transferring rows to column is called pivoting.

Definition of pivoting;

Pivoting- the input data is included in the ordered ranges and values is called as array.

Features of Pivoting;

• Pivoting includes the large amount of data. The functions is to identifying the ranges, sums, averages.
• In the spreadsheet the columns and rows are arranged.
• The four main components of pivot are as follows;

1. Columns
2. Rows
3. Values
4. Filters

• The specific tool to use is Excel for creating the pivot tables helping to store the data.

Hence, Pivot is responsible for transferring the rows to columns in a easy way.