Some of the tasks which pivot tables can perform include the following:
B. Group data.
C. Calculate totals from data
D. Reorganize data.
A data analyst can be defined as an expert or professional who is saddled with the responsibility of inspecting, transforming, analyzing, and modelling data with the sole aim of discovering useful information, providing insights, and creating informed conclusions, so as to support decision-making and create a completed report.
In Computer technology and database management, a pivot table can be defined as a data-summarization tool which can be used in data processing by a data analyst to sort, group, reorganize, count, total, and average data.
In this context, we can reasonably infer and logically deduce that end users can use a database tool such as a pivot table to input or display a complete row of information within a specific range or table on Microsoft Excel, without having to scroll horizontally.
Read more on data analyst here: brainly.com/question/27853454
#SPJ1