NIOS CLASS-10 DATA ENTRY OPERATION Lesson 6 BASICS OF SPREADSHEET

Lesson 6

Basics of Spreadsheet

INTEXT QUESTIONS

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

6.21 TERMINAL QUESTIONS

1. What are the main features of MS Excel?

Ans: Microsoft Excel is a Microsoft-produced software program that allows users to use a spreadsheet system to organize, format and measure data with formulas.

2. Differentiate between a worksheet and a workbook?

Ans: An Excel worksheet is a single spreadsheet that is a rectangular cell matrix, arranged into rows and columns in a tabular shape.

An Excel workbook is just like a file or a book with different kinds of relevant material, consisting of one or more worksheets.

A worksheet is a single page spreadsheet or Excel page where you can write, edit and manipulate data, while a workbook is used to compile such worksheets.

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

Ans: A series of cells arranged in rows and columns is the word Worksheet used in Excel documents. To enter the info, it is the working surface you communicate with.

The worksheet in Excel consists of a column and row grid that forms cells. In cells, you type three types of data: marks, values, and formulas. Labels (text) are descriptive pieces of information that typically contain alphabetic characters, such as names, months, or other distinguishing statistics.

4. Explain three different ways you protect your workbook.

Ans: To help you organize data, a workbook is a file containing one or more worksheets. From a blank workbook or from a template, you can create a new workbook. There are three key techniques to secure or restrict the editing options of an Excel sheet from theft; to encrypt the workbook using the password protection option in Microsoft Excel; to convert the Excel workbook to . PDF file, and Microsoft Excel Structure Password workbook protection.

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: A series of cells arranged in rows and columns is the word Worksheet used in Excel documents. To enter the info, it is the working surface you communicate with. Use the command Find. To open it, press Ctrl and F. Adding an additional column to the sheet with hours and employee ID and making a lookup in the new column is the best way to do what you are looking at.

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

Ans: Click the first cell to select nonsequential cells, hold down the Ctrl key, and then click each additional cell (or row or column) that you want to select. Click the small box to the left of column A and above row 1 to pick the whole worksheet. Thousands of rectangles, which are called cells, are composed of each worksheet. The intersection of a row and a column is a cell.

7. Difference between Move cells and Copy cells

Ans: Copy is to make a copy of the selected file or folder and put the duplicate file in a different drive or folder, and transfer the original files from one location to another. With the move button, the original files are removed while the copy preserves them. Ctrl + F7 is the shortcut to pass, Ctrl + C is the shortcut to copy, and Ctrl + V is the shortcut to paste.

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

Ans: A user-defined parameter that helps decide how a printed page appears. From height, margins, page orientation, to print quality, these parameters may include anything. More clearly, it is a menu that allows users to customize a page's layout. The dialog box for page configuration is typically accessible from the File drop-down menu. The page configuration options are available for Microsoft Word 2007 or later under the Layout tab in the Ribbon menu.

9. Explain the different features available in Print command?

Ans: The print command readily specifies one among numerous printer interfaces.

      Print Range: The range of pages required to be printed can be specified.

      Print What: The area of the workbook that needs to be printed can be specified.

      Copies: Specifies the number of copies of the printable sheet that needs to be printed.

10. Define the following:

(a) Navigating worksheet

Ans:

      Row Navigation is done by using the vertical scrollbar, while Column navigation is done by using the horizontal scrollbar.

      Arrow keys, scroll bar, and even the mouse can be used to move through different areas of the worksheet.

(b) Editing data

Ans:

      The cell containing the data is selected.

      The F2 is pressed to edit the contents of the cell.

      Erase the incorrect data using Backspace key.

      Retype the correct entry.

      Or, pressing Delete key after selecting the cell also clears the cell.

 

(c) Insert cells and rows

Ans: Insert cells:

• At the point when you insert clear cells, you can pick whether to move different cells down or to one side to oblige the new cells.
• Cell references naturally acclimate to coordinate with the area of the moved cells.
• A cell is the crossing point of a row and column.
• It is recognized by row number and column header.

Rows:

• A row is a progression of information banks spread out on a level plane in a table or spreadsheet.

(d) Drag and drop

Ans: Drag and drop:

• Drag and drop is a mouse strategy that you can use in Office Excel 2007 to get a cell choice and drop it into another spot on the worksheet.
• Despite the fact that drag and drop is a fundamental method for moving cell passages around a worksheet, you can likewise adjust it to duplicate a cell choice.

(e) Workbook protection

Ans: Workbook protection:

• Protecting your worksheet implies that nobody can alter, reformat, or erase the substance.
• To keep different users from reviewing covered up worksheets, adding, moving, erasing, or concealing worksheets, and renaming worksheets, you can protect the design of your Excel sheet manual with a secret password.