Explain conditional formatting.
What will be an ideal response?
You can use formatting to highlight important aspects of the data itself. Conditional formatting automatically applies different formats depending on conditions you specify. The formatting is updated if you change any data in the worksheet.
You might also like to view...
Which of the following are rules that ensure a correct recursive function?
a) Each stopping case must perform a correct action (or return the correct value for stopping case) for the condition that invokes it. b) The recursion must make no more than 1000 recursive calls. c) The chain of recursive calls eventually must reach one of the stopping cases. d) The size of the problem solved by the successive recursions must each be larger than the last. e) For cases that involve recursion: If each recursive calls correctly solve the subproblem (or return the correct value for the subproblem) it solve, then the final
Why should a program use type int variables when possible?
a. On many computers, calculations involving type int are faster than calculations with type float. b. Type int values typically require less storage space than type float. c. Operations with type int are always precise, whereas there may be some loss of accuracy when computations involve type float. d.Reasons a, b, and c are all valid. e. None of the above.
Which of the following is NOT a unit value option for the DATEDIF?
A) H B) M C) D D) Y
The Insert Caption button can be found on the ________ tab
A) Design B) Home C) Layout D) References