Proc 5AB Assessment


 



  • 1) GETTING STARTED
    Open Microsoft Office and double-click _________ (green X icon)
    Answer:
  • 2) SELECTING CELLS AND RANGES
    To select a single cell:
    Click the _______
    Answer:
  • 3) or
    Choose Edit --> Go To, type a cell _____________ in Reference and
    click OK
    Answer:
  • 4) To select a range of cells:
    Click the first cell in the range and drag to the _______ cell in the
    range
    Answer:
  • 5) To select an entire row or column:
    Click the row ___________ or column heading
    Answer:
  • 6) To select the ___________ spreadsheet:
    Click the box in the upper left corner where the row and column
    headings intersect
    Answer:
  • 7) or
    Choose Edit --> _________ All
    Answer:
  • 8) ENTERING DATA
    To enter ________ into a cell:
    a) Select a cell in the spreadsheet
    Answer:
  • 9) b) Type the data in the _________ bar
    Answer:
  • 10) c) Confirm the entry by pressing
    1) __________: moves the selection one cell down
    Answer:
  • 11) or 2) _________: moves the selection one cell to the right
    Answer:
  • 12) or 3) __________ Key: moves the selection one cell in the direction
    of the Arrow Key
    Answer:
  • 13) or 4) __________ (checkmark): keeps the current cell selected
    Answer:
  • 14) CHANGING CELL DATA
    To edit data:
    a) Select the _______ containing the data you want to change
    Answer:
  • 15) b) Click in the entry ______ where you want to insert data and type
    the changes
    Answer:
  • 16) c) To ___________ changes, click the Cancel (X) in the entry bar
    Answer:
  • 17) To check spelling:
    Go to Tools --> _____________
    Answer:
  • 18) To find and change cell data:
    a) Choose Edit --> _________
    Answer:
  • 19) b) Type in the _________ what box
    Answer:
  • 20) c) Click "Find Next" or "____________" button
    Answer:
  • 21) MOVING, COPYING AND DELETING
    To move cell data using drag-and-drop:
    a) ___________ cells to move
    Answer:
  • 22) b) Position pointer over selection until you see a ________
    c) Drag selection to new location
    Answer:
  • 23) To delete cell data:
    a) Select the cells containing the data you want to delete
    b) Go to Edit --> __________ --> Contents (this deletes the data but
    not the cells)
    Answer:
  • 24) To ___________ a range of cells:
    Answer:
  • 25) a) Drag to select the cells with the data you want to ________ and
    continue dragging to select the cells you want to fill
    Answer:
  • 26) b) Choose _________ --> Fill Down or Fill Right
    Answer:
  • 27) To format cell data:
    a) To change _________ appearance or alignment
    Answer:
  • 28) 1) Select the cells you want to change
    2) Choose options in _______________ toolbar
    Answer:
  • 29) b) To ___________ cell contents so long entries aren't cut off
    1) Select the cells containing the text
    Answer:
  • 30) 2) Choose Format --> __________
    Answer:
  • 31) 3) Click _______________ tab and check "Wrap Text"
    Answer:
  • 32) c) To format numbers, dates and times
    1) Select a cell or cell range
    2) Choose Format --> Cells
    3) Click ___________ tab and select options
    Answer:
  • 33) d) To copy a cell ____________ to other cells
    1) Select the cell format you want to copy
    Answer:
  • 34) 2) Click Format ____________ button on Standard toolbar
    Answer:
  • 35) 3) Select the cell or range to which you want to __________ the format
    Answer:
  • 36) To sort rows of data:
    a) Select the row you want to __________
    Answer:
  • 37) b) Go to ___________--> Sort
    c) Set the sort order
    Answer:
  • 38) To sort columns of data:
    a) Select the _____________ you want to sort
    Answer:
  • 39) b) Go to Data --> ___________
    Answer:
  • 40) c) Click ____________ button to choose the sort order for columns
    Answer:

   

 
Last Modified: Thursday, Oct. 01, 2009
 
© 2009 TeacherWeb, Inc.
Content on this site is the responsibility of the Subscriber. Additional information is available in the TeacherWeb Terms & Conditions