You will see a drop-down list of the functions, select Average. Now the Average value is found. The other option is to select the cell you want to Average, then go to Auto-Sum in the Editing Group ...

But what if you need to ignore certain values? For example, in Microsoft Excel ... it’s a simple matter of using the standard AVERAGE() function. We’re going to use the Remove Duplicates ...