Page 21 - Plus_V2.2_C6_Flipbook
P. 21
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
AutoFill Using Formulas to Perform Calculation
Order of Operation
Let’s PLug-in Critical Thinking
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.
More on Excel 2016 19

