conditional formatting is a spreadsheet tool that changes how cells appear when values meet a specific condition. data analysts can use conditional formatting to do which of the following tasks? select all that apply. a. to sort data in series of cells into a meaningful order b/ to make cells stand out for more efficient analysis