class 7 chapter 6 note with answer

📘 Microsoft Excel – Notes

1. Modifying the Cell Content

Definition: Changing or editing the text, number, or formula inside a cell.
Steps:

1. Select the cell you want to change.

2. Type the new data (it will replace the old one).

3. Or double-click the cell to edit inside it.

4. Press Enter to apply.

---

2. Copying Data

Definition: Making a duplicate of the data from one cell to another.
Steps:

1. Select the cell(s) you want to copy.

2. Click Copy from the Home tab (or press Ctrl + C).

3. Select the destination cell.

4. Click Paste (or press Ctrl + V).

---

3. Undo and Redo Commands

• Undo: Cancels the last action. (Ctrl + Z)

• Redo: Repeats the last undone action. (Ctrl + Y)

---

4. Inserting a Row or Column

Steps:

1. Select the row number or column letter.

2. Right-click → Choose Insert.

3. A new row appears above, or a new column appears to the left.

---

5. Deleting a Row or Column

Steps:

1. Select the row number or column letter.

2. Right-click → Choose Delete.

3. The selected row/column is removed.

---

6. Insert a Cell

Steps:

1. Select the cell where you want a new cell.

2. Right-click → Insert.

3. Choose shift options (down/right).

---

7. Delete a Cell

Steps:

1. Select the cell.

2. Right-click → Delete.

3. Choose shift options (left/up).

---

8. Merge Cells

Definition: Combining two or more cells into one bigger cell.
Steps:

1. Select the cells.

2. Click Merge & Center in the Home tab.

---

9. Unmerge Cells

Steps:

1. Select the merged cell.

2. Click Merge & Center again to unmerge.

---

10. Split Cell (Text to Columns)

Definition: Dividing data in one cell into separate cells.
Steps:

1. Select the cell.

2. Go to Data → Text to Columns.

3. Choose the separator (comma, space, etc.) → Finish.

---

11. Apply Border

Steps:

1. Select the cell(s).

2. Go to Home → Borders.

3. Choose the type of border (outside, all, thick, etc.).

---

12. Wrap Text

Definition: Makes long text fit inside a cell by breaking into multiple lines.
Steps:

1. Select the cell.

2. Click Wrap Text in the Home tab.

---

13. Font Color

Steps:

1. Select the cell text.

2. Click Font Color (A icon) in Home tab.

3. Choose a color.

---

14. Fill Color (Cell Color)

Steps:

1. Select the cell.

2. Click Fill Color (paint bucket icon).

3. Pick a color.

---

15. Cell Alignment

Steps:

1. Select the cell.

2. In Home → Alignment, choose Left, Center, or Right.

---

16. Changing Orientation (Text Direction)

Steps:

1. Select the cell.

2. Go to Home → Orientation.

3. Choose angle (Rotate up, down, vertical, etc.).

---

17. Number Group (Formatting Numbers)

Definition: Formats numbers as currency, percentage, decimal, etc.
Steps:

1. Select the cell.

2. Go to Home → Number group.

3. Choose format (General, Number, Currency, Percentage, Date, etc.).

---

18. AutoFill Feature

Definition: Automatically fills a series (numbers, dates, days).
Steps:

1. Type the first value.

2. Drag the small fill handle (corner of the cell) down or across.

3. Excel will fill the series.

---

19. Using Formulas

Definition: A formula is an equation that calculates values in Excel.
Steps:

1. Start with = in a cell.

2. Type the formula (e.g., =A1+B1).

3. Press Enter.

---

20. Operators in Excel

• Arithmetic Operators: + , - , * , / , % , ^

• Comparison Operators: = , > , < , >= , <= , <>

• Text Operator: & (joins text)

• Reference Operators: : , , (comma)

---

---

A. Tick (✓) the correct option.

Q1. Which of the following cannot be used to change the column width in Excel?
a. Drag the right border to adjust the column width
b. Double-click the right border to auto-fit the column width
c. Click Format → Column Width in the Cells group
d. Click Format → Shift Cells Right in the Cells group

Answer: d. Click Format → Shift Cells Right in the Cells group

---

Q2. ______ refers to rotating text at different angles inside a cell.
a. Indentation
b. Alignment
c. Orientation
d. Merge Cells

Answer: c. Orientation

---

Q3. What is the Auto Fill feature in Excel?
a. It automatically completes shortened words.
b. It completes numeric entries matching an existing entry in the same column.
c. It fills cells with a series of numbers, dates or patterns.
d. All of these

Answer: c. It fills cells with a series of numbers, dates or patterns.

---

Q4. Which statement about the Number group on the Home tab is true?
a. It contains options for changing the appearance of text.
b. It contains options for changing text orientation and indentation.
c. It provides formats for displaying values such as numbers, dates or percentages.
d. It provides options for applying borders around selected cells.

Answer: c. It provides formats for displaying values such as numbers, dates or percentages.

---

B. Fill in the blanks using the words in the box.

(Number, Merge & Center, Auto Fill, Wrap Text, Font)

1. The Wrap Text option adjusts a lengthy text into multiple lines inside a single cell.

2. A feature that lets you fill the data in cells by picking up the pattern set in the example is Auto Fill.

3. The option to apply borders across the selected range of data is present in the Font group on the Home tab.

4. We can use the Merge & Center option in the Alignment group to combine two or more selected cells into a single cell.

5. The options to apply comma as a thousand separator and increase the number of decimal places is present in the Number group on the Home tab.

---

C. Write T for True and F for False statements.

1. The orientation refers to the distance between the cell boundary and text. → F

2. AutoFill cannot be used to generate a user defined series. → F

3. Number formatting changes the appearance of the value without changing the actual cell value that Excel uses to perform calculations. → T

4. We can edit the contents of a cell by pressing the F2 key. → T

5. The contents of a cell can be moved or copied to other cells. → T

---

---

D. Answer these questions.

Q1. Explain two methods to adjust the row height in a worksheet.
Answer:

• Method 1: Place the mouse pointer on the bottom border of the row heading and drag it up or down to adjust the height.

• Method 2: Go to the Home tab → Cells group → Format → Row Height, then type the desired row height value.

---

Q2. What is Alignment in Excel? List the different options for vertical and horizontal alignment.
Answer:

• Alignment means the placement of text or data inside a cell.

• Horizontal Alignment options: Left, Center, Right, Fill, Justify, Center Across Selection.

• Vertical Alignment options: Top, Middle, Bottom.

---

Q3. How are the Comma Style and Accounting Number Format options in the Number group used?
Answer:

• Comma Style: Adds a thousand separator (comma) to numbers and shows two decimal places.

• Accounting Number Format: Aligns currency symbols and decimal points in a column to make financial data easy to read.

---

Q4. Define the following terms in the context of MS Excel 2019.

a. Orientation → It is used to rotate text in different directions or angles within a cell.

b. Indentation → It refers to increasing the space between the cell border and the text within the cell.

c. AutoFill → It is a feature that automatically fills a series of values (like numbers, dates, or days of the week) by dragging the fill handle.

---