DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -You can apply formatting before or after you enter data in a cell or range. What does format painter do? You can “paint” or copy a cell’s format into other cells. This similar to using copy and paste, but instead of copying cell contents, it copies only the cell’s format.
Detailed explanation-2: -Formatting a number does not affect the actual value (in the cell) but just changes how the value is displayed. Any formulas will always use the actual value and not the value that is displayed. The actual value stored in a cell is the value used in your formulas and is not the value that is displayed.
Detailed explanation-3: -Apply conditional formatting to text Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to. On the Home tab, click Conditional Formatting. Point to Highlight Cells Rules, and then click Text that Contains. Type the text that you want to highlight, and then click OK.