class 7 computer icse chapter 5

 

a. Name Box ✅

👉 The Name Box in Excel displays the address of the current cell (like A1, B2, etc.).

---

A. Tick (✓) the correct option

2. Which of the following values will not be treated as a number value in Excel?
✅ c. 67(789)
👉 Because brackets like this are not recognized as numeric characters.

3. A set of worksheets is called
✅ b. Workbook

4. ______ are the types of data that can be entered in Excel.
✅ d. All of these (Label, Values, Formulas)

5. The intersection of a row and column is called a
✅ a. Cell

---

B. Fill in the blanks

1. A Cell is formed when a row and a column intersect.
2. Formula bar displays the contents of the active cell.
3. A group of cells adjacent to each other forming a rectangular shape is referred to as Range.
4. A collection of worksheets stored under a single file name is called Workbook.
5. Ctrl + A is used to select the entire worksheet.

---

C. True (T) or False (F)

1. The address of the cell formed by intersection of row 5 and column D is 5D. → F (Correct is D5, column first then row)
2. A workbook is a collection of only three worksheets. → F (By default it may have 1 or 3, but we can add many worksheets)
3. We can enter symbols such as comma (,) and % in a number value. → T
4. Text values are right-aligned in a cell. → F (Text is left-aligned by default, numbers are right-aligned)
5. We can change the contents of the cell in the formula bar. → T

---

Q1. What is the use of formula bar?
Ans: The formula bar is used to display and edit the contents of the active cell. It is also used to enter formulas in Excel.

---

Q2. What is the difference between a worksheet and a workbook?
Ans:

• A worksheet is a single page (sheet) in Excel made up of rows and columns.
• A workbook is a collection of one or more worksheets stored together in a single file.

---

Q3. What is the use of the following components in a worksheet?

a) Formula Bar – It shows the contents of the active cell and allows us to enter or edit data or formulas.
b) Name Box – It displays the address of the active cell (like A1, B2).
c) Active Cell – The cell in which we can type or edit data. It has a dark boundary around it.

---

Q4. List the different types of data that can be entered in Excel.
Ans: The different types of data that can be entered in Excel are:

1. Labels (Text) – Words or text values (e.g., Name, City).
2. Values (Numbers) – Numeric data (e.g., 123, 45.6).
3. Formulas – Equations used for calculations (e.g., =A1+B1).

---

Q5. Write the steps to save a workbook.
Ans:
Steps to save a workbook in Excel:

1. Click on the File tab (or Office button).
2. Select Save As.
3. Choose the location where you want to save the file.
4. Type a file name.
5. Click on the Save button.

---

 

Multiple Choice Questions (MCQs)

1. Which bar displays the contents of the active cell?
   a) Status Bar
   b) Formula Bar
   c) Title Bar
   d) Menu Bar
2. Which box displays the address of the active cell?
   a) Formula Bar
   b) Name Box
   c) Task Bar
   d) Tool Bar
3. The intersection of a row and a column is called a:
   a) Range
   b) Cell
   c) Worksheet
   d) Field
4. A collection of worksheets in Excel is called a:
   a) Table
   b) Workbook
   c) Document
   d) Database
5. Which of the following is not a type of data in Excel?
   a) Label
   b) Values
   c) Formulas
   d) Slides
6. What is the default alignment of text (labels) in Excel?
   a) Center
   b) Left
   c) Right
   d) Justify
7. What is the default alignment of numbers in Excel?
   a) Left
   b) Right
   c) Center
   d) Bottom
8. Which key combination is used to select the entire worksheet?
   a) Ctrl + C
   b) Ctrl + A
   c) Ctrl + X
   d) Ctrl + V
9. Which option is used to save a workbook for the first time?
   a) Save
   b) Save As
   c) New
   d) Open
10. In cell address B5, “B” represents:
    a) Row
    b) Column
    c) Worksheet
    d) Range
11. In cell address C8, “8” represents:
    a) Row
    b) Column
    c) Cell
    d) Range
12. Which component is used to edit the data in an active cell?
    a) Name Box
    b) Formula Bar
    c) Title Bar
    d) Status Bar
13. Which of the following symbols can be part of a number value in Excel?
    a) %
    b) , (comma)
    c) Both a and b
    d) None
14. Which one is an example of a formula in Excel?
    a) Hello
    b) 25
    c) =A1+B1
    d) Save
15. A group of adjacent cells forming a rectangular block is called:
    a) Range
    b) Workbook
    c) Formula
    d) Table
16. Which of the following stores multiple worksheets under one file?
    a) Table
    b) Workbook
    c) Cell
    d) Column
17. Which of the following is shown in the Name Box?
    a) Contents of active cell
    b) Formula applied
    c) Address of active cell
    d) File name
18. What is the use of the active cell in Excel?
    a) It stores the file name
    b) It allows us to type or edit data
    c) It displays the worksheet name
    d) It saves the workbook
19. By default, how many worksheets are there in a new workbook in Excel (latest versions)?
    a) 1
    b) 2
    c) 3
    d) 5
20. Which of these statements is True?
    a) A worksheet is a collection of workbooks
    b) A workbook is a collection of worksheets
    c) A workbook and worksheet are the same
    d) A workbook contains only one worksheet always

---

Here’s the answer key for the 20 MCQs:

1. b) Formula Bar
2. b) Name Box
3. b) Cell
4. b) Workbook
5. d) Slides
6. b) Left
7. b) Right
8. b) Ctrl + A
9. b) Save As
10. b) Column
11. a) Row
12. b) Formula Bar
13. c) Both a and b
14. c) =A1+B1
15. a) Range
16. b) Workbook
17. c) Address of active cell
18. b) It allows us to type or edit data
19. a) 1
20. b) A workbook is a collection of worksheets