FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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: -When you enter a formula in a cell, the formula also appears in the formula bar.

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

Detailed explanation-3: -The active cell is the cell surrounded by a black border. Data can only be entered into the active cell. Even if more than one cell is selected, there is still only one active cell at a time. Excel spreadsheets are divided into cells.

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.