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
T
Trainer12
Community Contributor
Quizzes Created: 4 | Total Attempts: 8,878
Questions: 15 | Attempts: 282

SettingsSettingsSettings
Advanced Excel Quizzes & Trivia

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.