Page 66 - Trackpad_ipro 4.1_Class7
P. 66
More on Spreadsheets
Chapter
06
Your Aim
to learn about:
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 AutoFill
Using Formulas to Perform Calculation Order of Operation
In the previous chapter, we learnt about different components of the Excel window, such as cell,
row, column, formula bar, workbook, and worksheet. We also learnt the process of creating a
workbook, entering data into a worksheet, and saving a workbook. In this chapter, we will learn
more about MS 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 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 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 your selection to end.
Entire Row/Column: Click on the row heading to select the entire row, or click on the column
heading to select the entire column.
Entire Worksheet: Click on the Select All button located below the Name box to select the
entire worksheet. The shortcut key to select the entire worksheet is Ctrl + A.
64 iPro (Ver. 4.1)-VII

