MS Excel 2007 Enhancing A Worksheet

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Jbuehler12

Jbuehler12

Community Contributor

Quizzes Created: 1 | Total Attempts: 78

Questions: 6 | Attempts: 78 | Updated: Oct 18, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

MS Excel 2007 Enhancing A Worksheet - 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.

Questions and Answers

1.

A to Z sorting with numbers is arranged from highest to lowest number.
- A.
  
  True
- B.
  
  False
Correct Answer
B. 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:
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
Correct Answer
D. 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:
3.

Filtering in Excel temporarily hides the columns that do not meet the specified criteria.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
rows

Rate this question:
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
Correct Answer
B. False

Explanation
Top or Bottom
1 - 500
Items or Percent

Rate this question:
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
Correct Answer
A. True

Explanation
Conditional formatting is a feature in many spreadsheet programs that allows you to format cells based on specific conditions or criteria. When using conditional formatting, you can set rules that compare the values in the cells to certain conditions, such as being greater than, less than, between, or equal to a specific value. If the conditions are met, the cells will be formatted according to the specified formatting rules. Therefore, the statement that the Highlight Rules format cells based on comparison operators such as greater than, less than, between, and equal to is true.

Rate this question:
6.

A callout shape can be formatted with:
- A.
  
  Text only.
- B.
  
  Text, fill, outline, and glow effect.
- C.
  
  Text and fill.
Correct Answer
B. 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:

Quiz Review Timeline +

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

MS Excel 2007 Enhancing A Worksheet

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

You can create a hyperlink in MS Excel to:

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

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

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 callout shape can be formatted with: