Excel 2007 Advanced Post Test

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 Trainer12

Trainer12

Community Contributor

Quizzes Created: 4 | Total Attempts: 8,886

Questions: 15 | Attempts: 284 | Updated: Mar 20, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

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

Questions and Answers

1.

Once you hide a row, it remains hidden as long as the workbook is active.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
You can always choose to un-hide it.

Rate this question:
2.

When a worksheet is printed, the grid lines that surround the cells are printed by default.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
When a worksheet is printed, the grid lines that surround the cells are not printed by default.

Rate this question:
3.

You can rotate cell contents in Excel so that they appear at any angle or orientation.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
In Excel, it is possible to rotate cell contents so that they can appear at any angle or orientation. This feature allows users to customize the appearance of their data and make it more visually appealing. By rotating cell contents, users can present their data in a more organized and clear manner, enhancing readability and understanding. This feature is particularly useful when working with large datasets or when creating reports or presentations. Overall, the ability to rotate cell contents in Excel provides users with greater flexibility in displaying their data.

Rate this question:
4.

After you merge a range into a single cell, you can't realign its content.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
When merging a range into a single cell, you can still realign its content. This means that even after merging, you can adjust the alignment of the text within the merged cell, such as aligning it to the left, center, or right. Therefore, the statement given in the question is incorrect, and the correct answer is False.

Rate this question:
5.

Formatting changes only the appearance of data- it does not affect the data itself.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
Formatting refers to changing the appearance of data, such as font style, size, color, or alignment. It does not alter the actual data or its values. Therefore, formatting changes only affect the visual presentation of the data and have no impact on the underlying data itself. This statement is true.

Rate this question:
6.

The ____ button is equivalent to using the sum button.
- A.
  
  COUNT
- B.
  
  ADD
- C.
  
  AutoSum
- D.
  
  AddSum
Correct Answer
C. AutoSum

Explanation
The AutoSum button is equivalent to using the sum button because it automatically selects the range of cells that need to be summed and inserts the SUM function for those cells. This saves time and effort for the user, as they don't have to manually select the cells and type in the SUM function. The AutoSum button is a convenient feature in spreadsheet software that simplifies the process of calculating sums.

Rate this question:
7.

Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
3D charts are visually appealing because they add depth and dimension to the data. However, this can sometimes make it challenging to accurately interpret the information presented. The use of 3D effects in charts can obscure the relationship between values, particularly when comparing the sizes of different slices or sections. This is because the added depth can create an optical illusion that distorts the perception of the data. Therefore, it is true that 3D charts can make it difficult to see which slice is larger, potentially leading to misinterpretation of the data.

Rate this question:
8.

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
- D.
  
  Alt
Correct Answer
B. Tab

Explanation
After Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key allows you to accept the entry. The Tab key is commonly used to move the cursor to the next cell in a spreadsheet, but in this context, it is used to accept the suggested entry and move on to the next cell for data input.

Rate this question:
9.

You use ______ filters to find all objects with a value greater than X or acquired after a certain date
- A.
  
  Custom
- B.
  
  Criteria
- C.
  
  Index
- D.
  
  Pivot
Correct Answer
B. Criteria

Explanation
In order to find all objects with a value greater than X or acquired after a certain date, you would use criteria filters. Criteria filters allow you to specify specific conditions or requirements that the objects must meet in order to be included in the search results. By setting criteria for the value and date, you can filter out the objects that do not meet the specified conditions and only display the ones that do.

Rate this question:
10.

You can create at most one Excel table in a worksheet
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
In Excel, you can create multiple tables in a single worksheet. Tables allow you to organize and analyze data more efficiently by providing features like automatic filtering, sorting, and formatting. By creating multiple tables, you can separate different sets of data and apply specific formatting or calculations to each table individually. Therefore, the statement "You can create at most one Excel table in a worksheet" is false.

Rate this question:
11.

When you clear a filter, all filters in the worksheet are cleared
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
When you clear a filter, only the specific filter that you cleared is cleared, not all filters in the worksheet. Therefore, the statement "When you clear a filter, all filters in the worksheet are cleared" is false.

Rate this question:
12.

To sort data in an Excel worksheet you can use the ______.
- A.
  
  Sort A to Z and Sort Z to A buttons
- B.
  
  QuickSort Options
- C.
  
  Sort command on the Formulas tab
- D.
  
  Any of the above
Correct Answer
D. Any of the above

Explanation
The correct answer is "Any of the above." This is because all three options mentioned - the Sort A to Z and Sort Z to A buttons, QuickSort Options, and the Sort command on the Formulas tab - can be used to sort data in an Excel worksheet. The user can choose any of these options based on their preference or the specific requirements of the data they are working with.

Rate this question:
13.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
Using the Sort A to Z or Sort Z to A buttons is indeed an easy way to sort data when there is only one sort field. These buttons allow the data to be sorted in ascending order (A to Z) or descending order (Z to A) based on the selected sort field. This eliminates the need for manual sorting and makes the process quick and convenient. Therefore, the statement "True" is the correct answer.

Rate this question:
14.

Put the following five steps in the order in which you would perform them to use the Paste Special function: 1. Select and copy a range 2. Click the Paste button arrow in the Clipboard group 3. Specify exactly what you want to paste 4. Click Paste Special to open the dialog box 5. Select the range where you want to pase the Clipboard contents
- A.
  
  1, 2, 4, 3, 5
- B.
  
  1, 2, 4, 5, 3
- C.
  
  1, 5, 2, 4, 3
- D.
  
  1, 5, 2, 3, 4
Correct Answer
D. 1, 5, 2, 3, 4

Explanation
To use the Paste Special function, the first step is to select and copy a range of cells. Then, click the Paste button arrow in the Clipboard group. After that, you need to specify exactly what you want to paste. Next, click Paste Special to open the dialog box. Finally, select the range where you want to paste the Clipboard contents. Therefore, the correct order of the steps is 1, 5, 2, 3, 4.

Rate this question:
15.

The Paste Options button allows you to________.
- A.
  
  Keep source formatting
- B.
  
  Copy formatting only
- C.
  
  Copy values only
- D.
  
  All of the above
Correct Answer
D. All of the above

Explanation
The Paste Options button allows you to perform all of the mentioned actions, which include keeping the source formatting, copying formatting only, and copying values only. This button provides a range of options for pasting content, allowing users to choose the desired format or values when copying and pasting data.

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
Mar 20, 2023

Quiz Edited by
ProProfs Editorial Team
Oct 12, 2012

Quiz Created by
Trainer12

Excel 2007 Advanced Post Test

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

When a worksheet is printed, the grid lines that surround the cells are printed by default.

You can rotate cell contents in Excel so that they appear at any angle or orientation.

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

Formatting changes only the appearance of data- it does not affect the data itself.

The ____ button is equivalent to using the sum button.

Although 3D Charts are visually attractive, they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.

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

You use ______ filters to find all objects with a value greater than X or acquired after a certain date

You can create at most one Excel table in a worksheet

When you clear a filter, all filters in the worksheet are cleared

To sort data in an Excel worksheet you can use the ______.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

The Paste Options button allows you to________.