Multiple choice test covering Excel 2007 data tables Pivot Tables and charts
The field names must be entered in the forst row of the list.
The field names will change from record to record.
Each field name must be unique.
The fields will be in the same order in every record.
Insert a comment in the upper-left corner of the list.
Insert a blank row between the field names and the data.
Insert a blank row and a blank column between the list and other data in the sheet.
Type a row of dashes (---) after the last row of the list.
Branch office is the primary key and should be in ascending order.
Salary is the primary key and should be in descending order.
Salary is the primary key and should be in ascending order.
Branch office is the primary key and should be in descending order.
Sort by location ascending, then by salary ascending.
Sort by location ascending, then by salary descending.
Sort by salary descending, than by location ascending.
Sort by location descending, then by salary ascending.
One
Two
Three
Unlimited
HTML files
Database files.
ASCII files
Graphic files
Have one column entry for the salary field, with >50000 in one row and
Have two column entries for the salary field, with >50000 in one column and
Have two column entries for the salary field, with >50000 in one column and
It is not possible to set up the criteria range to enable this.
All managers in New York.
All managers regardless of location and all employees in New York.
All managers except those in New York.
All managers except those in New York and all New York employees
You used an OR instead of an AND in your criteria range.
You have a blank row in the criteria range.
You have a blank row in the list.
You mistyped the field names in the criteria range.
Edit Names comand
Go To command
View Names command
List Names command
The list is sorted by city, with New York first.
The rows where the location is New York are written to another worksheet.
The rows where the location is not New York are deleted.
The rows where the location is not New York are hidden.
Sort by Sales, in ascending order.
Sort by sales, in descending order.
Sort by sales, in either ascending or descending order, then by Location.
Sort by Location, in either ascending or descending order.
###########
The #REF! error message
A circular reference
The #DIV/0 error message
Use the Query Wizard.
Use the Text Import Wizard.
Use the Import External Data Wizard.
You cannot import data from Access into Excel.
You cannot accomplish what the question asks.
Sort the list by office, generate subtotals, resort by title, and then generate subtotals again. Use the COUNT summary function for both subtotals.
Sort the list by office, then by title and generate subtotals in both fields. Use the COUNT summary function for both fields.
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.
Click the cell(s) you changed, and then use the Refresh PivotTable command.
Click the PivotTable, and then use the Refresh command.
PivotTables are automatically updated once you alter the data.
Once created, PivotTables cannot be updated.
Click the arrow next to the Sales Rep field and remove the employees name.
Make the emloyee's data points and axis titles invisible.
You can't delete the rep from the chart without first deleting the data.
Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart.
Byte
Gig
Bit
Hertz
Kilobyte
Binary
HTML
ASCII
XML
Octadecimal
10
1000
256
8
64
A
$
_
8
B
File
Table
Record
Field
Range
Field
Group
Table
Query
Record
File
Table
Database
Worksheet
Group
Wait!
Here's an interesting quiz for you.