Question

What are the options available to select 'Minimum' and 'Maximum' type while changing conditional format? OR The computer screen shows correct a…

Accepted Answer

Following options are available to select ‘Minimum’ and ‘Maximum’ type while changing conditional formatting. • Format lowest and highest values select lowest value and highest value. In this case we do not enter minimum and maximum values. • Format a number, date or time value select number and then enter a minimum and maximum value. • Format a percentage select percent and then enter a minimum and maximum value. Here the valid values are from (0) to (100). • Format a percentile and then enter a minimum and maximum value valid percentiles are from (0) to (100). • Format a formula result select formula and then enter a minimum and maximum value OR Q. (b) The computer screen shows ……… Ans. Reason: (i) Using a cell reference to a blank cell or to a cell that contains zero as a divisor → Solutions • Change the cell reference to another cell • Enter a value other than zero in the cell used as a divisor • Enter the value N/A into the cell referenced as the divisor which changes the result of the formula to N/A from Div/O! to denote that the divisor value is not available. • Prevent the error value from displaying by using the IF worksheet function.

Marking-scheme solution

More from Spreadsheet