NIOS Class 12 Accountancy Chapter 35 Electronic Spread Sheet Solutions English Medium As Per New Syllabus. to each chapter is provided in the list so that you can easily browse throughout different chapters NIOS Class 12 Accountancy Chapter 35 Electronic Spread Sheet Notes and select need one. NIOS Class 12 Accountancy Chapter 35 Electronic Spread Sheet Question Answers Download PDF. NIOS Study Material of Class 12 Accountancy Paper Code: 320.
NIOS Class 12 Accountancy Chapter 35 Electronic Spread Sheet
Also, you can read the NIOS book online in these sections Solutions by Expert Teachers as per National Institute of Open Schooling (NIOS) Book guidelines. These solutions are part of NIOS All Subject Solutions. Here we have given NIOS Class 12 Accountancy Solutions English Medium, NIOS Senior Secondary Course Accountancy Notes in English Medium for All Chapter, You can practice these here.
Electronic Spread Sheet
Chapter: 35
| Module – 7: Application of Computers in Financial Accounting |
INTEXT QUESTIONS 35.1
Fill in the blanks with suitable word/words:
(i) A spreadsheet is seen as ___________ structured by number of rows and columns.
Ans: Grid.
(ii) Each element of spreadsheet is a point of ___________ between a particular row and column.
Ans: Intersection.
(iii) Spreadsheet allows the user to view and concentrate on a limited number of ___________ and ___________ to work with.
Ans: Rows, Columns.
(iv) Spreadsheet is supported by a large number of ___________ for difficulty and lengthy calculations in fraction of seconds.
Ans: Functions.
(v) A saved spreadsheet can be opened for additions and ___________.
Ans: Alterations.
INTEXT QUESTIONS 35.2
Fill in the blanks with suitable word/words:
(i) A cell is where the row and column ___________.
Ans: Intersect.
(ii) The cell pointer is moved from its current location to another by using __________ keys.
Ans: Arrow.
(iii) The short-cut-menu is __________ tool for the operations that are __________ performed on selected cells.
Ans: Handy, Commonly.
(iv) To enter data in an active __________, click in the __________ where you want the data and start typing.
Ans: Cell, Cell.
(v) Click and __________ the cursor to select many cells in a range.
Ans: Drag.
INTEXT QUESTIONS 35.3
I. Name the following functions available in Excel Sheet:
(i) Adds all cells in the argument.
Ans: Sum.
(ii) Finds the number of cells that contain a numerical value within a range of the argument.
Ans: Count.
(iii) Calculates the average of the cells in the argument.
Ans: Average.
(iv) Finds the maximum value.
Ans: Max.
(v) Finds the minimum value.
Ans: Min.
II. Fill in the blanks with suitable word/words :
(i) Calling cells by just their column and row labels is called _________.
Ans: Cell Referencing.
(ii) ___________ formatting includes adding, percent, comma, decimal, currency, date, time, scientific values etc.
Ans: Number.
INTEXT QUESTIONS 35.4
Fill in the blanks with suitable word/words:
(i) We can split data of one cell into two or more cells by utilizing the convert Text to
__________.
Ans: Columns Wizard.
(ii) ___________ fonts in Excel will allow you to emphasize titles and headings.
Ans: Modifying.
(iii) To merge cells, select the cells you want to merge and click the _________ button on Alignment group of the tab.
Ans: Merge & Center.
INTEXT QUESTIONS 35.5
Fill in the blanks with suitable word/words:
(i) The __________ format changes the appearance of a cell range based on given criteria.
Ans: Conditional.
(ii) A _________ table is a way to present information in a report format.
Ans: Pivot.
(iii) A __________ table is a range of cells that shows the results of substituting different values in one or more formulas.
Ans: Data.
(iv) Two variable data table uses only one formula with two lists of __________ values.
Ans: Input.
| TERMINAL EXERCISE |
1. What is Electronic Spread Sheet?
Ans: Electronic Spreadsheet is a combination of rows and columns. Visually, it appears like a matrix having rows and columns. It is also known as a worksheet. It is a computer program that allows the user to add, process and analyse data. It is mainly used for calculations and comparison of numerical or financial data to generate useful information for reporting.
2. What is the basic requirement for any business enterprise for using electronic spread sheet?
Ans: The basic requirement for any business enterprise for using electronic spreadsheet is the availability of a Computerised Accounting System (CAS).
It includes the following components:
(i) Procedure: A logical sequence of actions to perform a task.
(ii) Data: Raw facts used as input for business applications.
(iii) People: Users who operate the system.
(iv) Hardware: Computer and its associated devices.
(v) Software: System and application software used for processing data.
3. Name the functions included in ‘Function Library’.
Ans: The functions included in Function Library are:
(i) AutoSum.
(ii) Recently Used.
(iii) Financial.
(iv) Logical.
(v) Text.
(vi) Date & Time.
(vii) Math & Trig.
4. What is conditional formatting?
Ans: Conditional formatting is a feature in spreadsheet which helps to highlight important cells or range of cells based on certain conditions. It changes the appearance of a cell automatically when the specified condition is satisfied. It is used to emphasize unusual values, visualize data using colour scales, data bars and icons.
5. Give the meanings of workbook & worksheet.
Ans: Workbook: A workbook is a collection of worksheets. It is a multipage document in Excel which stores and manages related worksheets.
Worksheet: A worksheet is a single page in a workbook consisting of rows and columns used for entering and processing data.
6. Explain the features of Spreadsheet.
Ans: The main features of spreadsheet are:
(i) Grid: Spreadsheet is structured in the form of rows and columns.
(ii) Element: Each cell is an intersection of row and column and stores data or formula.
(iii) Lens View: It allows focusing on a limited part of worksheet at a time.
(iv) Functions: Provides built-in functions for complex calculations.
(v) Formatting: Enables formatting of text and data for better presentation.
(vi) Save, Print and Export: Allows saving, printing and sharing data easily.
7. Explain the worksheet operations in excel sheet.
Ans: The worksheet operations in Excel include:
(i) Movement of cell pointer using arrow keys.
(ii) Use of short-cut menu for quick operations.
(iii) Entering data into cells or formula bar.
(iv) Selecting multiple cells, rows or columns.
(v) Copying and pasting data.
(vi) Cutting and pasting data.
(vii) Undo and redo actions.
(viii) Auto fill feature to fill data automatically.
(ix) Inserting and deleting rows, columns and cells.
(x) Managing text and importing data from external sources.
8. Define workbook & worksheet. What is the difference between them?
Ans: Workbook: A workbook is a collection of worksheets and acts as a container of multiple sheets.
Worksheet: A worksheet is a single page consisting of rows and columns where data is entered.
Difference:
| Basis | Workbook | Worksheet |
| Meaning | Collection of worksheets | Single sheet of data |
| Nature | Multi-page document | Single page |
| Function | Holds multiple worksheets | Used for data entry and calculations |
9. What do you mean by active worksheet?
Ans: Active worksheet is the worksheet that is currently in use or selected by the user. At a time, only one worksheet can be active, and all operations like data entry and editing are performed on that worksheet.
10. Explain the procedure of managing Text in excel.
Ans: Managing text in Excel involves entering and importing data:
(i) Data can be entered directly into cells or through formula bar.
(ii) Data can also be imported from external sources such as text files.
(iii) Text files like .txt or .csv are used for importing data.
(iv) Data is arranged in rows and columns separated by commas.
(v) The file is imported using “From Text” option in Data tab.
(vi) Data is automatically arranged into rows and columns in worksheet.
11. Explain worksheet operations available in Excel Sheet.
Ans: Worksheet operations include:
(i) Movement of cell pointer.
(ii) Entering data into cells.
(iii) Selecting cells, rows and columns.
(iv) Copy, cut and paste operations.
(v) Auto fill for series data.
(vi) Insert and delete rows, columns and cells.
(vii) Undo and redo actions.
(viii) Managing and importing data.
12. Give Categories of Data formatting andexplain them.
Ans: Data formatting is mainly categorized as:
(i) Number Formatting: Includes percentage, decimal, currency, date, time, etc.
(ii) Text and General Formatting: Includes splitting data, modifying fonts and alignment.
(iii) Cell Formatting: Includes borders, colours, alignment and merging of cells.
Buy Now