Class 6 - Chapter 6: Editing in Excel

 Chapter 6: Editing in Excel

Brain Developer

A. Fill in the blanks. 

1. Format

2. Clipboard 

3. Formula

4. Ctrl + C 

5. Flash Fill

B. State True or False. 

1. False

2. False 

3. False 

4. False 

5. True

C. Select the correct option. 

1. a. Apostrophe ( ' )

2. c. Ready mode 

3. a. Shift key

4. a. Ctrl + Z

5. c. Asterisk (*)

D. Competency-based question.

Surabhi can use the "AutoFill" feature to write a series of months. 

E. Answer the following questions.

1. We can edit data in a worksheet in two ways:

Type the new content directly in the cell to replace.

Double-click on the cell containing the data, make the necessary changes, and press Enter.

2. To select a range of non-adjacent columns, hold down the Ctrl key and click on the column headers of the desired columns.

3. Auto Fill is the easiest method to fill the consecutive data items automatically in the cells of a worksheet.

4. Flash Fill is a time-saving feature, which identifies the pattern in data that you have used in a worksheet and then fills the remaining series accordingly.

5. The Undo command (Ctrl + Z) reverses the last action, while the Redo command (Ctrl + Y) restores the action that was undone.