Scribd Logo
Upload

Welcome to Scribd!

  • 51 views

    The Works in Worksheets: Lesson 7

    Uploaded by

    Michael Angelo Garcia
    Spreadsheet software like MS Excel allows users to organize numerical data into workbooks and worksheets composed of rows and columns. Each cell, the intersection of a row and column, has a unique name and address. Users can navigate between cells using arrow keys, select ranges of cells, and move cells by cutting, copying, pasting, or dragging. Additional worksheets, rows, and columns can be inserted, and existing ones resized.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    The Works in Worksheets: Lesson 7

    Uploaded by

    Michael Angelo Garcia
    51 views20 pages
    Spreadsheet software like MS Excel allows users to organize numerical data into workbooks and worksheets composed of rows and columns. Each cell, the intersection of a row and column, has a unique name and address. Users can navigate between cells using arrow keys, select ranges of cells, and move cells by cutting, copying, pasting, or dragging. Additional worksheets, rows, and columns can be inserted, and existing ones resized.

    Original Title

    Grade 4 L-7

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Spreadsheet software like MS Excel allows users to organize numerical data into workbooks and worksheets composed of rows and columns. Each cell, the intersection of a row and column, has a unique name and address. Users can navigate between cells using arrow keys, select ranges of cells, and move cells by cutting, copying, pasting, or dragging. Additional worksheets, rows, and columns can be inserted, and existing ones resized.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    51 views20 pages

    The Works in Worksheets: Lesson 7

    Uploaded by

    Michael Angelo Garcia
    Spreadsheet software like MS Excel allows users to organize numerical data into workbooks and worksheets composed of rows and columns. Each cell, the intersection of a row and column, has a unique name and address. Users can navigate between cells using arrow keys, select ranges of cells, and move cells by cutting, copying, pasting, or dragging. Additional worksheets, rows, and columns can be inserted, and existing ones resized.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 20

    Lesson 7

    The Works in
    Worksheets
    MS Excel: The Basics

    Spreadsheet software like MS Excel helps you record


    numerical data into workbooks and perform
    computations using formulas. Every workbook is
    composed of one or more worksheets.
    Worksheet

    A worksheet is composed of rows and


    columns. Each rows is identified by a
    row number, which each column is
    identified by a column letter.
    Worksheet
    Cell

    The insertion between a row and a


    column is called a cell.
    Cell
    Name Box

    The name box on the toolbar shows you


    the name of the cell.
    Name Box
    NAVIGATING THROUGH CELLS

    • Arrow keys – move the cursor left, right, up, or down


    • TAB – moves the cursor to the right
    • CTRL + HOME – moves the cursor to cell A1
    • CTRL + END – moves the cursor to the last cell that contains data
    • CTRL + right arrow key – moves the cursor to the end of the row
    • CTRL + down arrow key – moves the cursor to the end of the
    column
    SELECTING CELLS

    1. To select cell, click on the cell once.


    2. To select an entire row, click on the row label. Row
    labels are the numbers on the leftmost side of the
    worksheet.
    3. To select an entire column, click on the column label.
    Column labels are the letters on the topmost side of the
    worksheet.
    4. To select an entire worksheet, click on the Select All button
    at the top left corner of the worksheet.
    5. To select a range of cells, drag the mouse across the cells.
    Another way is to hold down SHIFT key while pressing the
    arrow keys.
    6. To edit the contents of a cell, double-click on the cell
    worksheet. The button is found at the left of column A and top
    of row.
    MOVING CELLS AROUND

    Cutting and Pasting Cells


    1. Select the cell or range of cells you want to cut.
    2. On the Home tab, in the Clipboard group, click on the Cut icon.
    3. Click on the Paste icon.
    Cutting and Pasting Cells
    1. Select the cell or range of cells you want to copy.
    2. In the Clipboard group of the Home tab, click on the Copy icon.
    3. Click on the cell where you want to paste the data.
    4. Click on the Paste icon.
    Dragging and Dragging Cells
    1. Select the cells or range of cells you want to move.
    2. Bring the pointer over a border of the selected cell or cells. The pointer
    changes into a cross.
    3. Hold down the left mouse button and drag the mouse. Bring the selected cell or
    cells to its new location.
    4. Release the left mouse button. The selected cell or cells will be moved.
    Inserting Worksheets, Rows, and Columns

    Inserting a Worksheet
    1. To insert a worksheet at the end of the existing worksheets, click on the
    insert Worksheet tab at the bottom of the screen.

    2. To insert a worksheet before an existing worksheet, click on the worksheet’s


    tab. Then on the Home tab, go to the Cells group and click on the Insert arrow>
    Insert Sheet.
    Inserting Worksheets, Rows, and Columns

    Inserting a Row or a Column


    To insert a row or column before an existing sheet row or column, you can
    do one of the following.
    1. Click on the label of the existing row column. In the Cells group of the
    Home tab, click on the Insert arrow. Then click on Insert Sheet Rows to
    insert a row, or click on Insert Sheet Columns to insert a column.
    2. Right-click on a row label or a column label. Click on Insert on the shortcut
    menu.
    RESIZING ROWS AND COLUMNS

    1. Choose a row or column you want to resize.


    2. To resize a row, bring the pointer to the row label and move it to the top
    border or bottom border of the label. To resize a column, bring the pointer
    to the column label and move it to the left border or right border of the
    label.
    3. When the pointer turns into a double arrow, drag the border until the row or
    column is resized the way you want.

    You might also like