✓ Board-verified
Accountancy · 2026 · 4 marks
CBSE 2026 · Region 4 · Set 1 · Q33
What are the options available to select 'Minimum' and 'Maximum' type while changing conditional format?
What are the options available to select 'Minimum' and 'Maximum' type while changing conditional format ?
OR
The computer screen shows correct a #DIV/$\displaystyle 0$! Error when a number is divided by zero in the calculations. Give the reason for showing this error (except the one given here). Also state the possible solutions to correct this error.
Marking-scheme solution
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 ($\displaystyle 0$) to ($\displaystyle 100$).
• Format a percentile and then enter a minimum and maximum value valid percentiles are
from ($\displaystyle 0$) to ($\displaystyle 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.
More from Spreadsheet
- Explain the two syntax forms of 'Lookup' function.2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- Using the worksheet find out the error and its reason for the given 'VLOOKUP' syntax. (i) = VLOOKUP (B1, B2: E8, 2, 0) (ii) = SQRT (VLOOKUP (B5, B8:…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
- What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
- From the given 'VLOOKUP' syntax find out the error and its reason using the worksheet. (i) = VLOOKUP (B5, C3: F10, 2, 0) (ii) = SQRT (VLOOKUP (B3,…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2026 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.