Page 24 - TP_Plus_v4_Class6
P. 24
Take Off Century #Critical Thinking
21 st
Skills
Look at the picture and answer the questions that follow:
a. How many rows and columns can you see in the image? ______
b. What is the value in the cell B4? ______
c. What is the value in the cell D2? ______
d. Which two cells have the same value? ______
e. Which is the active cell? ______
In the previous class you learnt the basics of Excel such as creating a workbook, entering data and
saving workbook. In this chapter you are going to learn more about Excel.
SELECTING CELLS IN A WORKSHEET
Apart from entering data into a worksheet, Excel also provides the facility to perform various other
operations with data such as modifying, inserting, moving/copying and deleting. To perform all these
operations, we first need to select the cell that contains data. Excel allows us to select a single cell or a
group of cells.
To select a Single Cell: Click on the cell to select it.
To select a Group of Cells or Range: Click on the first cell from
where you want to start the selection and drag the mouse
diagonally to the cell to which you want to make selection.
We can also select a range of cells by using the Shift key. Click
on the first cell and then press and hold the Shift key and click
on the last cell up to which we want to make a selection.
Entire Row/Column: Click on the row heading to select the entire Hintbot
row or click on the column heading to select the entire column.
Entire Worksheet: Click on the Select All button located below Shortcut to select entire
the Name box to select the entire worksheet. worksheet: Ctrl + A
Modifying Cell Content
To modify the cell content in a worksheet, follow these steps:
1 Enter the data into
worksheet.
Double-click on the
2 cell whose content
we want to change.
22 Plus (Ver. 4.0)-VI

