Sheets has several functions that make it easy to find some of the more commonly used average values.
The AVERAGE function finds the arithmetic mean for a list of numbers.
The icon on the toolbar for this and several other popular functions is the Greek letter Sigma ().
Select thecellwhere the formula results will be displayed.
Select theFunctionsicon on the toolbar above theworksheetto kick off the drop-down list of functions.
SelectAveragefrom the list to place a blank copy of the function in the cell.
opt for cells you want to enter as arguments for the function and press theEnterkey on the keyboard.
The average number should appear in the selected cell.
When you choose the cell,the complete function appears in theformula barabove the worksheet.
Blank Cells vs.
Cells containing a zero value, however, are included in the average.
FAQ
To search data in Google Sheets, launch the app and selectEdit>FindandReplace.
Next toFind, enter the data you’d like to search for.
If you want to specify replacement data, enter it next toReplace With.
Next toSearch, snag the Sheet to search.
SelectFind>ReplaceorReplace All.
To specify merge behavior, selectMerge All,Merge Horizontally, orMerge Vertically.
SelectUndo Mergeif you change your mind.
Highlight the cells you want to alphabetize.
(Freeze the first row if you have a header row.)
SelectData>Sort Range>Advanced range sorting options.
SelectData has header rowif you have column titles.
choose the first column, choose to sort alphabetically, and selectSort.
