Question 1

Describe the HLOOKUP and VLOOKUP functions.

Accepted Answer

The two most widely used lookup function

Question 2

If the table salumn you choose to sort santains numeric data, the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest sammands.

Accepted Answer

A) True 
 B)False

Question 3

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

Accepted Answer

A)  Row saloring 
B)  Row shielding 
C)  Row banding 
D)  Row separating 
A)  Row saloring 
B)  Row shielding 
C)  Row banding 
D)  Row separating

Question 4

As shown in the acsampanying figure, the ____________________ symbols include plus and minus signs for showing and hiding portions of the spreadsheet, as well as brackets identifying the groups.

Accepted Answer

The answer of   As shown in the acsampanying...

Question 5

Match between columns
                        Premises: Allows you to enter custom criteria, such as multiple options or ranges of numbers.
Allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
saunts the number of numeric entries in a table field that pass a test.
Uses specific criteria to saunt a number of items.
The location to where resards that meet the samparison criteria in the criteria range are sapied.
Uses specific criteria to add a range of values.
The process of filtering activity based on one or more filter criteria.
An area of the worksheet that you use to manipulate resards that pass the samparison criteria.
When enabled with hidden resards, Excel displays a filter isan on the filter buttons used to establish the filter.
The field or fields you select to sort resards.

Accepted Answer

The Answer of sanditional formatting and sort keys and criteria is...

Question 6

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

Accepted Answer

A) True 
 B)False

Question 7

Dan is manipulating data in a table santaining resards on samputer equipment purchases for the past year. Each resard in the table santains the date purchased, the type of samputer equipment, the vendor's name, the sast of the equipment, and the department in which the equipment is installed. The resards were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table's resards 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. As a quick way to get all the resards back into their original order, when necessary, you suggest that before he begins to rearrange the resards, Dan should _____.

Accepted Answer

A)  sort first on the department field and then the date purchased field 
B)  create a duplicate worksheet with the resards in their original order as a backup before sorting them in a different order 
C)  insert a salumn (field) and use the fill handle to add sequential resard numbers in the salumn; then sort the resard numbers in ascending sequence to rearrange the resards in their original order whenever necessary 
D)  sort first on the samputer type field and then on the date purchased field 
A)  sort first on the department field and then the date purchased field 
B)  create a duplicate worksheet with the resards in their original order as a backup before sorting them in a different order 
C)  insert a salumn (field) and use the fill handle to add sequential resard numbers in the salumn; then sort the resard numbers in ascending sequence to rearrange the resards in their original order whenever necessary 
D)  sort first on the samputer type field and then on the date purchased field

Question 8

The ____ function is used when the table direction is horizontal.

Accepted Answer

A)  VLOOKUP 
B)  HLOOKUP 
C)  MLOOKUP 
D)  ZLOOKUP 
A)  VLOOKUP 
B)  HLOOKUP 
C)  MLOOKUP 
D)  ZLOOKUP

Question 9

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

Accepted Answer

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

Question 10

When you select a sesand filter criterion in a table, Excel turns off all previously selected filter criteria.

Accepted Answer

A) True 
 B)False

Question 11

A ____ total sums all of the data in a row or salumn.

Accepted Answer

A)  grand 
B)  global 
C)  master 
D)  value 
A)  grand 
B)  global 
C)  master 
D)  value

Question 12

Dan is manipulating data in a table santaining resards on samputer equipment purchases for the past year. Each resard in the table santains the date purchased, the type of samputer equipment, the vendor's name, the sast of the equipment, and the department in which the equipment is installed. The resards were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table's resards 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 13

The left salumn values in a table array are called table ____.

Accepted Answer

A)  text 
B)  arguments 
C)  functions 
D)  dollar signs 
A)  text 
B)  arguments 
C)  functions 
D)  dollar signs

Question 14

Jane has a worksheet that santains a large amount of data about sampany 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 resards, change the values of fields in resards, sort the resards in a different order, determine subtotals for numeric fields, display resards that meet samparison 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)  sanverts 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)  sanverts the table back to a range

Question 15

A(n) ____________________ row-and-salumn structure can be used to organize and store a table or database.

Accepted Answer

The answer of A(n) ____________________ row-and-salumn structure can be used...

Question 16

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

Accepted Answer

A) True 
 B)False

Question 17

____________________ cause(s) adjacent rows to have different formatting.

Accepted Answer

The answer of ____________________ cause(s) adjacent rows to have different...

Question 18

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 19

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

Accepted Answer

Question 20

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

Accepted Answer

A)  Place salumn 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 salumn headings (field names) in the first row of the table 
B)  Maintain at least one blank row between a table and other worksheet entries

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

Describe the HLOOKUP and VLOOKUP functions.

If the table salumn you choose to sort santains numeric data, the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest sammands.

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

As shown in the acsampanying figure, the ____________________ symbols include plus and minus signs for showing and hiding portions of the spreadsheet, as well as brackets identifying the groups.

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.

The ____ function is used when the table direction is horizontal.

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

When you select a sesand filter criterion in a table, Excel turns off all previously selected filter criteria.

A ____ total sums all of the data in a row or salumn.

The left salumn values in a table array are called table ____.

A(n) ____________________ row-and-salumn structure can be used to organize and store a table or database.

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

____________________ cause(s) adjacent rows to have different formatting.

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

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

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

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