Computer Science
Class-VI
Chapter-4 Introduction to MS-Excel
A. Fill in the blank:
1. MS-Excel is an application software that helps in _______.
Answer: Calculation
2. The ______ is the basic work area in an MS-Excel workbook.
Answer: Worksheet
3. A new MS-Excel workbook contains_______ by default.
Answer: 3 Worksheet
4. A _________ is a rectangular block of contiguous cells.
Answer: Range
5. Press_______ to select the active column.
Answer: Shift + Arrow key
6. The formula bar displays the data or formula stored in the _________.
Answer: Active cell
B. Write whether true or false:
1. MS-Excel is a part of MS-office package.
Answer: True
2. A workbook in MS-Excel consists only one worksheet.
Answer: False
3. A row is a horizontal line of boxes.
Answer: True
4. Columns are labelled from A to Z.
Answer: True
5. Each cell has a unique shape formed by the combination of column and row.
Answer: False
6. Before performing any operation on a range of cells, you need to select the range.
Answer: True
C. Tick the correct option:
1. It is a horizontal line of boxes.
a. row b. column
Answer: Row
2. They are labelled from A to Z.
a. cell b. column
Answer: Columns
3. It is formed by the intersection of a row and a column.
a. cell b. Excel
Answer: Cell
4. Number of rows each worksheet contains.
a. 256 b. 65,536
Answer: 65,536
D. Answer the following questions:
1. What is the use of MS-Excel?
Answer: MS-Excel or Microsoft Excel is an application software that helps in calculation using formulae and analysis of data using tables.
2. How can you start MS-Excel?
Answer: Steps to start MS -Excel:
1. Click start button.
2. Select programs option.
3. Click on MS Office
4. Click on MS-Excel.
3. Which types of data can be entered in an MS-Excel worksheet?
Answer: Following types of data can be entered in an MS-Excel worksheet.
1. Numbers
2. Text
3. Formulae
4. How can you enter data in an Excel worksheet?
Answer: You can enter data in the sheet by selecting a cell, typing in it, and then pressing the Enter key. As you type, the data fills the formula bar and the active cell at the same time.
E. Write the notes on:
1. Excel worksheet 2. Row 3. Column 4. Cell
Answer:
1. Excel Worksheet: Worksheet is the basic area in MS Excel. There are multiple pages in each workbook called worksheets. A new MS-Excel workbook contains 3 worksheet by default.
2. Row: Row is a horizontal line of boxes. Rows are labelled using numbers from one onwards like 1,2,3........ and so on.
3. Column: Column is a vertical line of boxes. They are labelled from A to Z. After Z, the column labels are AA, AB, .........BB, BC........ . Each worksheet has a total of 256 columns.
4. Cell: It is the smallest unit of a worksheet. It is formed by the intersection of a row and a column. Each cell has a unique address formed by the combination of a column letter and a row number.
.png)
No comments:
Post a Comment