FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
A
left parenthesis
B
right bracket
C
right parenthesis
D
left bracket
Explanation: 

Detailed explanation-1: -When you select two or more cells that have numeric data, Excel for the web automatically summarizes that data and shows the average, count, and sum on the status bar.

Detailed explanation-2: -The AVERAGE function requires that the argument be included within parenthesis following the function name. The equal sign (=) precedes a formula. The most common error when entering a formula is to reference the wrong cell in the formula. The range automatically selected by Excel is always correct.

Detailed explanation-3: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.

Detailed explanation-4: -To calculate a COUNT, AVERAGE, MIN, or MAX, choose the Home tab; click the down arrow next to the AutoSum button; then click Count, Average, Min, or Max. When accessed through AutoSum SUM, COUNT, AVERAGE, MIN, and MAX all work the same.

There is 1 question to complete.
Previous
Next