The answer is d)none of these answers is correct.
In Excel, Frequency Distribution is used to show how the data is spread out. This can be accomplished with the help of a Histogram, which provides a clear picture of how the data is distributed. We need Data Analysis Toolpak to create Frequency Distribution in Excel, which we can activate from the Add-Ins option in the Developer menu tab. Once activated, select the Histogram from Data Analysis and the data to be projected.
Using the pivot table to create graphical data is one of the simplest ways to make an excel frequency distribution.
Thus, Excel's pivotTable report function can be used to construct a frequency distribution for quantitative data.
To learn more about frequency distribution refer here
https://brainly.com/question/28569100
#SPJ4
