MS Excel 2007 Enhancing A Worksheet

6 Questions | Attempts: 78
Share

SettingsSettingsSettings
MS Excel 2007 Quizzes & Trivia

Enhancing an Excel worksheet by using sorting, filtering, conditional formatting, etc. So that special emphasis is placed on a certain focal point on the worksheet makes it more useful for you, your client or boss.


Questions and Answers
  • 1. 
    A to Z sorting with numbers is arranged from highest to lowest number. 
    • A. 

      True

    • B. 

      False

  • 2. 
    You can create a hyperlink in MS Excel to:
    • A. 

      A specific location in the current workbook or a new document

    • B. 

      An email address

    • C. 

      A Web Page

    • D. 

      All of the above

  • 3. 
    Filtering in Excel temporarily hides the columns that do not meet the specified criteria.
    • A. 

      True

    • B. 

      False

  • 4. 
    When filtering numbers, the number AutoFilter dialog box for Top 10 only allows you the following choices: "Top" "10" "Items".
    • A. 

      True

    • B. 

      False

  • 5. 
    When you use conditional formatting, the Highlight Rules format cells based on comparison operators such as greater than, less than, between, and equal to. 
    • A. 

      True

    • B. 

      False

  • 6. 
    A callout shape can be formatted with:
    • A. 

      Text only.

    • B. 

      Text, fill, outline, and glow effect.

    • C. 

      Text and fill.

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.