Question 1

Which of the following is an option to distribute a document electronically?

Accepted Answer

A)  sending a document via email 
B)  posting the file on cloud storage 
C)  posting it on a blog 
D)  posting it on a social networking site 
A)  sending a document via email 
B)  posting the file on cloud storage 
C)  posting it on a blog 
D)  posting it on a social networking site

Question 2

Which of the following is the path to the Total Row check box?

Accepted Answer

A)  (TABLE TOOLS FORMAT tab | Table Style Options group) 
B)  (TABLE TOOLS LAYOUT tab | Table Options group) 
C)  (TABLE TOOLS DESIGN tab | Table Style Options group) 
D)  (TABLE TOOLS CONTROL tab | Table Style Options group) 
A)  (TABLE TOOLS FORMAT tab | Table Style Options group) 
B)  (TABLE TOOLS LAYOUT tab | Table Options group) 
C)  (TABLE TOOLS DESIGN tab | Table Style Options group) 
D)  (TABLE TOOLS CONTROL tab | Table Style Options group)

Question 3

Critical Thinking Questions Case 6-2 Dan is manipulating data in a table containing records on computer equipment purchases for the past year. Each record in the table contains the date purchased, the type of computer equipment, the vendor's name, the cost of the equipment, and the department in which the equipment is installed. The records were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table's records to see all the purchases from each vendor in date order within each department. He also wants to know a quick way to get the data back into its original order, whenever necessary. To rearrange the data, you suggest that Dan create a custom sort by setting the ____.

Accepted Answer

A)  purchase date field as the major sort key, the vendor field as the intermediate sort key, and the department field as the minor sort key 
B)  vendor field as the major sort key, the department field as the intermediate sort key, and the purchase date field as the minor sort key 
C)  purchase date field as the major sort key, the department field as the intermediate sort key, and the vendor as the minor sort key 
D)  department field as the major sort key, the vendor field as the intermediate sort key, and the purchase date field as the minor sort key 
A)  purchase date field as the major sort key, the vendor field as the intermediate sort key, and the department field as the minor sort key 
B)  vendor field as the major sort key, the department field as the intermediate sort key, and the purchase date field as the minor sort key 
C)  purchase date field as the major sort key, the department field as the intermediate sort key, and the vendor as the minor sort key 
D)  department field as the major sort key, the vendor field as the intermediate sort key, and the purchase date field as the minor sort key

Question 4

Describe the HLOOKUP and VLOOKUP functions.

Accepted Answer

The two most widely used lookup function

Question 5

Like the AutoFilter query technique, the ____ command displays a subset of the table.

Accepted Answer

A)  Advanced Filter 
B)  Advanced Sort 
C)  Advanced Formatting 
D)  Advanced Functions 
A)  Advanced Filter 
B)  Advanced Sort 
C)  Advanced Formatting 
D)  Advanced Functions

Question 6

The DCOUNT function can count either numeric fields or text fields.

Accepted Answer

A) True 
 B)False

Question 7

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

Accepted Answer

A)  4 
B)  8 
C)  12 
D)  16 
A)  4 
B)  8 
C)  12 
D)  16

Question 8

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is the path to the Format as Table button?

Accepted Answer

Question 10

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

Accepted Answer

A)  1, 2, 3 
B)  3, 4, 5 
C)  5, 6, 7 
D)  none of the above 
A)  1, 2, 3 
B)  3, 4, 5 
C)  5, 6, 7 
D)  none of the above

Question 11

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

Accepted Answer

A)  INDEX 
B)  NEXUS 
C)  MATCH 
D)  NODE 
A)  INDEX 
B)  NEXUS 
C)  MATCH 
D)  NODE

Question 12

Critical Thinking Questions Case 6-1 Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this. Next you tell Jane that she can accomplish the task by clicking the _____.

Accepted Answer

A)  Recreate as Table button (DATA tab | Table group) 
B)  Convert to Table button (HOME tab | Styles group) 
C)  Format as Table button (HOME tab | Styles group) 
D)  Apply Table Formatting button (LAYOUT tab | Styles group) 
A)  Recreate as Table button (DATA tab | Table group) 
B)  Convert to Table button (HOME tab | Styles group) 
C)  Format as Table button (HOME tab | Styles group) 
D)  Apply Table Formatting button (LAYOUT tab | Styles group)

Question 13

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Accepted Answer

A)  Sorting 
B)  Filtering 
C)  Extracting 
D)  Formatting 
A)  Sorting 
B)  Filtering 
C)  Extracting 
D)  Formatting

Question 14

Modified Multiple Choice Which of the following are guidelines for creating a table in Excel?

Accepted Answer

A)  Place column headings (field names) in the first row of the table 
B)  Maintain at least one blank row between a table and other worksheet entries 
A)  Place column headings (field names) in the first row of the table 
B)  Maintain at least one blank row between a table and other worksheet entries

Question 15

Critical Thinking Questions Case 6-1 Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this. You tell Jane that if she ____, then she can easily add and delete product records, change the values of fields in records, sort the records in a different order, determine subtotals for numeric fields, display records that meet comparison criteria, and analyze data using database functions.

Accepted Answer

A)  deletes the range and reenters the data in a table 
B)  enters a table 
C)  prints the range as a table 
D)  converts the table back to a range 
A)  deletes the range and reenters the data in a table 
B)  enters a table 
C)  prints the range as a table 
D)  converts the table back to a range

Question 16

Each ____________________ in any given table column should have similar data.

Accepted Answer

The answer of Each ____________________ in any given table column...

Question 17

If the function references a(n) range that grows or shrinks, Excel automatically adjusts the first argument if the table grows or shrinks.

Accepted Answer

A) True 
 B)False

Question 18

A check mark in the ____________________ check box on the AutoFilter menu indicates that all values for the selected field are displayed in the table.

Accepted Answer

The answer of A check mark in the ____________________ check...

Question 19

The field or fields selected for sorting records are called ____ keys.

Accepted Answer

A)  label 
B)  record 
C)  field 
D)  sort 
A)  label 
B)  record 
C)  field 
D)  sort

Question 20

The DAVERAGE function requires a numeric field from the table range.

Accepted Answer

A) True 
 B)False

Which of the following is an option to distribute a document electronically?

Which of the following is the path to the Total Row check box?

Describe the HLOOKUP and VLOOKUP functions.

Like the AutoFilter query technique, the ____ command displays a subset of the table.

The DCOUNT function can count either numeric fields or text fields.

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.

Which of the following is the path to the Format as Table button?

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Modified Multiple Choice Which of the following are guidelines for creating a table in Excel?

Each ____________________ in any given table column should have similar data.

If the function references a(n) range that grows or shrinks, Excel automatically adjusts the first argument if the table grows or shrinks.

A check mark in the ____________________ check box on the AutoFilter menu indicates that all values for the selected field are displayed in the table.

The field or fields selected for sorting records are called ____ keys.

The DAVERAGE function requires a numeric field from the table range.

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters

Exam 7: Excell: Creating, Sorting, and Querying a Table

Which of the following is an option to distribute a document electronically?

Which of the following is the path to the Total Row check box?

Describe the HLOOKUP and VLOOKUP functions.

Like the AutoFilter query technique, the ____ command displays a subset of the table.

The DCOUNT function can count either numeric fields or text fields.

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.

Which of the following is the path to the Format as Table button?

The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

Modified Multiple Choice Which of the following are guidelines for creating a table in Excel?

Each ____________________ in any given table column should have similar data.

If the function references a(n) range that grows or shrinks, Excel automatically adjusts the first argument if the table grows or shrinks.

A check mark in the ____________________ check box on the AutoFilter menu indicates that all values for the selected field are displayed in the table.

The field or fields selected for sorting records are called ____ keys.

The DAVERAGE function requires a numeric field from the table range.

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Working With Multiple Worksheets and Workbooks

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters