DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
The content and format are the same.
|
|
They are independent and not related
|
|
Changing the format affects the content
|
|
None of the above
|
Detailed explanation-1: -How are a cell’s content and format related? They are independent and not related. Changing the format affects the content.
Detailed explanation-2: -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. What are the pieces of information that describe the appearance of a cell’s 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 cells with the Excel Style. Right-click the applied style in Home > Cell Styles. Select Modify > Format to change what you want.