DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=ISNUMBER(A1)
|
|
|
=$C2
|
|
|
Both of the formulas are valid.
|
|
|
Neither of the formulas are valid.
|
Detailed explanation-1: -They are grouped into three categories: Data Bars are horizontal bars added to each cell, much like a bar graph. Color Scales change the color of each cell based on its value. Each color scale uses a two-or three-color gradient.
Detailed explanation-2: -Conditional formatting for empty and non-empty cells Formula for blanks: =$B2="”-format selected cells / rows if a corresponding cell in Column B is blank. Formula for non-blanks: =$B2<>"”-format selected cells / rows if a corresponding cell in Column B is not blank.
Detailed explanation-3: -On the Home tab, click Conditional Formatting > New Rule. In the Style box, click Classic. Under the Classic box, click to select Format only top or bottom ranked values, and change it to Use a formula to determine which cells to format.
Detailed explanation-4: -1) The correct answer is d. Conditional formatting allows you to set rules that automatically apply formatting, such as highlighting or font changes, to selected cell ranges when the conditions that were set in the rule, are met.