FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following happens when you enter the formula =G15 into a cell?
A
Excel recalculates all formulas in the worksheet
B
Excel assigns the sum of the values in the previous 15 cells to the active cell
C
Excel assigns the value in cell G15 to the active cell
D
Nothing; =G15 is an invalid formula
Explanation: 

Detailed explanation-1: -The correct answer is Current cell.

Detailed explanation-2: -When you enter a formula in a cell, the formula also appears in the formula bar.

Detailed explanation-3: -The Excel AVERAGE function will calculate the average (arithmetic mean) for a specified set of numbers in an Excel spreadsheet.

Detailed explanation-4: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.

There is 1 question to complete.