✓ Board-verified
Accountancy · 2023 · 4 marks
CBSE 2023 · Region 2 · Set 2 · Q33
State the steps to construct Bank Reconciliation Statement in 'Tally' software.ORExplain the following formatting tools : (i) Number formatting (ii) Currency formatting (iii) Percentage formatting (iv) Dates formatting
OR
Explain the following formatting tools : (i) Number formatting (ii) Currency formatting (iii) Percentage formatting (iv) Dates formattingMarking-scheme solution
The following are the steps to construct BRS in Tally.
– Bring up the monthly summary of any Bank book which can be done from
Balance Sheet, Trial Balance, or Display/Account Books/ Bank Books and
selecting a Bank.
– Bring your cursor to the first month and press Enter. This will bring up the
vouchers of the month. Reconcile will be visible on the right, Press F-5.
– Display now becomes an ‘Edit’ screen in Reconciliation mode. The primary
components are A column for the ‘Bankers Date’.
– The ‘Reconciliation’ at the bottom of the screen.
– Balance as per company Books.
– Amount not reflected in Bank.
Balance as per Bank.
Hence the reconciliation is done.
or
Q. (b) Explain the following……………….
Ans.
(b)
Number formatting : It includes adding percent symbols (%), commas (,) decimal
places and currency signs, date, time, scientific values as well as some special
formats to a spreadsheet.
Currency formatting : This is a type of number formatting if we enter financial
value complete with currency sign and two decimal places, Excel assigns
currency format to the cell along with the entry.
Percentage formatting : If we enter a value representing a percentage as a whole
number followed by percentage sign without any decimal places, Excel assigns
to cell the percentage format.
Date formatting : If we enter a date of the built-in Excel number formats, the
program assigns a Date format that follows the pattern of the date.
More from Using Computerised Accounting System
- List the necessary information to be filled by a user on company creation screen. OR What is a Chart/Graph?…2026
- Explain 'Password Security' and 'Data Audit' as security features of Computerised Accounting System. OR What…2024
- Explain the accounting group of 'Current Liabilities'. OR Give the meaning of the terms (i) Labels, and (ii)…2023
- Which of the following menu is used to create a group:2023
- What is the meaning of the term 'Data Audit'?2022
- The encryption of data facilitates: OR How many columns exist on Excel 2006 worksheet?2026
- What are the three categories in which accounting entries can be classified while entering them in vouchers?2026
- Explain 'Password Security' and 'Data A udit' as security features of Computerised Accounting System. OR What…2024
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.