Excel 2007 Data Tables, Pivot Tables, Pivot Charts

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

Use the Query Wizard.

Use the Text Import Wizard.

Use the Import External Data Wizard.

You cannot import data from Access into Excel.

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.

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.

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

Byte

Gig

Bit

Hertz

Kilobyte

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.

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.

3. 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?

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.

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.

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.

4. A byte contains how many bits?

10

1000

256

8

64

A byte contains 8 bits.

Explanation

A byte contains 8 bits.

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

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.

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.

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.

6. 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?

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.

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.

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.

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

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.

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.

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.

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

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.

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.

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.

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

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.

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.

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.

10. All of the following statements regarding fields are true except:

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.

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.

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.

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

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.

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.

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.

12. 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?

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

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

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 "

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 "

13. 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?

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

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.

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.

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

HTML files

Database files.

ASCII files

Graphic files

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.

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.

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

###########

The #REF! error message

A circular reference

The #DIV/0 error message

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.

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.

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

File

Table

Record

Field

Range

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.

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.

17. The maximum number of keys you can sort by is?

One

Two

Three

Unlimited

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.

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.

18. 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?

You cannot accomplish what the question asks.

not-available-via-ai

Explanation

not-available-via-ai

19. 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?

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.

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.

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.

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

Edit Names comand

Go To command

View Names command

List Names command

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.

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.

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

A

$

_

8

B

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

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

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

Binary

HTML

ASCII

XML

Octadecimal

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.

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.

23. A collection of records is called a:

File

Table

Database

Worksheet

Group

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.

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.

24. A collection of records is called a:

Field

Group

Table

Query

Record

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

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