# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### 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.
 A Editing B Formula C Cells D 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.