Excel 2007 Data Tables, Pivot Tables, Pivot Charts

24 Questions | Total Attempts: 432

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

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


Questions and Answers
  • 1. 
    • 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.

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

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

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

  • 5. 
    The maximum number of keys you can sort by is?
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Unlimited

  • 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

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

  • 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

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

  • 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

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

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

  • 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

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

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

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

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

  • 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

  • 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

  • 20. 
    A byte contains how many bits?
    • A. 

      10

    • B. 

      1000

    • C. 

      256

    • D. 

      8

    • E. 

      64

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

      A

    • B. 

      $

    • C. 

      _

    • D. 

      8

    • E. 

      B

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

      File

    • B. 

      Table

    • C. 

      Record

    • D. 

      Field

    • E. 

      Range

  • 23. 
    A collection of records is called a:
    • A. 

      Field

    • B. 

      Group

    • C. 

      Table

    • D. 

      Query

    • E. 

      Record

  • 24. 
    A collection of records is called a:
    • A. 

      File

    • B. 

      Table

    • C. 

      Database

    • D. 

      Worksheet

    • E. 

      Group