MS Excel 2007 Enhancing A Worksheet

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Jbuehler12
J
Jbuehler12
Community Contributor
Quizzes Created: 1 | Total Attempts: 79
| Attempts: 79
SettingsSettings
Please wait...
  • 1/6 Questions

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

    • True
    • False
Please wait...
About This Quiz


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.

MS Excel 2007 Enhancing A Worksheet - Quiz

Quiz Preview

  • 2. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Top or Bottom
    1 - 500
    Items or Percent

    Rate this question:

  • 3. 

    You can create a hyperlink in MS Excel to:

    • A specific location in the current workbook or a new document

    • An email address

    • A Web Page

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    Hyperlink to:
    Existng file or Web Page
    Place in the current document
    Create a new document
    E-mail address

    Rate this question:

  • 4. 

    A callout shape can be formatted with:

    • Text only.

    • Text, fill, outline, and glow effect.

    • Text and fill.

    Correct Answer
    A. Text, fill, outline, and glow effect.
    Explanation
    A callout shape can be formatted with text, fill, outline, and glow effect. This means that the user has the option to customize the appearance of the callout shape by adding text, choosing a fill color, adding an outline, and applying a glow effect. This allows for greater flexibility in creating visually appealing callout shapes that can effectively convey information or highlight important points in a presentation or document.

    Rate this question:

  • 5. 

    A to Z sorting with numbers is arranged from highest to lowest number. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    A to Z data with numbers is arranged from the lowest to the highest. (Ascending)
    Z to A data with numbers is arranged from the highest to the lowest. (Descending)

    Rate this question:

  • 6. 

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

    • True

    • False

    Correct Answer
    A. False
    Explanation
    rows

    Rate this question:

Quiz Review Timeline (Updated): Oct 18, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Oct 18, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 18, 2011
    Quiz Created by
    Jbuehler12
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.