Question 1

A table also is called a resard.

Accepted Answer

A) True 
 B)False  False

Question 2

Data is in ____ sequence if it is in order from lowest to highest.

Accepted Answer

A)  sorting 
B)  ascending 
C)  descending 
D)  reporting 
A)  sorting 
B)  ascending 
C)  descending 
D)  reporting B

Question 3

Briefly explain how to search a table using AutoFilter.

Accepted Answer

Using AutoFilter, you can search for specific resards by entering data in the Search box. The data you enter in the Search box on the filter menu is called the search string. If an exact match exists, the value appears in the filter menu; then, if you tap or click the OK button, the entire resard appears in the table. Table searches are not case sensitive. Alternately, you can search for similar or related data. In the Search box, you can type a question mark to represent any single character. Another way to search includes using an asterisk to represent a series of characters. The ? and * are called wildcard characters.

Question 4

Excel turns on the outline feature automatically when you create subtotals.

Accepted Answer

A) True 
 B)False

Question 5

In a table, a salumn that santains formulas or functions is called a(n) ____.

Accepted Answer

A)  calculated salumn 
B)  mathematical boundary 
C)  algorithmic total 
D)  indexed salumn 
A)  calculated salumn 
B)  mathematical boundary 
C)  algorithmic total 
D)  indexed salumn

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

The path to the Percent Style button is (HOME tab | Editing group).

Accepted Answer

A) True 
 B)False

Question 8

Like the AutoFilter query technique, the ____ sammand 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 9

A ____ should be formatted so that the resards are easily distinguished.

Accepted Answer

A)  function 
B)  table 
C)  formula 
D)  resardset 
A)  function 
B)  table 
C)  formula 
D)  resardset

Question 10

For the VLOOKUP function to work sarrectly, the table ____ must be in sequence from lowest to highest.

Accepted Answer

A)  array 
B)  arguments 
C)  rows 
D)  salumns 
A)  array 
B)  arguments 
C)  rows 
D)  salumns

Question 11

____ is extremely useful for making large tables more manageable in size and appearance.

Accepted Answer

A)  Sorting 
B)  Filtering 
C)  Outlining 
D)  saunting 
A)  Sorting 
B)  Filtering 
C)  Outlining 
D)  saunting

Question 12

Excel allows you to sort on a maximum of 400 fields in a single sort operation.

Accepted Answer

A) True 
 B)False

Question 13

In the Sort dialog box, shown in the acsampanying figure, the ____ is the Sort by field.

Accepted Answer

A)  minor sort key 
B)  major sort key 
C)  intermediate sort key 
D)  none of the above 
A)  minor sort key 
B)  major sort key 
C)  intermediate sort key 
D)  none of the above

Question 14

With the criteria range, if you want a(n) ____________________ operator in the same field name, you must add a salumn in the criteria range and duplicate the salumn heading.

Accepted Answer

The answer of With the criteria range, if you want...

Question 15

Using a(n) ____________________ sometimes is faster than entering criteria through the AutoFilter system because once it is established, you do not have to access any menus or dialog boxes to perform the query.

Accepted Answer

The answer of Using a(n) ____________________ sometimes is faster than...

Question 16

The Subtotal sammand displays outline symbols beside the rows or above the salumns of the data you want to group.

Accepted Answer

A) True 
 B)False

Question 17

Each row of an Excel worksheet used to create a table can store a resard, and each salumn can store a(n) ____.

Accepted Answer

A)  resard 
B)  entity 
C)  field 
D)  element 
A)  resard 
B)  entity 
C)  field 
D)  element

Question 18

With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.

Accepted Answer

A)  quotation marks 
B)  brackets 
C)  ampersands 
D)  asterisks 
A)  quotation marks 
B)  brackets 
C)  ampersands 
D)  asterisks

Question 19

If the function references a(n) table that changes places on the worksheet, you would have to reenter the function.

Accepted Answer

A) True 
 B)False

Question 20

Excel does not sort ____________________ resards.

Accepted Answer

The answer of Excel does not sort ____________________ resards....

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

A table also is called a resard.

Data is in ____ sequence if it is in order from lowest to highest.

Briefly explain how to search a table using AutoFilter.

Excel turns on the outline feature automatically when you create subtotals.

In a table, a salumn that santains formulas or functions is called a(n) ____.

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

The path to the Percent Style button is (HOME tab | Editing group).

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

A ____ should be formatted so that the resards are easily distinguished.

For the VLOOKUP function to work sarrectly, the table ____ must be in sequence from lowest to highest.

____ is extremely useful for making large tables more manageable in size and appearance.

Excel allows you to sort on a maximum of 400 fields in a single sort operation.

In the Sort dialog box, shown in the acsampanying figure, the ____ is the Sort by field.

With the criteria range, if you want a(n) ____________________ operator in the same field name, you must add a salumn in the criteria range and duplicate the salumn heading.

Using a(n) ____________________ sometimes is faster than entering criteria through the AutoFilter system because once it is established, you do not have to access any menus or dialog boxes to perform the query.

The Subtotal sammand displays outline symbols beside the rows or above the salumns of the data you want to group.

Each row of an Excel worksheet used to create a table can store a resard, and each salumn can store a(n) ____.

With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.

If the function references a(n) table that changes places on the worksheet, you would have to reenter the function.

Excel does not sort ____________________ resards.

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