Computerised financial accounting class 12 cbse Questions: Section – B in Accounting Board Exams – It’s optional.
Chapter-1
- Why the computerisation of Financial Accounting is required and why is it useful
- What is coding? Why codification is required for an Accounting System?
- What are the salient features of Computerised Accounting Software?
- What are the phases in an accounting cycle?
- Write differences between data and information with examples?
- Explain various types of coding methods and the situations where each coding method is best suited?
- Define the term transaction and elaborate with the help of examples how the transaction will be shown in chart of accounts by hierarchical grouping?
- What is a chart of accounts? How is it arranged?
- What is meant by Revenue and Expenses?
- What are the limitations of CAS?
- What are the advantages of CAS?
- What is encryption and how is it helpful in CAS?
Chapter-2
- Define spreadsheet and its salient features?
- Write any five advantages using electronic spreadsheet in place of manual spreadsheet.
- Define workbook and worksheet. What is the difference between them?
- Explain active worksheet?
- Using Fill: Series command in Excel write down the steps to fill data from 120,320…..2300 in Column A.
- Define Data Range, Name Range and How these are created and selected?
- Write down the steps for the use of Custom Lists.
- Explain the purpose of Format, Conditional Formatting and Auto Format.
- What is Wrap Text feature of Excel, Merging of Cells and what will be the cell address of merged cells?
- Explain the purpose of using Print Preview?
- Explain difference between relative reference and absolute reference?
- Discuss IF function and nested IF functions giving example?
- Write down examples for any two financial functions you know with their proper syntax.
- What is the use of PMT function?
- How many ways Data Entry is possible in Spread Sheet?
- Define one-variable Table and Two-variable table. Explain these with examples.
- Define Pivot Table and explain usage?
- What are formulas and how they are created?
- Write down the differences between formula and function?
Chapter-3
- What is the meaning of PV?
- State the usage of FV?
- What is the purpose of DB function?
- If an investment of Rs. 1,000 is made today, ascertain its Future Value (FV) after 2 years if the rate of interest is taken as 10%?
- If a sum of Rs. 1000 is likely to be earned after 3 years, calculate its present value (PV).
- What is the difference between WDV method and SLM method of depreciation
- Describe the two basic methods of depreciation. What functions of Excel are used for computation of depreciation?
- Explain the importance of absolute and relative addresses. What is the basis of using relative address and absolute address?
Chapter-4
- Define charts, graphs and how they are useful in business decisions?
- Write down the usage and purpose of column chart, pie chart and line chart.
- Describe about data series, legend, and data labels??
- Describe use of Excel for preparation of chart.
- Differentiate between pie charts, line charts and column charts respectively?
- Described the steps to move, resizing and reposition a chart.
- What does percentage in chart represent and how it being calculated by the software?
- What are the differences between
- Area, XY chart and doughnut
- 2-D Charts and 3-D Charts
- What is pie chart and what are percentage values means in pie chart?
- Different types of charts which can be prepared using Excel?
Chapter-5
- How do you begin using Tally accounting software?
- What menu option is available on the gateway of Tally screen?
- What is the use of Button bar in Tally accounting package?
- What are the contents of Balance Sheet in Tally?
- What do you mean by Account Info?
- Explain the process of Company Creation?
- “Report generating is not a easy task” Is this statement true or false Explain?
- Describe the various contents of Profit and Loss Account?
- Describe the process of creating a Group company and how would you Display and Alter a Group account?
- Describe Tally 9.0 and what are the new features of 9.0, and explain the various items of the Tally screen?
Chapter-6
- What do you understand by DBMS. Give names of two communally available DBMS software’s?
- Differentiate between ‘Desktop database’ and ‘Server database’. List the criteria that may help you in selecting appropriate database?
- With suitable example illustrate the meaning of ‘attributes’ as applied to database?
- Why do we seek to split up in formation into different tables rather than confine it to a single table?
- What do you understand by terms ‘key field’ , ‘primary key’ and ‘secondary key’ in a database?
- List the conventions that you will follow, while naming different fields of a table?
- What are the uses of ‘query’ object in Access program?
- What do you understand by ‘Form’ object in Access and how are they useful?
- What is the purpose of ‘report’ object in Access program?
- What do you understand by database? What are the ways in which data is stored and queried in an Access database?
- What are the advantages of Access over Excel?
- Describe in brief the function of ‘Table’, ‘Query’, ‘Form’ and ‘Report’ object of Access program?