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 cell references is read as “cell A1 THROUGH D6?”

A	A1, D6
B	A1!D6
C	A1:D6
D	A1&D6

Explanation:

Detailed explanation-1: -A reference is a cell’s address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.

Detailed explanation-2: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Detailed explanation-3: -Observe that when you copy and paste formulas, they are pasted relative to the position they are copied from. This is because of the way the formula treats the cell references. The cell coordinates in the formula are known as cell references. Two commonly used cell references are – Absolute and Relative.

There is 1 question to complete.