✓ Board-verified
Accountancy · 2023 · 4 marks
CBSE 2023 · Region 2 · Set 1 · Q33
What is meant by 'conditional formatting' ? State its any three advantages.ORState any four salient features of 'Computerised Accounting System'. (CAS).
OR
State any four salient features of 'Computerised Accounting System'. (CAS).Marking-scheme solution
A conditional format changes the appearance of a cell range based on a condition.
If the condition is true, the cell range is formatted based on that condition. If the
condition.
condition is false, the cell range is not formatted based on that
The advantages of conditional formatting (any three). It is helpful :
(i)
–To find out exceptions for the given period.
(ii)
–To find Trend.
(iii)
–To fix the responsibility for the results.
(iv)
–To find age distribution of employees.
(v)
–To find peak performance.
(vi)
–To highlight unusual values and visualise data by using data bar, colour scale,
icons, etc.
Or
Q. (b) State any four salient…………………………….
Ans. Any four
(i)
CAS may be designed to automate and integrate all the business operations which
inturn helps to simplify all the business processes easily.
(ii)
It provides sufficient time to plan, increases data accessibility and
enhances user satisfaction which will lead to greater transparency and
control over business operations.
(iii)
It provides user-definable templates for speedy and accurate data entry
of the transactions.
(iv)
It enables business to be able to change the volume of data processing
in tune with the change in the size of operation hence facilitates
scalability.
(v)
It makes sure that the generalised critical financial information is
accurate, controlled and secure which makes it reliable.
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 2023board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.