Solved

If the Conditions Are Not Mutually Exclusive, Resulting in More

Question 34

Multiple Choice

If the conditions are not mutually exclusive, resulting in more than one specified condition being TRUE, the formatting ____.


A) of the last specified rule overrides those of earlier rules
B) of the first specified rule overrides those of later rules
C) defaults back to match the rest of the spreadsheet
D) is applied by merging the formatting of all of the conditions

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q29: In the formula =(1+2)/3<>10, Excel evaluates _

Q30: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING

Q31: Note that a(n) _ construct always has

Q32: You can apply conditional formatting to cells

Q33: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Chloe is

Q35: Excel _ empty cells in a range

Q36: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING

Q37: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING

Q38: Relational expressions _.<br>A) are not case sensitive<br>B)

Q39: When laying out a complex IF function,