USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key.
|
|
Editing
|
|
|
Formula
|
|
|
Cells
|
|
|
Worksheet
|
Explanation:
Detailed explanation-1: -Click the cell to the right of a row or below a column. Then, on the HOME tab, click the AutoSum down arrow, click Average, verify the formula if what you want, and press Enter. When I double-click inside the cell, I see it is a formula with the AVERAGE function.
Detailed explanation-2: -=AVERAGE(number1, [number2], …) The function uses the following arguments: Number1 (required argument) – This is the first number of a cell reference or a range for which we want the average.
Detailed explanation-3: -Use the SUBTOTAL function to exclude filtered or hidden rows when calculating a total on the worksheet. You can choose any one of the 11 functions that SUBTOTAL can calculate, such as Sum, Average, Count or Max.
There is 1 question to complete.