Page 62 - iPro_trackGPT_V5_Class7
P. 62
6
More on Spreadsheets
Goal Glimpse
Selecting Cells in a Worksheet Copying/Moving Data
Using Undo and Redo Features Column Width and Row Height
Inserting Rows/Columns Merging Cells
Formatting Spreadsheets Auto Fill
Using Formulas to Perform Calculation Order of Operation
In the previous chapter, we have learnt about various components of the Excel window, including
cells, rows, columns, the formula bar, workbooks, and worksheets. We also learned how to create
a workbook, enter data into a worksheet, and save the workbook. In this chapter, we will explore
more features of Microsoft Excel.
SELECTING CELLS IN A WORKSHEET
In addition to entering data into a worksheet, Excel allows you to perform various operations
on the data, including modifying, inserting, moving/copying, and deleting. To carry out these
operations, you first need to select the cell containing the 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: A cell range is a collection of two or more cells. It is of two types:
Contiguous Cell Range and Non-Contiguous Cell Range. Contiguous Cell Range is a
collection of cells that are adjacent to or next to one another. Colon (:) is used for specifying
this cell range, e.g., A1:A6. Non-contiguous Cell Range is a collection of cells that are not
adjacent to one another. Comma (,) is used for specifying this cell range, e.g., (A1, B1, C3).
Click on the first cell from where you want to start the selection and drag the mouse diagonally
up to the cell where you want to make the selection. We can also select a continuous range of
cells by using the Shift key. Click on the first cell and then press and hold down the Shift key,
and while holding the Shift key, click on the cell where you want to end the selection.
Entire Row/Column: Click on the row heading to select the entire row, or click on the column
heading to select the entire column.
60 TrackGPT iPRO (V5.0)-VII

