FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS 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]

How are a cell’s content and format related?

A	The content and format are the same.
B	They are independent and not related
C	Changing the format affects the content
D	None of the above

Explanation:

Detailed explanation-1: -The content and format of a cell are independent. Changing the format of a cell also affects its content. Changing the content of the cell also affects its format.

Detailed explanation-2: -How are a cell’s content and format related? They are independent and not related. Changing the format affects the content.

Detailed explanation-3: -A relative cell reference in a formula will not change when the formula is copied. By default, when a cell reference is first included in a formula (so that only the column and row reference are included), it is displayed as a relative cell reference.

Detailed explanation-4: -Select the cell or range of cells from which you want to clear formatting. On the Home tab, in the Editing group, click the arrow next to the Clear button. Select the Clear Formats option.

There is 1 question to complete.