FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
In the cell reference \$A5, what part of the cell reference would remain unchanged?
 A Column A B Row 5 C All cells in Column A D All cells in Row 5
Explanation:

Detailed explanation-1: -Absolute Cell Reference: An absolute cell reference is one that does not change when it is copied.

Detailed explanation-2: -Mathematical operators Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents. All formulas in Excel must begin with an equals sign (=).

Detailed explanation-3: -A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Detailed explanation-4: -Using functions AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.

There is 1 question to complete.