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.

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.

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.

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.