NIOS Class 12 Data Entry Operations Chapter 6 Basics Of Spreadsheet

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

NIOS Class 12 Data Entry Operations Chapter 6 Basics Of Spreadsheet

Join Telegram channel

Follow us:

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 Data Entry Operations Chapter 6 Basics Of Spreadsheet, NIOS Senior Secondary Course Data Entry Operations Solutions for All Chapter, You can practice these here.

Basics Of Spreadsheet

Chapter: 6

DATA ENTRY OPERATIONS

INTEXT QUESTIONS

1. Write True or False for the following statements:

(a) To modify a present 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 _____________ work book.

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.

TERMINAL QUESTIONS

1. What are the main features of M.S. Excel?

Ans. (i) Results-oriented user interface: The new results-oriented user interface makes it easy for we 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 we choose the right options.

(ii) 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 6,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 reference per cell is increased to limit as maximum available memory. The formatting types are also increased to unlimited number in the same workbook as compared to the earlier limit of four thousand types of formatting.

(iii) 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. We can share themes across other releases of Office 2007 e.g. Word 2007, Power point 2007.

(iv) 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.

Important data trends and exceptions can be easily observed by the help of implementation and management of multiple conditional formatting rules which apply rich visual formatting in the form of data bars, gradient colors and icon sets to data that meets those rules.

(v) Improved sorting and filtering: Enhanced filtering and sorting techniques of Excel can be used to arrange worksheet data more quickly to find the desired answers. In Excel 2007 we can sort data by color and by more than three levels.

We can also filter data by color or by dates, display more than 1000 items in the Autofilter drop-down list, select multiple items to filter and filter data in Pivot Tables.

2. Differentiate between a worksheet and a workbook?

Ans. Excel allows we to create worksheets much like paper ledgers that can perform automatic calculations. Each Excel file is a work book that can hold many worksheets. The Worksheet is a grid of columns (designated by letters) and rows (designated by numbers). The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet.

A worksheet is a single spread sheet page and a workbook is a collection of all the worksheet in a single file. A workbook contains worksheet in the same way that a book contains pages. A workbook consist of one or more worksheets.

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

Ans. Cells can contain text, numbers or mathematical formulas.

4. Explain three different ways you protect your workbook.

Ans. Work Book Protection: Set a password for a 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.

(iv) If you don’t want content reviewers to accidentally modify the file, select the Read-only recommended check box. When opening the file, reviewers will be asked whether or not they want to open the file as read-only.

(v) Click OK.

(vi) When prompted, retype our passwords to confirm them and then click OK.

(vii) Click Save.

(viii) If prompted, click Yes to replace the existing workbook.

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 rename a worksheet:

(i) To rename a worksheet follow the steps as.

(ii) Right click on the worksheet tab which we want to rename.

(iii) Select rename from the Pop Up menu.

(iv) Type new name for the Worksheet (computer in our example).

Yes it is possible.

We may want to located a number or text that is already typed in type worksheet. This is done through Home Tab → Find. We can also located our data and replace with new data with Home Tab → Find → Replace.

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

Ans. (i) Select the cell or the range range: Two or more cells on a sheet. The cells in a range can be adjacent or non adjacent.) of cells where we want to insert the new blank cells. Select the same number of cells as we want to insert. For example, to insert five blank cells, we need to select five cells.

(ii) To insert a single row, select the row or a cell in the row above which you want to insert the new row. For example, to insert a new row above row 5, click a cell in row 5.

(iii) To insert a single column, select the column or a cell in the column immediately to the right of where we want to insert the new column. For want to insert the new column. For example, to insert a new column to the left of column B, click a cell in column B.

7. Difference between Move cells and Copy cells.

Ans. When we 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 we want to move or copy.

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

(a) To move cells, click Cut. Keyboard shortcut or 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. Page setup Select File → Page Setup from the menu bar to format the page, set margins and add headers and footers.

(i) Page: The page option allows we to set the paper size, orientation of the data, scaling of the arca, print quality, etc. Select the Orientation under the Page tab in the Page Setup window to make the page Landscape or Portrait. The size of the worksheet on the page can also be formatted using Scaling. To force a worksheet to print only one page wide so that all the columns appear on the same page, select Fit to 1 page (s) wide.

(ii) Margins: Change the top, bottom, left and right margins by selecting Margins from the page setup group of age Layout Tab. Enter values in the header and footer fields to indicate how far from the edge of the page this text should appear. Check the boxes for centering horizontally or vertically on the page.

(iii) Add or change the header or footer text: For worksheets, we can work with headers and footers in Page Layout view. For other sheet types, such as chart sheets or for embedded charts, we can work with headers and footers in the Page Setup dialog box.

9. Explain the different features available in Print command?

Ans. The steps to see the print view of document:

(i) Select Print from Office Button.

(ii) Select print.

(iii) Click Print Preview.

10. Define the following:

(a) Navigating worksheet.

Ans. Navigating worksheet: We can advance through our worksheet by rows with the vertical scrollbar or by columns with the horizontal scrollbar. When we click and drag the thumb tab on the scrollbar, a Screen Tip will appear alongside the bar identifying the row or column to which our view is advancing.

(b) Editing data.

Ans. Editing Data: Editing our Excel worksheet data is very easy. 

We can edit our data by any of the following ways:

(i) Select the cell containing data to be edited. Press F2. Use Backspace key and erase the wrong entry. Retype the correct entry.

(ii) Select the cell and simply retype the correct entry.

(iii) If we want only to clear the contents of the cell, select the cell and press Delete key.

(iv) To bring back the previous entry, either click on undo button on standard Toolbar or select Edit → Undo command or use keyboard shortcuts CTRL+Z.

(c) Insert cells and rows.

Ans. Insert cells and rows: On the Home tab, in the Cells group, click the arrow next to Insert, and then click Insert cells and sheet rows.

(d) Drag and drop.

Ans. Drag and Drop: It will help we to reposition the data and text by simply dragging the data with the help of mouse.

(e) Workbook protection.

Ans. Worksheet Protection: 

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

(ii) Click Tools and then click General Options.

OTHER IMPORTANT QUESTIONS AND ANSWERS

Q. 1. Define the term Auto Fill.

Ans. Auto Fill: Allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers, and repeated text. Auto fill can also be used to copy functions. You can also alter text and numbers with this feature.

Q. 2. Write short notes on the Cell Reference.

Ans. Cell Reference: Each worksheet contains a number of columns and rows. Each call of the worksheet has a unique reference. For example, C13, refers to the cell containing column number C and row number 13. It is called call reference.

Q.3. How can we move or copy worksheet to another location in a workbook?

Ans. To move a cell or range of cells, point to the border of the selection. When the pointer becomes a move pointer, drag the cell or range of cells to another location.

To copy a cell or range of cells, hold down CTRL while you point to the border of the selection. When the pointer becomes a copy pointer, drag the cell or range of cells to another location.

Q. 4. Write True/False for the following statements:

(a) By default taskbar is visible at the top of the screen.

Ans. False.

(b) RAM is volatile in nature.

Ans. True.

(c) Internet is a network of networks.

Ans. True.

(d) By default the tab stops are set at 0.3 inch intervals.

Ans. False.

(e) Assembly language is also known as machine language.

Ans. False.

(f) The shortcut key for undo is Ctrl+Z.

Ans. True.

(g) When you download files you send files from your computer to the internet.

Ans. False.

(h) The extension of Power Point file is PPT.

Ans. True.

(i) Icon is a graphical representation of any application.

Ans. True.

(j) After an object has been drawn you cannot resize it.

Ans. False.

Q. 5. What is a Spreadsheet Package?

Ans. A spreadsheet is a large sheet having data and information arranged in rows and columns. MS Excel is one of the Most widely used spreadsheet applications. It is a part of Microsoft Office.

Q. 6. Write the two ways for changing the height of the rows an excelled worksheet.

Ans. Two methods for changing the row height are as following:

(i) Set a row to a specific height:

(a) Select the row or rows that you want to change.

(b) On the Home tab, in the Cells group, click Format.

(c) Under Cell Size, click Row Height.

(d) In the Row height box, type the value that you want.

(ii) Change the height of rows by using the mouse:

To change the row height of one row, drag the boundary below the row heading until the row is the height that you want.

Q. 7. Write any five Features of Spreadsheets.

Ans. (i) Charts: It will help you in presenting a graphical representation of your data in the form of Pie, Bar, Line charts and more.

(ii) Auto Sum: Helps you to add the contents of a cluster of adjacent cells.

(iii) Pivot Table: It flips and sums data in seconds and allows you to perform data analysis and generating reports like periodic financial statements, statistical reports, etc. You can also analyze complex data relationships graphically.

(iv) Auto Fill: Allows you to quickly fill cells with repetitive or sequential data such as chronological dates, or numbers, and repeated text.

(v) Wizard: Guides you to work effectively while you work by displaying various helpful tips and techniques based on what you are doing.

Q. 8. Write any five Features of MS EXCEL 2007.

Ans. (i) 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.

(ii) More rows and columns, and other new limits: Excel 2007 is having 1,048,576 rows and 16,384 columns. it provides a user with 1,500% more rows and 6,300% more columns than the Microsoft Office Excel 2003.

(iii) 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.

(iv) Improved sorting and filtering: Enhanced filtering and sorting techniques of Excel can be used to arrange worksheet data more quickly to find the desired answers. In Excel 2007 you can sort data by color and by more than 3 levels.

(v) 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.

Q. 9. Write the steps to start MS Excel.

Ans. (i) Click on the Start button on the Taskbar at the bottom left corner of the Screen.

(ii) Highlight the All Programs item. The program menu will open.

(iii) Select Microsoft Office from the list of programs.

(iv) Click on Microsoft Excel.

Q. 10. Write the steps to Insert a new worksheet.

Ans. Select the worksheet before which you want to insert a new worksheet then follow steps as:

(i) Select Home tab.

(ii) Click cells Group.

(iii) Click Insert.

(iv) Click Insert Sheet.

Q. 11. Write the steps to Rename a worksheet.

Ans. To rename a worksheet follow the steps as:

(i) Right click on the worksheet tab which you want to rename.

(ii) Select rename from the Pop Up menu.

(iii) Type new name for the Worksheet.

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

Ans. You can enter the following kinds of data in a cell:

Numbers: Our numbers can be from the entire range of numeric values: whole numbers (example, 45), decimals (example, 43.45) and scientific notation (example, 0.2487E+2).

Text: First select the cell in which data has to be entered and type the text. Press ENTER key to finish your text entry.

Date and Time: When you enter dates and times, Excel converts these entries into serial numbers and kept as background information. However, the dates and times will be displayed to you on the worksheet in a format opted by you.

Data in Series: You can fill a range of cells either with the same value or with a series of values with the help of Auto Fill.

Q. 13. Write the steps to find and replace’ a data entry in Excel.

Ans. (i) Click on Home Tab → Find.

(ii) In the Find What text box type the text You want to find.

(iii) Click on Find Next or Find All button.

(iv) If you want to replace a text then type the text you want to replace in the ‘replace with’ text box.

(v) Click on Replace or replace all button.

Q. 14. Write the Difference between Move cells and Copy cells.

Ans. When we move or copy a cell, Excel moves or copies the entire cell, including formulas and their resulting values, cell formats, and comments. In Move option the original Cell become Blank but in Copy the value of cell remain same.

Q. 15. Write Short Note on the Following:

(a) Drag and Drop.

Ans. Drag and Drop: If we have to move the cell contents only a short distance, the drag and drop method may be easier. Simply drag the highlighted border of the selected cell to the destination cell with holding the mouse.

(b) Freeze Panes.

Ans. Freeze Panes: If you have a large worksheet with column and row headings, those headings will disappear as the worksheet is scrolled. By using the Freeze Panes feature, the headings can be visible at all times.

(c) Workbook protection.

Ans. Workbook protection: It means to set a password to protect your workbook from unknown users. It is a very powerful feature of MS Excel 2007.

(d) Cell References.

Ans. Cell References: Each worksheet contains a number of columns and rows. Each cell of the worksheet has a unique reference. For example, C11, refers to the cell containing column number C and row number 11.

Q. 16. Write the Steps to Save a Workbook in MS Excel.

Ans. For saving the worksheet for the first time follow the steps given below:

(i) Click office button.

(ii) Select ‘file save as’ on the drop-down menu.

(iii) On the pop-up menu select the location where you want to save the file.

(iv) Type the file name.

(v) Click on ‘save’ in the pop-up menu.