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.


Related Questions in computer science category