We can insert a row and a column in a worksheet.

The intersection between a row and a column in excel is called a word document.

The cell address is based on the column number and the row number.

We cannot resize the rows and columns the way we want.

Composed of one or more worksheet

composed of rows and columns

row is identified by a row letters and columns are

identified by a column numbers.

Intersection between a column and a row.

Example of cell address

The Name Box on the toolbar shows you the name of the cell.

move the cursor left, right, up, or down

moves the cursor to cell A1

moves the cursor to the right

moves the cursor to the end of the row

moves the cursor to the last cell that contains data.

To select a cell, click on the cell multiple.

To select an entire row, click on the row label. Row labels are the numbers on the TOPMOST LEFT side of the worksheet.

To select an entire column, click on the column label. Column labels are the letters on the topmost side of the worksheet.

To select an entire worksheet, click on the Select All button at the top left corner of the worksheet. The button is found at the left of Column D and on top of row.

To select a range of cells, drag the mouse across the cells.

hold the SHIFT key while pressing the arrow keys.

To edit the contents of a cell, single click on the cell.

When you sort some things, it means you arrange them in some order.

You can sort words in ascending, descending or alphabetical, order.

Clip arts are pictures or graphics files that are readily available for use on the computer.

We cannot insert clip art or online images in worksheet.

We can resize the image we inserted in worksheet.

To change the height of the image, drag the middle-left sizing handle.

To change the width of the image, drag the middle top or middle bottom sizing handle

To resize the image proportionally, drag any of the four corner sizing handles.

We cannot rotate the image / clip art using the rotating handle.

MS Excel allows you to edit images you have added to your worksheets.

Shapes cannot be added to a worksheet

In Picture tools, there are 6 groups of tools under the Format tab.

In Picture tools, Adjust group lets you modify the brightness and contrast of the picture.

There are 10 shape categories under the Shapes button.

Recently used shapes-gives you quick access to shapes you have just used.

Equation shapes- feature shapes used in mathematical operations.

Block arrows-lets you draw different stars and banners.

Basic shapes-let you draw often-used shapes, icons, braces, and brackets.