Excel 2007 Advanced Post Test

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

True

False

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.

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.

2. 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

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.

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.

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

True

False

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.

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.

4. The Paste Options button allows you to________.

Keep source formatting

Copy formatting only

Copy values only

All of the above

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.

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.

5. The ____ button is equivalent to using the sum button.

COUNT

ADD

AutoSum

AddSum

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.

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.

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

True

False

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.

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.

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

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.

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.

8. You can create at most one Excel table in a worksheet

True

False

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.

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.

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

True

False

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.

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.

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

True

False

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

Explanation

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

11. 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

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.

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.

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

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.

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.

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

Custom

Criteria

Index

Pivot

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.

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.

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

True

False

You can always choose to un-hide it.

Explanation

You can always choose to un-hide it.

15. 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

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.

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.