Excel 2007 Advanced Post Test
-
Once you hide a row, it remains hidden as long as the workbook is active.
-
True
-
False
-
About This Quiz
The 'Excel 2007 Advanced Post Test' assesses advanced skills in Excel 2007, including data formatting, cell content rotation, and use of the AutoSum feature. It is designed to test proficiency in handling complex Excel functions and enhancing data presentation without altering the data itself.
Quiz Preview
- 2.
When a worksheet is printed, the grid lines that surround the cells are printed by default.
-
True
-
False
Correct Answer
A. FalseExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.
-
True
-
False
Correct Answer
A. FalseExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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.
-
COUNT
-
ADD
-
AutoSum
-
AddSum
Correct Answer
A. AutoSumExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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
-
Shift
-
Tab
-
Esc
-
Alt
Correct Answer
A. TabExplanation
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
-
Custom
-
Criteria
-
Index
-
Pivot
Correct Answer
A. CriteriaExplanation
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
-
True
-
False
Correct Answer
A. FalseExplanation
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
-
True
-
False
Correct Answer
A. FalseExplanation
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 ______.
-
Sort A to Z and Sort Z to A buttons
-
QuickSort Options
-
Sort command on the Formulas tab
-
Any of the above
Correct Answer
A. Any of the aboveExplanation
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.
-
True
-
False
Correct Answer
A. TrueExplanation
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
-
1, 2, 4, 3, 5
-
1, 2, 4, 5, 3
-
1, 5, 2, 4, 3
-
1, 5, 2, 3, 4
Correct Answer
A. 1, 5, 2, 3, 4Explanation
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________.
-
Keep source formatting
-
Copy formatting only
-
Copy values only
-
All of the above
Correct Answer
A. All of the aboveExplanation
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 (Updated): Mar 20, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 20, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 12, 2012Quiz Created by
Trainer12
Back to top