✓ Board-verified
Accountancy · 2025 · 6 marks
CBSE 2025 · Region 2 · Set 1 · Q34
In case the total cost of a machine less installation charges is greater than ₹ $\displaystyle 2,00,000$, then $\displaystyle 20$% depreciation is charged and if total cost of machine is less than $\displaystyle 5$ $\displaystyle 22.00,000$ then $\displaystyle 10$% depreciation is charged. Write the steps to create 'IF' function using formula tab and dialogue box on a given spreadsheet. Also write the syntax of the result.
Marking-scheme solution
34. Creating If function using the formula Tab and dialogue box.
(i)
Select the cell say D4 where the function is to be introduced
(ii)
Click at the formula tab on the ribbon and click logical option.
(iii)
Select 'IF Function' which will provide function argument dialogue box.
(iv)
Type an appropriate condition in the logical test box.
(v)
In the value if true, box type required value if logical test condition is met.
(vi)
In the value if false, box type value if logical test condition is not met.
(vii)
Click OK, the answer for the condition will be displayed. Copy the function from D4 to all other
cells.
In the formula Box the function will be displayed as.
=If (D4 > $\displaystyle 2,00,000$, $\displaystyle 20$%, $\displaystyle 10$%)
More from Spreadsheet
- Explain the two syntax f2024
- Explain various 'Data tables' used in 'Pivot Table.2024
- QQ Cut.11 v Wrap Text iCaliba'i I. Copy v Paste I u~ v -v A Merge 81 Center v v 1) format Painter E Clipboard…2024
- Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct…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…2025
- iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font…2024
- Give the meaning of the terms Report and Report Wizard'.2022
CBSE Class 12 Accountancy past-paper question from the 2025board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.