USING MICROSOFT EXCEL
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: -Answer: Which formatting option(s) can be set for Conditional Formatting rules? D. Any of these formatting options as well as number, border, shading, and font formatting can be set.