Formatting Cells

10 Questions | Total Attempts: 346

SettingsSettingsSettings
Please wait...
Cell Quizzes & Trivia

Questions and Answers
  • 1. 
    Which option of Home Tab is use for format the cell in Style Group ?
    • A. 

      Conditional Formatting

    • B. 

      Format as Table

    • C. 

      Cell Style

  • 2. 
    What term describes explanatory text attached to a cell
    • A. 

      Callout

    • B. 

      Comment

    • C. 

      Dialog

    • D. 

      Extension

  • 3. 
    Which Excel 2007 feature can be used to keep user selected rows or columns visible at all times when scrolling around the sheet?
    • A. 

      Headers

    • B. 

      Filter

    • C. 

      Freeze Panes

    • D. 

      Data Validation

  • 4. 
    To format a cell like an already formatted one you can use ------------------------------- .
    • A. 

      The Fill down command

    • B. 

      The Autosum command

    • C. 

      The Format Painter command

    • D. 

      None of the above.

  • 5. 
    After you merge a range into a single cell, you can't realign its content.
    • A. 

      True

    • B. 

      False

  • 6. 
    The format Cell Number can has an option to show negative numbers in _______.
    • A. 

      Green

    • B. 

      Blue

    • C. 

      Red

    • D. 

      Quotes

  • 7. 
    we can format the cell by cell style option which is located in Style group.
    • A. 

      True

    • B. 

      False

  • 8. 
    We can lock the cell.
    • A. 

      True

    • B. 

      False

  • 9. 
    How can we give the color to the cell ?
    • A. 

      Fill color

    • B. 

      Text color

    • C. 

      Word Art

  • 10. 
    What is the name of that option which merge the cells ?
    • A. 

      Cell Merge

    • B. 

      Merge and Center

    • C. 

      Center merge

Back to Top Back to top