Calculate the highest number in the Sales column using the MAX formula.
computer science
Description
EXERCISE FOR FREQUENCY FUNCTION
Find and download the Sales.xlsx data file in the Resources tab.
- Calculate the highest number in the Sales column using the MAX formula.
- Calculate the lowest number in the Sales column using the MIN formula.
- Use the Frequency function to do the frequency distribution for both arrays.
- Apply Data Bars formatting to the Sales column (you choose the color you prefer).
- Save your work using first name last name sales.xlsx.
