Spreadsheet

CBSE Class 12 Accountancy · every board question from this chapter, 2022–2026

• How is navigation conducted from the first to the last cell in a cluster of data in a column by skipping all the cells in…2026
• What will be displayed on the screen when Excel does not recognise the text or formula?2026
• NAME? Error indicates: OR Which of the following statements best describes the purpose of a data vault in an accounting software?2026
• What is the outcome of an arithmetic expression or function called? OR What value of range look up in VLOOKUP ( ) and HLOOKUP ( )…2026
• Which financial function calculates the lump-sum amount for series of future payments?2026
• The PMT function in MS Excel is used to:2026
• How is navigation conducted from the first to the last cell in a cluster of data in a column by skipping all the cells in between?2026
• Which of the following is not contained on formula tab on Excel ribbon?2026
• A1: E2 refers to:2026
• Which financial function calculates the lump-sum amount for series of future payments?2026
• What is the outcome of an arithmetic expression or function called? OR What value of range look up in VLOOKUP ( ) and HLOOKUP ( )…2026
• How is navigation conducted from the first to the last cell in a cluster of data in a column by skipping all the cells in…2026
• NAME? Error indicates: OR Which of the following statements best describes the purpose of a data vault in an accounting software?2026
• A1: E2 refers to:2026
• Which of the following is not contained on formula tab on Excel ribbon?2026
• What will be displayed on the screen when Excel does not recognise the text or formula?2026
• The PMT function in MS Excel is used to:2026
• Which financial function calculates the lump-sum amount for series of future payments?2026
• What will be displayed on the screen when Excel does not recognise the text or formula?2026
• Which of the following is not contained on formula tab on Excel ribbon?2026
• NAME? Error indicates: OR Which of the following statements best describes the purpose of a data vault in an accounting software?2026
• A1: E2 refers to:2026
• The PMT function in MS Excel is used to:2026
• What is the outcome of an arithmetic expression or function called? OR What value of range look up in VLOOKUP ( ) and HLOOKUP ( )…2026
• What is meant by cell reference, absolute cell reference and relative cell reference?2026
• What is meant by cell reference, absolute cell reference and relative cell reference?2026
• What is meant by cell reference, absolute cell reference and relative cell reference?2026
• What are the options available to select 'Minimum' and 'Maximum' type while changing conditional format? OR The computer screen…2026
• What is Text Manipulation Function? Explain its syntax. OR Write the steps to change format of selected chart element.2026
• What are the options available to select 'Minimum' and 'Maximum' type while changing conditional format? OR The computer screen…2026
• What is Text Manipulation Function? Explain its syntax. OR Write the steps to change format of selected chart element.2026
• Give the meaning of the following: (i) Cell reference (ii) Relative cell reference (iii) Absolute cell reference (iv) Mixed cell…2026
• What are the options available to select 'Minimum' and 'Maximum' type while changing conditional format? OR The computer screen…2026
• Give the meaning of the following: (i) Cell reference (ii) Relative cell reference (iii) Absolute cell reference (iv) Mixed cell…2026
• What is Text Manipulation Function? Explain its syntax. OR Write the steps to change format of selected chart element.2026
• Give the meaning of the following: (i) Cell reference (ii) Relative cell reference (iii) Absolute cell reference (iv) Mixed cell…2026
• How will you combine multiple cells into one in MS-Excel? What steps will you follow to reverse the process? Explain.2026
• Which functions can be used as an alternative to the 'IF' function for elaborate tests and why? Explain its various types with…2026
• What is data formatting? What tools are used to format a data? Explain.2026
• SUM (EZE3) will give an error while using spreadsheet. Identify the error and state the various steps to correct this type of…2026
• Using the Formula tab and dialog box, write the formula to create 'I 9 function F on the given spreadsheet, where the total…2026
• Which error occur when a column is not wide enough or a negative date or time is used? State the various steps to correct this…2026
• What is 'I-ILOOKUP'? How it is different from 'VLOOKUP'? Explain its syntax.2026
• What is 'VLOOK'? Explain it with its syntax.2026
• Name the error which will be displayed when a given number is divided by zero e.g. 25/0. State the reasons and the steps to be…2026
• Explain various options available to change the alignment of the text in the cells.2026
• Identify the error which will be displayed on the screen when the value is not available to a function or formula:2025
• How is navigation conducted from first to last cell in a cluster of data in a column by skipping all the cells in between? OR…2025
• How are ranges identified within Excel? OR Two important requirements of an accounting report are:2025
• 'LABELS' in Excel means: OR Which of the following is not contained on formula tab on Excel ribbon?2025
• How are ranges identified within Excel? OR Two important requirements of an accounting report are:2025
• Identify the error which will be displayed on the screen when the value is not available to a function or formula:2025
• MS Excel considers which of the following group of mathematical operations to be of equal importance?2025
• 'LABELS' in Excel means: OR Which of the following is not contained on formula tab on Excel ribbon?2025
• How is navigation conducted from first to last cell in a cluster of data in a column by skipping all the cells in between? OR…2025
• The outcome of an arithmetic expression or function is called:2025
• A cell reference that either holds raw or column constant when the formula or function is copied to another location is known as:2025
• How are ranges identified within Excel? OR Two important requirements of an accounting report are:2025
• How is navigation conducted from first to last cell in a cluster of data in a column by skipping all the cells in between? OR…2025
• MS Excel considers which of the following group of mathematical operations to be of equal importance?2025
• The outcome of an arithmetic expression or function is called:2025
• A cell reference that either holds raw or column constant when the formula or function is copied to another location is known as:2025
• The outcome of an arithmetic expression or function is called:2025
• Identify the error which will be displayed on the screen when the value is not available to a function or formula:2025
• A cell reference that either holds raw or column constant when the formula or function is copied to another location is known as:2025
• MS Excel considers which of the following group of mathematical operations to be of equal importance?2025
• 'LABELS' in Excel means: OR Which of the following is not contained on formula tab on Excel ribbon?2025
• Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
• State the advantages of 'Pivot Table' report.2025
• Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
• Name the error which occurs when Excel doesn't recognize a 'Text' formula. Give any two solutions to correct it.2025
• tate the advantages of 'Pivot Table' report.2025
• State the advantages of 'Pivot Table' report.2025
• What is data formatting? What tools are used to format data? OR Explain 'ROUND function of Excel.2025
• Each and every data from Notepad file can be saved as an Excel data file. This provides a lead that Excel worksheet consists of…2025
• What is data formatting? What tools are used to format data? OR Explain 'ROUND function of Excel.2025
• Each and every data from Notepad file can be saved as an Excel data file. This provides a lead that Excel worksheet consists of…2025
• Each and every data from Notepad file can be saved as an Excel data file. This provides a lead that Excel worksheet consists of…2025
• What is data formatting? What tools are used to format data? OR Explain 'ROUND function of Excel.2025
• Which function can be used as an alternate to the 'IF' function for elaborate test and why? Give the meaning of its types with…2025
• List any six questions which are often asked when a user wants to be benefited by conditional formatting. Also state how colour…2025
• Name the error which occurs when there is some invalid numeric value (e.g. you try to calculate square root of some negative…2025
• Explain the financial function which is used to calculate interest rate per period of an annuity.2025
• Name the error which occurs when the column is not wide enough or a negative date or time is used. How can it be corrected if (i)…2025
• What is meant by 'Pivot Table'? What are its uses?2025
• Which error appears when there is formula or function with 'invalid' numeric value? How can you correct it?2025
• State the steps to import data from a text file.2025
• How can conditional formatting be changed? Explain.2025
• = SUM (B2B3) will give an error while using a spreadsheet. Identify the error and state the steps to correct it.2025
• Name the error which occurs when a given number is divided by zero; e.g. 7/0. What are the reasons for this error? How can this…2025
• In case the total cost of a machine less installation charges is greater than ₹ 2,00,000, then 20% depreciation is charged and if…2025
• State the steps to be followed to copy or import the data into required cells of Excel worksheet.2025
• How are 'absolute cell references' and 'mixed reference' identified in Excel 'P2024
• Excel considers which of the following group of mathematical operations of equal importance 9 OR How many rows are available in…2024
• How is navigation conducted from the first to the last filled cells of clusters when moving one cell at a time in a row?2024
• "A value or function or an arithmetic expression is recorded in2024
• Which Date and Time function returns value of today's date with time? OR What is the outcome of an arithmetic expression or…2024
• How is navigation conducted from the first to the last filled cells of clusters when moving one cell at a time in a row?2024
• Which Date and Time function returns value of today's date with time? OR What is the outcome of an arithmetic expression or…2024
• "A value or function or an arithmetic expression is recorded in2024
• How are 'absolute cell references' and 'mixed reference' identified in Excel 'P2024
• Excel considers which of the following group of mathematical operations of equal importance 9 OR How many rows are available in…2024
• How is navigation conducted from the first to the last filled cells of clusters when moving one cell at a time in a row?2024
• "A value or function or an arithmetic expression is recorded in2024
• How are 'absolute cell references' and 'mixed reference' identified in Excel 'P2024
• Excel considers which of the following group of mathematical operations of equal importance 9 OR How many rows are available in…2024
• Which Date and Time function returns value of today's date with time? OR What is the outcome of an arithmetic expression or…2024
• Explain various 'Data tables' used in 'Pivot Table.2024
• How can a DIV/0! error be corrected?2024
• How to use 'Mark Common Formula Error' in Excel? Explain.2024
• How can a DIV/0! error be corrected?2024
• State the parameters of Excel's PMT function. What is the use of this function?2024
• How to use 'Mark Common Formula Error' in Excel? Explain.2024
• How to use 'Mark Common Formula Error' in Excel? Explain.2024
• State the parameters of Excel's 'PMT' function. What is the use of this function? Explain.2024
• How can a DIV/0! error be corrected?2024
• Explain various 'Data tables' used in 'Pivot Table.2024
• State the parameters of Excel's PMT function. What is the use of this function?2024
• State the pa rameters of Excel's PMT function. What is the use of this function?2024
• Explain various 'Data tables' used in 'Pivot Table.2024
• Explain the two syntax f2024
• 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 re Font I Alignment…2024
• iCalibfi 11 'A A' I ® ' Wrap Text % Copy v Paste I Ll v; E Merge 8z Center v 'X Format Painter Clipboard Font B19 v 1v a»r'-r--<»…2024
• Home Calibri 'e Wrap Text 425 Copy Paste I u~. Y v Merge 81 Center v v 4 liormat Painter Clipboard Vi Font Alignment 5; 813 0 /'x…2024
• Explain the two syntax forms of 'Lookup' function.2024
• Write the steps to create 'I ' f function using formula tab and dialogue box on a given spreadsheet where the total income less…2024
• Write the steps to create f 'I ' function using formula tab and dialogue box on a given spreadsheet where the total income less…2024
• xi E < ~ C" = 34. HOME INSERT PAGE LAYOUT FORMUIAS DATA REVIEW "EW X Tell me what yo " Q QQ cm Ciiii U 11 v K A' EE lvf- §WflPT¢¢…2024
• .a. H; m Calibri mr 'H v A A' I §» Wrap Text......... P " ~~ %€0py ' aste I U v v E Merge 8£ Center v v ~§ Format Painter…2024
• Explain the two syntax forms of 'Lookup' function.2024
• Write the steps to create 'I ' f function using formula tab and dialogue box on a given spreadsheet where the total income less…2024
• xi E 5' <- ~ = 34. HOME INSERT PAGE LAVOUT FORMUIAS DATA REVIEW VIEW X Tell me what yo "E 3£,cur Calibri Y 11 A A' E E l I W '…2024
• ....... 31, Cut Calibri Tb 1 v A' A' ®' ' §"'Wrap Text Paste Copy ' I c - A' cl-nslll -» ¢-n.nu q-» B U., v 1.ua-n-n rin au- Q-…2024
• xi E <- = 34. HOME INSERT PAGE LAVOUT FORMUIAS DATA REVIEW VIEW X Tell me what yo M QQ cm Calibii 11 A A' -; l I V/' §WrapTat Ela…2024
• @- 5.11-... Calibri 'g 11 v A A' v it' Wrap Text......... " %€0py v Paste I U v v v A v E Merge 8£ Center v v Format Painter…2024
• Which of these is not a argument of the IF function? OR How many blank worksheets are shown when a new workbook is created?2023
• How many logical values can be entered into a logical function?2023
• A is identified by combination of letter and number corresponding to particular location within the spreadsheet. OR Entries…2023
• The outcome of an arithmetic expression or function is called:2023
• Correct DIV/0! Error appears when2023
• HOW many worksheets are available to a user by default while working on a workbook?2023
• What is the outcome of an arithmetic expression or function called:2023
• The outcome of an arithmetic expression or function is called:2023
• Which of these is not a argument of the IF function? OR How many blank worksheets are shown when a new workbook is created?2023
• A is identified by combination of letter and number corresponding to particular location within the spreadsheet. OR Entries…2023
• Which of the following is not the advantage of Pivot table?2023
• A 'value' or 'function' or an 'arithm e ic expression' is recorded in2023
• Which of these is not a argument of the IF function? OR How many blank worksheets are shown when a new workbook is created?2023
• Which of the following is not the advantage of Pivot table?2023
• The ranges are identified within Excel by:2023
• Which of the following is not the advantage of Pivot table?2023
• The outcome of an arithmetic expression or function is called:2023
• A is identified by combination of letter and number corresponding to particular location within the spreadsheet. OR Entries…2023
• Which error occurs when Excel does not recognise 'text' in the formula? State the steps to correct it.2023
• Explain 'COUNTIF' function. 31.2023
• Explain - 'Number formatting', 'Percentages' and 'Dates' as data formatting tools.2023
• Give the meaning of 'Cell reference'. Differentiate between 'Relative Cell reference' and 'Absolute cell reference.'2023
• What is a 'Pivot table'? State any three of its advantages. OR List eight uses of Accounting Software.2023
• What is data formatting? What tools are used to format a given data? Explain. OR List eight uses of accounting software.2023
• What is data formatting? What tools are used to format a given data? Explain. OR List eight uses of accounting software.2023
• What is meant by 'conditional formatting'? State its any three advantages. OR State any four salient features of 'Computerised…2023
• What is data formatting? What tools are used to format a given data? Explain. OR List eight uses of accounting software.2023
• Name and explain the financial function which will be used to verify the total interest on a loan between any two periods.2023
• Name the financial function which returns accrued interest on a bond with 5% coupon rate and where issue and settlement date of…2023
• What is meant by 'Present Value' of an investment? Explain the financial function which helps in its calculation.2023
• Name and explain the financial function which will be used to verify the total interest on a loan between any two periods.2023
• Name the error which appears when the cell reference is not valid. State how this error can be corrected.2023
• Name the function which is often used to calculate the payment for mortgage loans that have fixed rate of interest. Also explain…2023
• Name the financial function which returns accrued interest on a bond with 5% coupon rate and where issue and settlement date of…2023
• Name the financial function which returns accrued interest on a bond with 5% coupon rate and where issue and settlement date of…2023
• Name and explain the financial function which will be used to verify the total interest on a loan between any two periods.2023
• Name the error which appears when the cell reference is not valid. State how this error can be corrected.2023
• What is meant by 'Present Value' of an invest ment? Explain the financial function which helps in its calculation.2023
• Name the function which is often used to calculate the payment for mortgage loans that have fixed rate of interest. Also explain…2023
• What is meant by 'Present Value' of an investment? Explain the financial function which helps in its calculation.2023
• Name the error which appears when the cell reference is not valid. State how this error can be corrected.2023
• Name the function which is often used to calculate the payment for mortgage loans that have fixed rate of interest. Also explain…2023
• Give the meaning of the terms Report and Report Wizard'.2022
• Give the meaning of the terms 'Repolt' and 'Report Wizard2022
• Give the meaning of the terms 'Rep01t and 'Report Wizard.2022
• Explain, how to calculate 'total earnings'. OR What is the use of 'NPV' function ) Write and explain its syntax.2022
• What is meant by 'Data Validation'? Give two examples, when cell will give error, if the value does not meet the condition. OR…2022
• Explain the formula to calculate 'Total Earnings. OR Explain the terms 'Data Audit and 'Data Vault'.2022

Answers come from CBSE’s own marking schemes. How we source them.