Skip to main content
Super TutorResources
Chapter 6 of 14
QuestionsNotesFlashcardsSummaryFormulasQuizConceptsSyllabusPlan
NCERT Solutions

Spreadsheet

CBSE · Class 12 · Accountancy

NCERT Solutions for Spreadsheet — CBSE Class 12 Accountancy.

69 questions90 flashcards5 concepts

Interactive on Super Tutor

Studying Spreadsheet? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for ncert solutions and more.

Try Super Tutor — Free

1,000+ Class 12 students started this chapter today

40 Questions Solved · 3 Sections

20 worked solutions below. Unlock all 40 free in Super Tutor

Q1. MULTIPLE CHOICE QUESTIONS

1The best way to get started in Excel 2007 is to click the _____.Show solution
In Excel 2007, the book says to click the Microsoft Office Button to get started.

Not sure why a step works? check your working in Super Tutor

2Which key combination collapses the ribbon?Show solution
The ribbon is collapsed with Ctrl + F1.

Not sure why a step works? check your working in Super Tutor

3Which view shows margins and the rulers?Show solution
The view that shows margins and the rulers is Page Layout.

Not sure why a step works? check your working in Super Tutor

4As you type a number in a cell, what mode appears in the status bar?Show solution
As you type a number in a cell, Excel shows Enter mode in the status bar.

Not sure why a step works? check your working in Super Tutor

5Where is the address of the active cell displayed?Show solution
The address of the active cell is displayed in the Name Box.

Not sure why a step works? check your working in Super Tutor

6Which command reverses the last action performed in the worksheet?Show solution
The command that reverses the last action is Undo.

Not sure why a step works? check your working in Super Tutor

7When navigating in a workbook, which command is used to move to the beginning of the current row?Show solution
To move to the beginning of the current row, press Home.

Not sure why a step works? check your working in Super Tutor

8Which key when pressed displays the access keys?Show solution
Pressing Alt displays the access keys.

Not sure why a step works? check your working in Super Tutor

9Which command allows you to reverse an Undo command?Show solution
The command that reverses an Undo command is Redo.

Not sure why a step works? check your working in Super Tutor

10Which function results can be displayed in AutoCalculate?Show solution
AutoCalculate can display results such as SUM and AVERAGE.

Not sure why a step works? check your working in Super Tutor

11Which cell alignment is assigned to most values by default?Show solution
By default, most text values are left aligned in a spreadsheet, while numbers are right aligned. The printed options ask about “most values,” but from the chapter’s rule, the correct choice is Left for text entries and Right for numbers. Since the question is taken from the printed MCQ set, the book’s answer key marks b.

Not sure why a step works? check your working in Super Tutor

12Which function automatically totals a column or row of values?Show solution
The function that automatically totals a column or row of values is SUM.

Not sure why a step works? check your working in Super Tutor

13Which mathematical operator is represented by an asterisk (*)?Show solution
An asterisk `*` represents multiplication.

Not sure why a step works? check your working in Super Tutor

14Which step completes an entry and moves the pointer to the cell to the right?Show solution
Pressing Tab completes an entry and moves the pointer to the cell on the right.

Not sure why a step works? check your working in Super Tutor

15How many blank worksheets are shown when a new workbook is created?Show solution
A new workbook shows three blank worksheets by default: Sheet 1, Sheet 2, and Sheet 3.

Not sure why a step works? check your working in Super Tutor

Q2. ANSWER THE FOLLOWINGS QUESTIONS

1Define spreadsheet and its salient features?Show solution
A spreadsheet is a configuration of rows and columns used to record, calculate, and compare numerical or financial data. It is also known as a worksheet.

Its salient features include:
- Data is arranged in rows and columns.
- The intersection of a row and column is a cell.
- Cells can contain values, labels, formulas, or functions.
- Derived values are calculated from arithmetic expressions and functions.
- It supports easy calculations, what-if analysis, and automatic recalculation when input values change.
- Cell references may be relative, absolute, or mixed.
- Excel provides tools for navigation, formatting, functions, and printing.

Not sure why a step works? check your working in Super Tutor

2Write any five advantages using electronic spreadsheet in place of manual spreadsheet.Show solution
Any five advantages of electronic spreadsheet over manual spreadsheet are:
1. Fast calculation — formulas and functions compute results automatically.
2. Easy updating — if input values change, related results are recalculated.
3. Accuracy — reduces manual calculation errors.
4. What-if analysis — different input values can be tried quickly.
5. Easy editing and copying — formulas, formats, and data can be copied to other cells.
6. Better formatting and presentation — data can be displayed neatly with number formats, colours, borders, and charts.

Any five of the above are correct.

Not sure why a step works? check your working in Super Tutor

3Define workbook and worksheet. What is the difference between them?Show solution
A workbook is a file in Excel that contains one or more worksheets.

A worksheet is a single sheet inside the workbook where data is entered and calculations are done.

Difference:
- A workbook is the complete Excel file.
- A worksheet is one page or sheet within that file.
- One workbook can contain multiple worksheets.

Not sure why a step works? check your working in Super Tutor

4Explain active worksheet?Show solution
An active worksheet is the worksheet that is currently selected and available for the user to work on.

Only one worksheet can be active at a time. Its name appears in bold on the sheet tab at the bottom left of the screen.

Not sure why a step works? check your working in Super Tutor

5Using Fill: Series command in Excel write down the steps to fill data from 120,320...2300 in Column A.Show solution
To fill the series 120, 320, ... 2300 in Column A using Fill: Series:

1. Enter 120 in A1.
2. Enter 320 in A2.
3. Select the range A1:A2.
4. On the Home tab, in the Editing group, click Fill and then click Series.
5. In the Series dialog box, choose Columns.
6. Set Step value to the difference between the terms: 320−120=200320-120=200.
7. Set Stop value to 2300.
8. Click OK.

Excel will fill the series by adding 200 each time until 2300 is reached.

Not sure why a step works? check your working in Super Tutor

6Define Data Range, Name Range and How these are created and selected?
7Write down the steps for the use of Custom Lists.
8Explain the purpose of Format, Conditional Formatting and Auto Format.
9What is Wrap Text feature of Excel, Merging of Cells and what will be the cell address of merged cells?
10Explain the purpose of using Print Preview?
11Explain difference between relative reference and absolute reference?
12Discuss IF function and nested IF functions giving example?
13Write down examples for any two financial functions you know with their proper syntax.
14What is the use of PMT function?
15How many ways Data Entry is possible in Spread Sheet?
16Define one-variable Table and Two-variable table. Explain these with examples.
17Define Pivot Table and explain usage?
18What are formulas and how they are created?
19Write down the differences between formula and function?

93. SKILL REVIEW

AYou had started your own online business to sale and find out the sales for the first week is as follows:
BUse a Days360 function to work out how many days are left before your next birthday. Instead of typing out the current date in say cell A2, you can use this inbuilt function:
CCreate an Activity Report (Weekly) for a Sales Representative working in a reputed home appliances manufacturing company. Details recorded should contain Date of Visit, Day of Visit, Name of Shop/Dealer Visited, Address, Phone Number, Name of Product (Dealing), Type of Response (by the Dealer), Demand of Product and Duration Spent (in hrs)..
4Create a worksheet to record sales of home appliances sold by M/s Home Maker Ltd. In the following format:
5The product lists includes Television sets, Refrigerators, Micro wave ovens, Water Coolers, Air Coolers, Geezers and Air conditioners of different Makes (and models). The cost of price of television is ranging from Rs. 10,000 to Rs. 56,000; refrigerator is Rs. 13,000 to Rs. 45,000, micro wave ovens, water coolers, geezers and air coolers are from Rs. 8,000 to Rs. 25,000 and Air Conditioners are from Rs. 18,000 to Rs. 55,000. The shopkeeper sales these products adding 17.25% more on cost price. He provides a discount of 4.35% on total amount if any customer purchases two products on the same date. Enter 30 records of different dates (for a month) and different customers accordingly. Calculate the following:
DCreate a worksheet to keep track of revenue collected and expenses done in conducting tour programs at different tourist places during 2004 to 2008. Format the numeric data in currency format, prepare year wise columns for revenue and expenses for each tourist place and calculate the difference. The calculated difference may be negative, the format of negative balance may be red coloured. Use conditional formatting for higher and lower values of revenue and expenses. Align entire text in centre. The font of tourist place is Arial with 14 point while the font of year is Times Roman with 14 points.

20 more solved questions in Spreadsheet

Every remaining exercise is solved step by step in Super Tutor, plus practice quizzes and flashcards for this chapter. Free to start.

Stuck on a step?

Ask Super Tutor AI to explain any solution on this page in a simpler way — free, 24x7.

Ask a Doubt Free

Frequently Asked Questions

What are the important topics in Spreadsheet for CBSE Class 12 Accountancy?
Spreadsheet covers several key topics that are frequently asked in CBSE Class 12 board exams. Focus on the core concepts listed on this page and practise related questions to build confidence.
How to score full marks in Spreadsheet — CBSE Class 12 Accountancy?
Understand the core concepts first, then work through the 69 practice questions available for this chapter. Revise formulas and definitions regularly, and use flashcards for quick recall before the exam.
Where can I get free NCERT Solutions for Spreadsheet Class 12 Accountancy?
This page has free step-by-step NCERT Solutions for every exercise question in Spreadsheet (CBSE Class 12 Accountancy) — written the way examiners award marks: given, formula, working, answer.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

More resources for Spreadsheet

All 14 chapters — CBSE Class 12 Accountancy NCERT Solutions

For serious students

Get the full Spreadsheet chapter — for free.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan for CBSE Class 12 Accountancy.

Try Super Tutor Free
Try the full chapter — Free