Excel 2007 Data Tables, Pivot Tables, Pivot Charts

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 Usaeagg2
U
Usaeagg2
Community Contributor
Quizzes Created: 4 | Total Attempts: 6,751
Questions: 24 | Attempts: 911

SettingsSettingsSettings
Excel 2007 Data Tables, Pivot Tables, Pivot Charts - Quiz

Multiple choice test covering Excel 2007 data tables Pivot Tables and charts


Questions and Answers
  • 1. 

    All of the following statements regarding fields are true except:

    • A.

      The field names must be entered in the forst row of the list.

    • B.

      The field names will change from record to record.

    • C.

      Each field name must be unique.

    • D.

      The fields will be in the same order in every record.

    Correct Answer
    B. The field names will change from record to record.
    Explanation
    The given statement "The field names will change from record to record" is not true. Field names in a database or record-keeping system are typically consistent and do not change from record to record. Field names are used to identify and categorize data within a record, and they need to remain the same to ensure consistency and accuracy in data management and retrieval.

    Rate this question:

  • 2. 

    You have a list of all the members of a club you belong to.  The worksheet contains other data as well.  How can you be sure Excel recognizes the boudaries of the list.

    • A.

      Insert a comment in the upper-left corner of the list.

    • B.

      Insert a blank row between the field names and the data.

    • C.

      Insert a blank row and a blank column between the list and other data in the sheet.

    • D.

      Type a row of dashes (---) after the last row of the list.

    Correct Answer
    C. Insert a blank row and a blank column between the list and other data in the sheet.
    Explanation
    By inserting a blank row and a blank column between the list and other data in the sheet, Excel will be able to recognize the boundaries of the list. This ensures that any functions or operations performed on the list will only apply to the specific range of cells within the list, and not to any adjacent data. It also helps in maintaining the integrity and organization of the data by clearly separating the list from other information on the worksheet.

    Rate this question:

  • 3. 

    You have a list of all the employees in your organization.  The list contains employee name, office, title, and salary.  You want to list all employees in each office branch.  The branches should be listed alphabetically, with the employee earning the highest salary listed first in each office.  Which is true of your sort order?

    • A.

      Branch office is the primary key and should be in ascending order.

    • B.

      Salary is the primary key and should be in descending order.

    • C.

      Salary is the primary key and should be in ascending order.

    • D.

      Branch office is the primary key and should be in descending order.

    Correct Answer
    A. Branch office is the primary key and should be in ascending order.
    Explanation
    The correct answer is that the Branch office is the primary key and should be in ascending order. This means that the list of employees should be sorted by the office branch in alphabetical order. The primary key is used to uniquely identify each record in a database, and in this case, the branch office is chosen as the primary key for sorting purposes. Additionally, the question specifies that the employee with the highest salary should be listed first in each office, but this does not affect the primary key or the sorting order based on the branch office.

    Rate this question:

  • 4. 

    You have a list of all the employees in your organization.  The list contains employee name, location, title, and salary.  You want to list all employees in each location.  The branches should be listed alphabetically, with the highest paid employee listed first for each location.  Which is true of your sort order?

    • A.

      Sort by location ascending, then by salary ascending.

    • B.

      Sort by location ascending, then by salary descending.

    • C.

      Sort by salary descending, than by location ascending.

    • D.

      Sort by location descending, then by salary ascending.

    Correct Answer
    B. Sort by location ascending, then by salary descending.
    Explanation
    The correct answer is to sort by location ascending, then by salary descending. This means that the employees will be listed in alphabetical order based on their location, and within each location, the employees will be listed in descending order based on their salary. This sorting order allows for easy identification of the highest paid employee in each location.

    Rate this question:

  • 5. 

    The maximum number of keys you can sort by is?

    • A.

      One

    • B.

      Two

    • C.

      Three

    • D.

      Unlimited

    Correct Answer
    C. Three
    Explanation
    The correct answer is three because sorting requires comparing elements, and in order to compare three elements, you need at least three keys. With only one key, there is nothing to compare, and with two keys, you can only compare two elements at a time. Therefore, three is the minimum number of keys needed to sort a set of elements effectively.

    Rate this question:

  • 6. 

    The Text Import Wizard can be used to import data from what type of files?

    • A.

      HTML files

    • B.

      Database files.

    • C.

      ASCII files

    • D.

      Graphic files

    Correct Answer
    C. ASCII files
    Explanation
    The Text Import Wizard is a tool that allows users to import data from ASCII files. ASCII files are plain text files that contain data in a format that can be easily read by humans and computers. The wizard helps users specify the file format, delimiter, and other settings to correctly import the data into a spreadsheet or database. This feature is particularly useful when dealing with large amounts of data that need to be organized and analyzed.

    Rate this question:

  • 7. 

    You have a list containing all the employees in the organization.  You want to display all rows where employees earn more than $50,000, but less than $75,000.  How should you set your criteria range?

    • A.

      Have one column entry for the salary field, with >50000 in one row and

    • B.

      Have two column entries for the salary field, with >50000 in one column and

    • C.

      Have two column entries for the salary field, with >50000 in one column and

    • D.

      It is not possible to set up the criteria range to enable this.

    Correct Answer
    B. Have two column entries for the salary field, with >50000 in one column and
    Explanation
    To display all rows where employees earn more than $50,000 but less than $75,000, you need to set up a criteria range with two column entries for the salary field. In one column, you should have the criteria ">50000" to filter out employees earning more than $50,000. In the second column, you should have the criteria "

    Rate this question:

  • 8. 

    You have a list containing all the employees in your organization.  You have the criteria range that shows Manager in the Title field in row 18 and New York in the Location field in row 19.  Which rows will be displayed?

    • A.

      All managers in New York.

    • B.

      All managers regardless of location and all employees in New York.

    • C.

      All managers except those in New York.

    • D.

      All managers except those in New York and all New York employees

    Correct Answer
    B. All managers regardless of location and all employees in New York.
    Explanation
    The correct answer is "All managers regardless of location and all employees in New York." This means that the rows displayed will include all managers, regardless of their location, as well as all employees located in New York.

    Rate this question:

  • 9. 

    You have a criteria range that you thought would select marketing reps with sales greater than $1,000,000.  When you apply the filter, all rows are displayed.  What is the most likely reason for this?

    • A.

      You used an OR instead of an AND in your criteria range.

    • B.

      You have a blank row in the criteria range.

    • C.

      You have a blank row in the list.

    • D.

      You mistyped the field names in the criteria range.

    Correct Answer
    B. You have a blank row in the criteria range.
    Explanation
    The most likely reason for all rows being displayed when applying the filter is that there is a blank row in the criteria range. This blank row is causing the filter to not properly evaluate the condition for selecting marketing reps with sales greater than $1,000,000. As a result, all rows are being displayed instead of only those that meet the specified criteria.

    Rate this question:

  • 10. 

    To open a dialog box showing all the range names you have defined, use the:

    • A.

      Edit Names comand

    • B.

      Go To command

    • C.

      View Names command

    • D.

      List Names command

    Correct Answer
    B. Go To command
    Explanation
    The Go To command is used to navigate to a specific location or range in a document. In this context, it can be used to open a dialog box showing all the range names that have been defined. By selecting the Go To command, the user can access a list of range names, allowing for easier navigation and management of the defined ranges in the document.

    Rate this question:

  • 11. 

    You have a list containing all the employees in your organization.  You elect the AutoFilter command, and then select New York from the location field.  What is the result?

    • A.

      The list is sorted by city, with New York first.

    • B.

      The rows where the location is New York are written to another worksheet.

    • C.

      The rows where the location is not New York are deleted.

    • D.

      The rows where the location is not New York are hidden.

    Correct Answer
    D. The rows where the location is not New York are hidden.
    Explanation
    The correct answer is that the rows where the location is not New York are hidden. When you use the AutoFilter command and select New York from the location field, the filter will hide all the rows that do not have New York as the location. This allows you to focus on the employees located in New York and hide the information of employees from other locations.

    Rate this question:

  • 12. 

    You want to show total sales for each location.  What should you do before executing the Subtotals command?

    • A.

      Sort by Sales, in ascending order.

    • B.

      Sort by sales, in descending order.

    • C.

      Sort by sales, in either ascending or descending order, then by Location.

    • D.

      Sort by Location, in either ascending or descending order.

    Correct Answer
    D. Sort by Location, in either ascending or descending order.
    Explanation
    Before executing the Subtotals command, you should sort by Location in either ascending or descending order. This is because the Subtotals command groups data based on a specific column, in this case, the Location column. By sorting the data by Location, you ensure that the sales for each location are grouped together, allowing you to accurately calculate the total sales for each location.

    Rate this question:

  • 13. 

    You use DAVERAGE function.  No rows match your criteria.  What is the result of the function?

    • A.

      ###########

    • B.

      The #REF! error message

    • C.

      A circular reference

    • D.

      The #DIV/0 error message

    Correct Answer
    D. The #DIV/0 error message
    Explanation
    The result of the function is the #DIV/0 error message. This error message occurs when the DAVERAGE function is unable to find any rows that match the specified criteria. It indicates that there are no valid values to calculate an average from, resulting in a division by zero error.

    Rate this question:

  • 14. 

    Which method will correctly import data from an Acess database into Excel?

    • A.

      Use the Query Wizard.

    • B.

      Use the Text Import Wizard.

    • C.

      Use the Import External Data Wizard.

    • D.

      You cannot import data from Access into Excel.

    Correct Answer
    C. Use the Import External Data Wizard.
    Explanation
    The Import External Data Wizard is the correct method to import data from an Access database into Excel. This wizard allows users to select the specific Access database file and choose the tables or queries to import into Excel. It provides a step-by-step process to guide users through the importation, ensuring that the data is correctly transferred and formatted in Excel. The Query Wizard and Text Import Wizard are not suitable for importing data from Access, and the statement that you cannot import data from Access into Excel is incorrect.

    Rate this question:

  • 15. 

    You have a list containing all the employees in your organization.  You want to generate two sets of subtotals: the number of employees in each office, and within each office, the number of employees by job title.   How can you accomplish this?

    • A.

      You cannot accomplish what the question asks.

    • B.

      Sort the list by office, generate subtotals, resort by title, and then generate subtotals again. Use the COUNT summary function for both subtotals.

    • C.

      Sort the list by office, then by title and generate subtotals in both fields. Use the COUNT summary function for both fields.

    • D.

      Sort the list by office, then by ttle. Generate subtotals on the office field using the COUNT function. Generate subtotals on the title field using the COUNT field and then clearing the check box to replace the current subtotals.

    Correct Answer
    D. Sort the list by office, then by ttle. Generate subtotals on the office field using the COUNT function. Generate subtotals on the title field using the COUNT field and then clearing the check box to replace the current subtotals.
  • 16. 

    You have created a PivotTable and make some changes to the cells underlying the PivotTable.  How can you update the information in the PivotTable?

    • A.

      Click the cell(s) you changed, and then use the Refresh PivotTable command.

    • B.

      Click the PivotTable, and then use the Refresh command.

    • C.

      PivotTables are automatically updated once you alter the data.

    • D.

      Once created, PivotTables cannot be updated.

    Correct Answer
    B. Click the PivotTable, and then use the Refresh command.
    Explanation
    To update the information in a PivotTable after making changes to the underlying cells, you need to click on the PivotTable and then use the Refresh command. This will ensure that the PivotTable reflects the updated data from the cells. The other options provided in the question are not correct.

    Rate this question:

  • 17. 

    You have created a PivotChart showwing sales by quarter by sales rep.  Before presenting it ti management, you notice the name of a rep who has since been fired.  How do you delete this rep from the chart without deleting the data?

    • A.

      Click the arrow next to the Sales Rep field and remove the employees name.

    • B.

      Make the emloyee's data points and axis titles invisible.

    • C.

      You can't delete the rep from the chart without first deleting the data.

    • D.

      Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart.

    Correct Answer
    A. Click the arrow next to the Sales Rep field and remove the employees name.
    Explanation
    To delete the rep from the chart without deleting the data, you can click the arrow next to the Sales Rep field and remove the employee's name. This action will remove the rep's data from the chart while keeping the data intact.

    Rate this question:

  • 18. 

    A binary digit that acts like a switch and can be stored as a 1 or a 0 is a:

    • A.

      Byte

    • B.

      Gig

    • C.

      Bit

    • D.

      Hertz

    • E.

      Kilobyte

    Correct Answer
    C. Bit
    Explanation
    A binary digit that acts like a switch and can be stored as a 1 or a 0 is called a bit. In computing, bits are the basic building blocks of data storage and processing. They represent the smallest unit of information and are used to represent and manipulate data in binary form.

    Rate this question:

  • 19. 

    A collection of 8 bits, which is 256 unique combinations of 1's and 0's is referred to as a coding scheme called:

    • A.

      Binary

    • B.

      HTML

    • C.

      ASCII

    • D.

      XML

    • E.

      Octadecimal

    Correct Answer
    C. ASCII
    Explanation
    ASCII stands for American Standard Code for Information Interchange. It is a widely used character encoding scheme that represents text in computers and other devices. ASCII uses 8 bits, which allows for 256 unique combinations of 1's and 0's. Each combination represents a specific character, such as letters, numbers, punctuation marks, and control characters. Therefore, ASCII is the correct coding scheme referred to in the question.

    Rate this question:

  • 20. 

    A byte contains how many bits?

    • A.

      10

    • B.

      1000

    • C.

      256

    • D.

      8

    • E.

      64

    Correct Answer
    D. 8
    Explanation
    A byte contains 8 bits.

    Rate this question:

  • 21. 

    A Character can be any of the following except which one?

    • A.

      A

    • B.

      $

    • C.

      _

    • D.

      8

    • E.

      B

    Correct Answer
    D. 8
    Explanation
    The given options consist of various characters, including letters (A, b), special characters ($, _), and a number (8). The question asks for an exception, meaning we need to identify the option that does not fit the given criteria. As all the options except "8" are characters, the correct answer is "8".

    Rate this question:

  • 22. 

    A collection of related characters that make up the category is called a:

    • A.

      File

    • B.

      Table

    • C.

      Record

    • D.

      Field

    • E.

      Range

    Correct Answer
    D. Field
    Explanation
    A collection of related characters that make up the category is called a field. In database management systems, a field represents a single piece of data within a record. It is the smallest unit of information and is used to store specific types of data, such as names, dates, or numbers. Fields are organized into records, which in turn are organized into tables or files, allowing for efficient storage and retrieval of data.

    Rate this question:

  • 23. 

    A collection of records is called a:

    • A.

      Field

    • B.

      Group

    • C.

      Table

    • D.

      Query

    • E.

      Record

    Correct Answer
    E. Record
    Explanation
    A collection of records is commonly referred to as a "record." This term is used to describe a single set of data that contains information about a specific entity or object. In a database or spreadsheet, multiple records are grouped together to form a table, which organizes and stores data in a structured manner. Therefore, the correct answer for this question is "Record."

    Rate this question:

  • 24. 

    A collection of records is called a:

    • A.

      File

    • B.

      Table

    • C.

      Database

    • D.

      Worksheet

    • E.

      Group

    Correct Answer
    A. File
    Explanation
    A collection of records is commonly referred to as a file. This term is used to describe a structured set of data that is stored in a computer system. Files can contain various types of information, such as text, images, or spreadsheets. They are typically organized and stored in a hierarchical manner, allowing for easy retrieval and manipulation of data. Files are an essential component of computer systems and are used for various purposes, including data storage, data transfer, and data processing.

    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
  • Apr 28, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 02, 2009
    Quiz Created by
    Usaeagg2
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.