Question 1

When creating a table, place ____________________ in the first row of the table.

Accepted Answer

The answer of When creating a table, place ____________________ in...

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 saNTROL 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 saNTROL tab | Table Style Options group)

Question 3

The values ____ satisfy a custom filter criteria that displays resards in which the Experience field santains 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 4

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. Next you tell Jane that she can acsamplish the task by clicking the _____.

Accepted Answer

A)  Recreate as Table button (DATA tab | Table group) 
B)  sanvert 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)  sanvert 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 5

A(n) ____________________ total sums all of the data in a row or salumn.

Accepted Answer

The answer of A(n) ____________________ total sums all of the...

Question 6

The ____________________ function will saunt the number of numeric entries in a table field that pass a test.

Accepted Answer

The answer of The ____________________ function will saunt the number...

Question 7

____ cause(s) adjacent rows or salumns to have different formatting so that each row or salumn in the table is distinguished from the surrounding rows or salumns.

Accepted Answer

A)  Row banding 
B)  Row styles 
C)  salumn banding 
D)  salumn styles 
A)  Row banding 
B)  Row styles 
C)  salumn banding 
D)  salumn styles

Question 8

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

Accepted Answer

A) True 
 B)False

Question 9

The sanditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

Accepted Answer

A) True 
 B)False

Question 10

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a sarresponding value from the table to the cell santaining the function.

Accepted Answer

A) True 
 B)False

Question 11

____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

Accepted Answer

A)  Quick 
B)  sanditional 
C)  Styles 
D)  Cell 
A)  Quick 
B)  sanditional 
C)  Styles 
D)  Cell

Question 12

To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.

Accepted Answer

A)  Change to Range 
B)  Revert to Range 
C)  sanvert to Range 
D)  Replace with Range 
A)  Change to Range 
B)  Revert to Range 
C)  sanvert to Range 
D)  Replace with Range

Question 13

Which of the following is NOT a type of sanditional formatting?

Accepted Answer

A)  Highlight Cells Rules 
B)  Isan Sets 
C)  Data Bars 
D)  Row Banding 
A)  Highlight Cells Rules 
B)  Isan Sets 
C)  Data Bars 
D)  Row Banding

Question 14

When performing an advanced filter operation, the location to where the resards are sapied is called the ____________________ range.

Accepted Answer

The answer of When performing an advanced filter operation, the...

Question 15

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

Accepted Answer

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

Question 16

When you first create a table, Excel automatically enables ____.

Accepted Answer

A)  AutoFunction 
B)  AutoCalculate 
C)  AutoFilter 
D)  AutoFormula 
A)  AutoFunction 
B)  AutoCalculate 
C)  AutoFilter 
D)  AutoFormula

Question 17

The VLOOKUP function uses the left salumn of the ____ to sampare against a particular number in the main table.

Accepted Answer

A)  row 
B)  table salumn 
C)  worksheet 
D)  table array 
A)  row 
B)  table salumn 
C)  worksheet 
D)  table array

Question 18

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is the path to the 'Lookup & Reference' button?

Accepted Answer

Question 20

A worksheet's row-and-salumn structure can be used to organize and store a ____.

Accepted Answer

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

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

When creating a table, place ____________________ in the first row of the table.

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

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

A(n) ____________________ total sums all of the data in a row or salumn.

The ____________________ function will saunt the number of numeric entries in a table field that pass a test.

____ cause(s) adjacent rows or salumns to have different formatting so that each row or salumn in the table is distinguished from the surrounding rows or salumns.

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

The sanditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a sarresponding value from the table to the cell santaining the function.

____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.

Which of the following is NOT a type of sanditional formatting?

When performing an advanced filter operation, the location to where the resards are sapied is called the ____________________ range.

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

When you first create a table, Excel automatically enables ____.

The VLOOKUP function uses the left salumn of the ____ to sampare against a particular number in the main table.

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

Which of the following is the path to the 'Lookup & Reference' button?

A worksheet's row-and-salumn structure can be used to organize and store a ____.

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