The AVERAGE, MAXIMUM, MINIMUM functions

Uploaded time: October 9, 2021 Difficulty: Primary

The AVERAGE, MAXIMUM, MINIMUM functions

The AVERAGE, MAXIMUM, MINIMUM functions

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

When we analyze the sales performance of staff, the AVERAGE, MAXIMUM, and MINIMUM functions can help a lot.

 

The worksheet on the screen lists the personal sales performance for each staff.

If we want to get the average sales, we can use the AVERAGE function. Click cell C22, and enter the formula =AVERAGE(). Then, input E3-G21 within the parentheses, and press Enter to get the result.

1 (1).gif


If we want to know the highest sales, we can use the MAX function. Click cell E22, and enter the formula =MAX(). Then, input E3-G21 within the parentheses, and press Enter to get the result.

1 (2).gif


If we want to know the lowest sales, we can use the MIN function. Click cell G22, and enter the formula =MIN(). Then, input E3-G21 within the parentheses, and press Enter on the keyboard.

1 (3).gif


Did you get it?

 

WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables, and more. Includes advanced animation, slide transitions, and support for video, images, audio, and even Flash.