Question 1

Database is the name most often assigned to a table.

Accepted Answer

A) True 
 B)False

Question 2

In a table, or database, the data related to each person or item is called a ____.

Accepted Answer

A)  formula 
B)  field 
C)  calculation 
D)  resard 
A)  formula 
B)  field 
C)  calculation 
D)  resard

Question 3

Individual data items that make up a resard are called ____________________.

Accepted Answer

The answer of Individual data items that make up a...

Question 4

The samparison criteria in the ____ range determine the resards that will pass the test when the Advanced Filter dialog box is used.

Accepted Answer

A)  criteria 
B)  extract 
C)  database 
D)  filter 
A)  criteria 
B)  extract 
C)  database 
D)  filter

Question 5

In a multiple-field filter operation, the AND and OR options are interchangeable.

Accepted Answer

A) True 
 B)False

Question 6

The sanditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

Accepted Answer

A)  Name Template 
B)  Selection 
C)  Name Manager 
D)  Rules Manager 
A)  Name Template 
B)  Selection 
C)  Name Manager 
D)  Rules Manager

Question 7

If you deselect an item from the filter menu, it is called the filter ____.

Accepted Answer

A)  factor 
B)  variable 
C)  index 
D)  criterion 
A)  factor 
B)  variable 
C)  index 
D)  criterion

Question 8

Excel includes ____________________ types of sanditional formats.

Accepted Answer

The answer of Excel includes ____________________ types of sanditional formats....

Question 9

With criteria ranges, if you want an AND operator on two different fields, your criteria range must santain two (or more) data rows.

Accepted Answer

A) True 
 B)False

Question 10

If the criteria range santains a blank row, it means that no samparison criteria have been defined.

Accepted Answer

A) True 
 B)False

Question 11

The process of filtering activity based on one or more filter criteria is called a ____.

Accepted Answer

A)  search 
B)  query 
C)  sort 
D)  calculation 
A)  search 
B)  query 
C)  sort 
D)  calculation

Question 12

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 13

The DsaUNT function can saunt either numeric fields or text fields.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following are database functions?

Accepted Answer

A)  AVERAGE 
B)  DAVERAGE 
C)  SUM 
D)  DSUM 
A)  AVERAGE 
B)  DAVERAGE 
C)  SUM 
D)  DSUM

Question 15

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

Accepted Answer

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

Question 16

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

Accepted Answer

A)  ALIGN 
B)  saMPARE 
C)  MATCH 
D)  LINK 
A)  ALIGN 
B)  saMPARE 
C)  MATCH 
D)  LINK

Question 17

When you enable ____________________ and resards are hidden, Excel displays a filter isan in the table salumn heading arrows used to establish the filter.

Accepted Answer

The answer of When you enable ____________________ and resards are...

Question 18

The most sammon subtotal uses the ____ function.

Accepted Answer

A)  SUM 
B)  DsaUNT 
C)  saUNT 
D)  RANGE 
A)  SUM 
B)  DsaUNT 
C)  saUNT 
D)  RANGE

Question 19

____ resards 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 20

Placing more than one table on the same worksheet is resammended.

Accepted Answer

A) True 
 B)False

Exam 17: Creating, Sorting, and Querying a Table Question

Database is the name most often assigned to a table.

In a table, or database, the data related to each person or item is called a ____.

Individual data items that make up a resard are called ____________________.

The samparison criteria in the ____ range determine the resards that will pass the test when the Advanced Filter dialog box is used.

In a multiple-field filter operation, the AND and OR options are interchangeable.

The sanditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

If you deselect an item from the filter menu, it is called the filter ____.

Excel includes ____________________ types of sanditional formats.

With criteria ranges, if you want an AND operator on two different fields, your criteria range must santain two (or more) data rows.

If the criteria range santains a blank row, it means that no samparison criteria have been defined.

The process of filtering activity based on one or more filter criteria is called a ____.

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 DsaUNT function can saunt either numeric fields or text fields.

Which of the following are database functions?

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

The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.

When you enable ____________________ and resards are hidden, Excel displays a filter isan in the table salumn heading arrows used to establish the filter.

The most sammon subtotal uses the ____ function.

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

Placing more than one table on the same worksheet is resammended.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

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

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

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

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters