Inserting, Deleting Columns & Rows

10 Questions | Total Attempts: 47

SettingsSettingsSettings
Please wait...
Excel Quizzes & Trivia

Questions and Answers
  • 1. 
    Do we have more than one way to insert or delet row and column on Excel worksheet ?
    • A. 

      Yes

    • B. 

      No

    • C. 

      None of above

  • 2. 
    You cannot insert comments on each cell.
    • A. 

      True

    • B. 

      False

  • 3. 
    Which of the following keyboard shortcut is used to cut text?
    • A. 

      Ctrl-C

    • B. 

      Alt-X

    • C. 

      Ctrl-X

    • D. 

      Alt-C

  • 4. 
    In Excel, you can organize data to perform mathematical calculations.  Data is organized in rows and ___________________ .
    • A. 

      Columns

    • B. 

      Rows

    • C. 

      None of Above

  • 5. 
    Once you hide a row, it remains hidden as long as the workbook is active.
    • A. 

      True

    • B. 

      False

  • 6. 
    After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry
    • A. 

      Shift

    • B. 

      Tab

    • C. 

      Esc

  • 7. 
    How are rows labeled in an Excel 2007 spreadsheet?
    • A. 

      Across the top with consecutive numbers

    • B. 

      Across the top with consecutive letters

    • C. 

      Down the side with consecutive numbers

    • D. 

      Down the side with consecutive letters

  • 8. 
    what is the shortcut key for inserting Rows and Columns ?
    • A. 

      Crt +

    • B. 

      Crt -

    • C. 

      Crt /

  • 9. 
    What is the Shortcut key for deleting the Rows and Columns ?
    • A. 

      Crt +

    • B. 

      Crt -

    • C. 

      Crt *

  • 10. 
    Do we have a cell group in Home Tab ?
    • A. 

      True

    • B. 

      False

Back to Top Back to top