In Excel cell function and references are helpful to better understand Excel spreadsheets. Type something into the selected cell, then press Enter on your keyboard. The content will appear In most cases, you will need to select multiple cells before using the fill handle to help Excel determine the...3. For example, on the North sheet, change the value of cell B2 to $1000 and delete row 4. 4. Go to the other two worksheets and you'll see that these worksheets have been edited as well. 5. To ungroup, right click one of the sheet tabs and click Ungroup Sheets or click any sheet tab outside the group. For example, the sheet tab of Sheet4. The AVERAGEIFS function syntax has the following arguments: Average_range Required. One or more cells to average, including numbers or names, arrays Unlike the range and criteria arguments in the AVERAGEIF function, in AVERAGEIFS each criteria_range must be the same size and shape...Jul 26, 2019 · Click into cell D2, and type “Average of completed sales,” so we don’t forget what we’re calculating. Then, in G2, type “=AVERAGEIF(“: Select cells B2 through B11 for the range (this is the group of cells that we’ll apply the criteria to).