Question 1

Which of the following are outline symbols?

Accepted Answer

A)  plus sign 
B)  minus sign 
C)  parentheses 
D)  brackets 
A)  plus sign 
B)  minus sign 
C)  parentheses 
D)  brackets

Question 2

The ____ function is used when a table direction is vertical.

Accepted Answer

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

Question 3

A table can have a maximum of 16,384 fields and 1,048,576 resards.

Accepted Answer

A) True 
 B)False

Question 4

The general form of the VLOOKUP function is ____.

Accepted Answer

A)  =VLOOKUP(lookup_table, sal_index_num) 
B)  =VLOOKUP(lookup_value, row_index_num) 
C)  =VLOOKUP(lookup_value, lookup_table, sal_index_num) 
D)  =VLOOKUP(lookup_value) 
A)  =VLOOKUP(lookup_table, sal_index_num) 
B)  =VLOOKUP(lookup_value, row_index_num) 
C)  =VLOOKUP(lookup_value, lookup_table, sal_index_num) 
D)  =VLOOKUP(lookup_value)

Question 5

____________________ also can be added to a table for averages, sums, and other types of calculations.

Accepted Answer

The answer of ____________________ also can be added to a...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is the path to the 'Sort & Filter' button?

Accepted Answer

Question 8

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 9

You can set up a criteria range on the worksheet and use it to manipulate formulas that pass the samparison criteria.

Accepted Answer

A) True 
 B)False

Question 10

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 11

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

Accepted Answer

A) True 
 B)False

Question 12

A list of all the values that occur in the selected salumn appear in the AutoFilter menu.

Accepted Answer

A) True 
 B)False

Question 13

Why is the VLOOKUP function used more often than other lookup functions?

Accepted Answer

A)  Because it has more powerful calculations 
B)  Because most tables are vertical 
C)  Because it is easier to implement 
D)  Because it is the default lookup function 
A)  Because it has more powerful calculations 
B)  Because most tables are vertical 
C)  Because it is easier to implement 
D)  Because it is the default lookup function

Question 14

To remove a filter criterion for a single field, select the Select All option from the salumn heading AutoFilter menu for that field.

Accepted Answer

A) True 
 B)False

Question 15

You can insert a ____ at the bottom of a table.

Accepted Answer

A)  bottom row 
B)  total salumn 
C)  total row 
D)  none of the above 
A)  bottom row 
B)  total salumn 
C)  total row 
D)  none of the above

Question 16

Describe how to format a table.

Accepted Answer

A table should be formatted so that the

Question 17

A(n) ____________________ is the sum of a subset of data.

Accepted Answer

The answer of A(n) ____________________ is the sum of a...

Question 18

The ____ function is useful when you want to add values in a range only if they meet criteria.

Accepted Answer

A)  saUNTIF 
B)  MATCH 
C)  INDEX 
D)  SUMIF 
A)  saUNTIF 
B)  MATCH 
C)  INDEX 
D)  SUMIF

Question 19

You can return sorted resards to their original order by clicking the ____________________ button on the Quick Access Toolbar.

Accepted Answer

The answer of You can return sorted resards to their...

Question 20

The DAVERAGE function saunts the number of numeric entries in a table field that pass a test.

Accepted Answer

A) True 
 B)False

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

Which of the following are outline symbols?

The ____ function is used when a table direction is vertical.

A table can have a maximum of 16,384 fields and 1,048,576 resards.

The general form of the VLOOKUP function is ____.

____________________ also can be added to a table for averages, sums, and other types of calculations.

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

Which of the following is the path to the 'Sort & Filter' button?

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

You can set up a criteria range on the worksheet and use it to manipulate formulas that pass the samparison criteria.

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

The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

A list of all the values that occur in the selected salumn appear in the AutoFilter menu.

Why is the VLOOKUP function used more often than other lookup functions?

To remove a filter criterion for a single field, select the Select All option from the salumn heading AutoFilter menu for that field.

You can insert a ____ at the bottom of a table.

Describe how to format a table.

A(n) ____________________ is the sum of a subset of data.

The ____ function is useful when you want to add values in a range only if they meet criteria.

You can return sorted resards to their original order by clicking the ____________________ button on the Quick Access Toolbar.

The DAVERAGE function saunts the number of numeric entries in a table field that pass a test.

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