Page 20 - TP_Pluse_V2.2_Class_6
P. 20
2 More on Excel 2016
Let’s surf
Ø Selecting Cells in a Worksheet Ø Copying/Moving Data
Ø Column Width and Row Height Ø Inserting Rows/Columns
Ø Merging Cells Ø Splitting Cells
Ø Formatting Spreadsheets Ø Customising Worksheet Tab
Ø Auto Fill Ø Using Formulas to Perform Calculation
Ø Order of Operation
21 st
Let’s PLug-in Century #Critical Thinking
Skills
Look at the picture and answer the questions that follow.
1. How many rows and columns can you see? ______
2. What is the value in the cell B4? ______
3. What is the value in the cell D2? ______
4. Which two cells have the same value? ______
5. In which cell is the cell pointer present? ______
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.
Single Cell: Click on the cell to select it.
Group of Cells or Range: Click on the first cell from where you
want to start the selection and drag the mouse diagonally up to
the cell to which you want to make selection.
18 Plus (Ver. 2.2)-VI

