NIOS Class 10 Data Entry Operation Chapter 6 Basics of Spreadsheet

NIOS Class 10 Data Entry Operation Chapter 6 Basics of Spreadsheet Solutions to each chapter is provided in the list so that you can easily browse through different chapters NIOS Class 10 Data Entry Operation Chapter 6 Basics of Spreadsheet and select need one. NIOS Class 10 Data Entry Operation Chapter 6 Basics of Spreadsheet Question Answers Download PDF. NIOS Study Material of Class 10 Data Entry Operation Notes Paper 229.

NIOS Class 10 Data Entry Operation Chapter 6 Basics of Spreadsheet

Join Telegram channel

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 10 Data Entry Operation Chapter 6 Basics of Spreadsheet, NIOS Secondary Course Data Entry Operation Solutions for All Chapters, You can practice these here.

Basics of Spreadsheet

Chapter: 6


1. Write True or False for the following statements.

(a) To modify a preset header or footer click the custom header and custom footer buttons.

Ans: True.

(b) Autofill helps you to add the contents of a cluster of adjacent cells.

Ans: False.

(c) Charts features help you in presenting a graphical representation of data.

Ans: True.

(d) Click the edit button to print the worksheet.

Ans: False.

(e) Pivot table allows you to perform data analysis.

Ans: True.

2. Fill in the blanks.

(a) When the active document is protected the command name changes to ________________ workbook.

Ans: Unprotect.

(b) Select ______________from the menu bar to view how the worksheet will look when printed.

Ans: Print preview.

(c) _________ toolbar allows to draw a number of geometrical shapes, arrows, flow chart elements etc.

Ans: Autoshapes.

(d) Check ______________ if you want the gridlines dividing the cells to be printed on the page.

Ans: Gridlines.


1. What are the main features of MS Excel?

Ans: The main features of MS Excel are: 

(a) Results-oriented user interface The new results-oriented user interface makes it easy for you to work in Microsoft Office Excel. Commands and features that were often buried in complex menus and toolbars are now easier to find on task-oriented tabs that contain logical groups of commands and features. Many dialog boxes are replaced with drop-down galleries that display the available options, and descriptive tooltips or sample previews are provided to help you choose the right option.

(b) More rows and columns, and other new limits The grid of Excel 2007 is having 1,048,576 rows and 16,384 columns. Thus it provides a user with 1,500% more rows and, 300% more columns than the Microsoft Office Excel 2003. The last column in Excel 2007, is XFD instead of IV in Excel 2003. The number of cell references per cell is increased to limit the maximum available memory. The formatting types are also increased to an unlimited number in the same workbook as compared to the earlier limit of four thousand types of formatting.

(c) Office themes and Excel styles By the help of a specific style, in Excel 2007, the data can be quickly formatted in the worksheet by the help of a theme. You and share themes across other releases of Office 2007 e.g. Word 2007, Powerpoint 2007.

(i) Applying a theme: Themes are used to make great-looking documents. A theme is defined as a predefined set of colours, lines, fonts and fills effects. Theme can be applied to a specific item like tables, charts or it can also be applied to entire Workbook.

(ii) Using styles: A predefined theme based format is called style. It can be applied to change the appearance of Excel charts, tables, PivotTables, diagrams or shapes. Styles can be customised to meet user specific requirements. It is important to note that in case of charts you cannot create your own styles, but you can use existing styles.

(d) Rich conditional formatting It is easy to use and apply conditional formats. A few tricks are required to observe the relationships in data, which helps to great extent for analysis purposes.

2. Differentiate between a worksheet and a workbook?


(i) A Worksheet is basically a single-page spreadsheet containing information.(i) A workbook is a file that contains multiple spreadsheets. A worksheet contains a matrix of rectangular cells, organised in a form of rows and columns. 
(ii) worksheet is a single tab within the workbook that is used for organising and analysing data.(ii) A workbook contains one or more worksheets, consisting of related information.
(iii) A collection of worksheets is referred to as a workbook (spreadsheets).(iii)  a workbook is a large container that holds multiple worksheets.

3. What are the different types of data that can be entered into worksheet cells?

Ans: The three types of data you can enter into a cell are data, labels and formulas. Data – values, usually numbers but can be letters or a combination of both. Labels – headings and descriptions to make the spreadsheet easier to understand. Formulas – calculations that update automatically if referenced data changes.

4. Explain three different ways you protect your workbook.

Ans: Three different ways you protect your workbook.

(i) Click the Microsoft Office Button, and then click Save As.

(ii) Click Tools, and then click General Options.

(iii) Do one or both of the following:

(a) If you want reviewers to enter a password before they can view the workbook, type a password in the Password to open box.

(b) If you want reviewers to enter a password before they can save changes to the workbook, type a password in the Password to modify box.

5. How do you find a single number or name you want in a large worksheet containing thousands of numbers and names? Is it possible to replace a name or number with some other name or number? How? 

Ans: To find a single number or name in a large worksheet, you can use the “Find” function. In Excel, you can access this by pressing Ctrl + F on your keyboard. A small window will pop up where you can type the name or number you’re looking for.

Yes, it is possible to replace a name or number with some other name or number through various methods, including encryption, encoding, or simply by substituting one value for another.

(i) Encryption: Encryption is a method of converting data into a coded form to prevent unauthorised access. One common type of encryption is symmetric encryption, where the same key is used for both encryption and decryption. Another type is asymmetric encryption, where different keys are used for encryption and decryption. By encrypting data, the original name or number is replaced with an encrypted version that appears as a random sequence of characters or numbers.

(ii) Encoding: Encoding involves converting data into a specific format or representation according to a set of rules or standards. For example, ASCII (American Standard Code for Information Interchange) and Unicode are encoding schemes used to represent text characters using numeric values. Similarly, Base 64 encoding converts binary data into ASCII characters for transmission over text-based systems. Encoding can be reversible or irreversible, depending on the encoding scheme used.

(iii) Substitution: substitution to use something or someone instead of another thing or person: substitute something for something You can substitute oil for butter (= use oil instead of butter) in this recipe. In cryptography, substitution ciphers are techniques where each letter in the plaintext is replaced by another letter based on a fixed system. For example, in a Caesar cipher, each letter in the plaintext is shifted a certain number of positions down the alphabet. Substitution can also be used to replace numbers with other numbers or names with other names.

6. How do you select a single cell, a single column, a single row, a cluster of cells, and an entire worksheet?

Ans: (i) Select single cell column are: 

(a) To select a single cell, left-click on it.

(b) To select a range of cells, click and hold the left mouse button and drag through the range you want to select.

(c) To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse.

(ii) Single column: Single Column allows the fields in a section to be listed one below the other. Double Column. Double Column allows the fields in a section to be displayed in two columns.

(iii) A single row A single-row subquery is used when the outer query’s results are based on a single, unknown value. Although this query type is formally called “single-row,” the name implies that the query returns multiple columns-but only one row of results.

(iv) A cluster of cells: In a computer system, a cluster is a group of servers and other resources that act like a single system and enable high availability, load balancing and parallel processing. These systems can range from a two-node system of two personal computers (PCs) to a supercomputer that has a cluster architecture.

(v) Entire worksheet: Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

7. Difference between Move cells and Copy cells.

Ans: When you move or copy a cell, Excel moves or copies the entire cell, including formulas and their resulting values, cell formats, and comments.

(i) Select the cells that you want to move or copy.

(ii) On the Home tab, in the Clipboard group, doone of the following:

(a) To move cells, click Cut. Keyboard shortcut for CTRL+X.

(b) To copy cells, click Copy. Keyboard shortcut or CTRL+C.

(iii) Select the upper-left cell of the paste area.

(iv) On the Home tab, in the Clipboard group, click Paste . Or CTRL+V.

8. What are the different features available in Page setting command?

Ans: The different features available in Page setting command are: 

(i) Themes Group: The Themes Group is available in the top left corner. 

(ii) Margins: Margins are one of the commonly used page settings. 

(iii) Orientation: The Orientation option will provide the option of page orientation. 

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top