Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    053 - Spreadsheet Basics

    Uploaded by

    Narciso Aguda
    This document provides instructions for learning basic spreadsheet and Microsoft Excel concepts. It defines key terms like spreadsheet, table, row, column, and cell. It then provides a tutorial on formatting cells by filling colors, applying borders, resizing rows and columns, and changing font sizes. The tutorial has the learner practice these skills by completing tasks on three different worksheets, including making a checkerboard with alternating black and white cells and creating an Excel cell bingo game. The document concludes by having the learner save the Excel file with their name and the assignment name.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    053 - Spreadsheet Basics

    Uploaded by

    Narciso Aguda
    46 views2 pages
    This document provides instructions for learning basic spreadsheet and Microsoft Excel concepts. It defines key terms like spreadsheet, table, row, column, and cell. It then provides a tutorial on formatting cells by filling colors, applying borders, resizing rows and columns, and changing font sizes. The tutorial has the learner practice these skills by completing tasks on three different worksheets, including making a checkerboard with alternating black and white cells and creating an Excel cell bingo game. The document concludes by having the learner save the Excel file with their name and the assignment name.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for learning basic spreadsheet and Microsoft Excel concepts. It defines key terms like spreadsheet, table, row, column, and cell. It then provides a tutorial on formatting cells by filling colors, applying borders, resizing rows and columns, and changing font sizes. The tutorial has the learner practice these skills by completing tasks on three different worksheets, including making a checkerboard with alternating black and white cells and creating an Excel cell bingo game. The document concludes by having the learner save the Excel file with their name and the assignment name.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    46 views2 pages

    053 - Spreadsheet Basics

    Uploaded by

    Narciso Aguda
    This document provides instructions for learning basic spreadsheet and Microsoft Excel concepts. It defines key terms like spreadsheet, table, row, column, and cell. It then provides a tutorial on formatting cells by filling colors, applying borders, resizing rows and columns, and changing font sizes. The tutorial has the learner practice these skills by completing tasks on three different worksheets, including making a checkerboard with alternating black and white cells and creating an Excel cell bingo game. The document concludes by having the learner save the Excel file with their name and the assignment name.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    053 - Spreadsheet Basics Name Date: Per:

    Part I: Definitions
    Spreadsheet: _________________________________________________________________________
    __________________________________________________________________________________
    Microsoft Excel: ______________________________________________________________________
    __________________________________________________________________________________
    Table: _____________________________________________________________________________
    __________________________________________________________________________________
    Column: ___________________________________________________________________________
    __________________________________________________________________________________
    Row: ______________________________________________________________________________
    __________________________________________________________________________________
    Cell:______________________________________________________________________________
    __________________________________________________________________________________
    Part II: Getting Around:
    Label and Locate (Toolbars, Menu bars, Worksheet(s), Cell, Cell Address Bar, Formula Bar)

    Formula bar: Where we type our formulas


    And where we edit the text in the cell

    Worksheets: Separate Pages

    Cell Address Bar: Where your selection is


    Right now

    Part III: Tutorial

    1. Cells (Naming and Formatting) - SHEET #1


    •  DO: First, type the name of the worksheet as “Naming and Formatting” as sheet #1
    • Cells are named in this way: (Column—LETTERS, Row—NUMBERS)
    •  DO: Locate the following cells and type the letter ‘X’ in them: C12, A13, B1, B12
    • Select Multiple Cells by holding down the mouse button while dragging.
    • If I want to select A1, B1, C1, D1, E1, F1, a shortcut of writing it would be A1:F1
    •  DO: Select B3:F3 and fill with YELLOW using the FILL TOOL
    •  DO: Select D4:D11 and fill with RED using the FILL TOOL
    •  DO: Select C12:E12 and fill with BRIGHT GREEN using the FILL TOOL; Apply a thick border
    (THICK BOX BORDER) using the BORDER TOOL
    •  DO: Select G6:I11 and fill with VIOLET using the FILL TOOL
    •  DO: Apply a BORDER TO ALL THE CELLS (ALL BORDERS) using the BORDER TOOL
    2. Cells - Continued on SHEET #1
    • An entire COLUMN or ROW of Cells can be
    sized by clicking and dragging the ROW or
    COLUMN #s.
    • To change the ROW size, put your mouse just
    underneath the row # until the pointer changes.
    Click and drag to make the change.
    • To change the COLUMN SIZE, put your mouse
    to the right or left hand edge of the column until
    the pointer changes. Click and drag to make the change.
    •  DO: Change the SIZE of ROW #1 to 30.
    •  DO: Type the word “OVERLAP” in CELL A1 in 25 PT
    font in ARIAL
    • The letters in this CELL will overlap the next cell (B1)
    •  DO: Type the word “COVER” in CELL B1 in 25 PT font
    in ARIAL
    • Cells overlap ONLY if there is nothing in the adjacent cell.
    •  DO: Change the SIZE of COLUMN A to 30.
    • By changing the size of the column we are able to see what was
    overlapped.

    PART IV: Make a CHECKERBOARD!


     Go to the SECOND WORKSHEET (Sheet 2)
     Rename the Worksheet “CHECKERBOARD”
     Using what you have just learned, create a checkerboard using
     BLACK and WHITE Alternating Cells
     Use the following Cells: A1:I12
     Make sure that cell Height = 30
     Cell Width = 8

    PART IV: Excel CELL BINGO!


    Do this on SHEET #3 (RENAME this sheet: “BINGO”)

    SAVE AS your entire file as: perX-last-first-excel1.xls

    You might also like