DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the argument in this function? =AVERAGE(F3:F26)
|
|
F3
|
|
|
F26
|
|
|
F3:F26
|
|
|
=AVERAGE
|
Explanation:
Detailed explanation-1: -The argument in this function is F3:F26. The correct option is D.
Detailed explanation-2: -To average values in cells and ranges of cells that aren’t adjacent, type an equals sign (a formula always starts with an equals sign), AVERAGE, open parenthesis, hold down the Ctrl key, click the desired cells and ranges of cells, and press Enter.
Detailed explanation-3: -The most common reason for an Excel formula not calculating is that you have inadvertently activated the Show Formulas mode in a worksheet. To get the formula to display the calculated result, just turn off the Show Formulas mode by doing one of the following: Pressing the Ctrl + ‘ shortcut, or.
There is 1 question to complete.