Page 73 - TP_Plus_v4_Class4
P. 73
Timeline
A range is a collection of selected cells. It is a rectangular section of cells which are next to
each other and at least one side of their border is common.
Undo command is used to reverse the last change made by you.
Redo command is used to redo the last Undo action.
Cell contents can be edited by double clicking on the cell and typing new data as well as by
using the formula bar.
You can easily copy and move the contents of a cell, a range of cells and an entire worksheet.
The AutoFill feature in Excel is used to automatically fill series of data in rows and columns
based on the values of selected cells.
Choose the correct option.
1. Which of these is not a range?
a. F3:I9 b. C20:E28
c. B6:D16 d. A:3:F9
2. Which key is used to edit a cell?
a. Esc key b. Enter key
c. F2 key d. Alt key
3. Which of these is the keyboard shortcut to copy and paste cell contents?
a. Ctrl + Z & Ctrl + V b. Ctrl + C & Shift + V
c. Ctrl + C & Ctrl + V d. Shift + C & Ctrl + V
4. Which of these you can't fill using AutoFill feature in Excel?
a. Numbers b. Days
c. Heights of your classmates d. Hours
Fill in the blanks with the correct words.
Hints Editing, Cell, Delete, Column, Undo
1. To edit any content, you have to select the particular .
2. To select a column, place the mouse pointer on the header.
3. command is used to reverse the last change made by you.
4. To delete the contents of cells, select the cells and press the key.
5. The Fill button is in the group under Home tab.
#Editing Cell Contents in Excel 2019 71

