BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When working with data sets in Excel, ____ can be used to automatically highlight cells that meet specified requirements.
|
|
averaging
|
|
|
conditional formatting
|
|
|
summing
|
|
|
sorting
|
Explanation:
Detailed explanation-1: -On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.
Detailed explanation-2: -On the Home tab, click Conditional Formatting, point to Highlight Cells Rules, and then click Text that Contains. In the box next to containing, type the text that you want to highlight, and then click OK.
Detailed explanation-3: -The Go To Special Function[1] in Excel allows you to quickly select all cells that meet certain criteria, such as cells containing: Formulas (numbers, text, logicals, errors)
There is 1 question to complete.