Question 1

Filtering the Last_Name field to show only records that begin with the letter P is an application of a(n)________ filter.

Accepted Answer

The answer of Filtering the Last_Name field to show only...

Question 2

The ________ Table Style option applies a different format to the first column of a table so that the row headings stand out.

Accepted Answer

The answer of The ________ Table Style option applies a...

Question 3

What are two built-in functionality features in tables in Excel 2013 that assist in creating formulas?

Accepted Answer

Structured references,a tag or

Question 4

Match between columns
                        Premises: A field
A record
Print order
A table
A print area

Accepted Answer

The Answer of is an individual piece of data. and is...

Question 5

To create a(n)________ from an existing range of data,click the Insert tab and then click Table in the Tables group.

Accepted Answer

The answer of To create a(n)________ from an existing range...

Question 6

The use of field headings without row references in a structured formula is called a(n)________ reference.

Accepted Answer

The answer of The use of field headings without row...

Question 7

In Excel 2013 a dataset:

Accepted Answer

A) indicates where data starts on a new printed page. 
B) is a collection of structured,related data in columns and rows. 
C) is a grouping of similarly formatted worksheets. 
D) is a grouping of worksheets with similar content. 
A) indicates where data starts on a new printed page. 
B) is a collection of structured,related data in columns and rows. 
C) is a grouping of similarly formatted worksheets. 
D) is a grouping of worksheets with similar content.

Question 8

Match between columns
                        Premises: Total row
Conditional formatting
Sum,average,min,max
Structured reference
SUBTOTAL function

Accepted Answer

The Answer of Last row of a table to display is...

Question 9

A structured reference:

Accepted Answer

A) is a tag or use of a table element,such as a field heading. 
B) highlights or emphasizes cells that meet certain conditions. 
C) is a table element that uses relative references in a formula within a table. 
D) formats cells based upon their value in reference to the value of other cells. 
A) is a tag or use of a table element,such as a field heading. 
B) highlights or emphasizes cells that meet certain conditions. 
C) is a table element that uses relative references in a formula within a table. 
D) formats cells based upon their value in reference to the value of other cells.

Question 10

Unfreeze Panes only appears on the menu when you have frozen rows and/or columns.

Accepted Answer

A) True 
 B)False

Question 11

To ________ a table into a range,click within the table,click the Table Tools Design tab,and from the Tools group,select Convert to Range.

Accepted Answer

The answer of To ________ a table into a range,click...

Question 12

A Table style controls:

Accepted Answer

A) check boxes to select format actions such as Total Row. 
B) check boxes to select format actions such as Header Row. 
C) the fill color of the header row and rows of records. 
D) the background and watermarks of a worksheet. 
A) check boxes to select format actions such as Total Row. 
B) check boxes to select format actions such as Header Row. 
C) the fill color of the header row and rows of records. 
D) the background and watermarks of a worksheet.

Question 13

Banded Rows display alternate fill colors for every five sets of rows to distinguish records.

Accepted Answer

A) True 
 B)False

Question 14

Click the ________ tab and click Remove Duplicates to open the Remove Duplicates dialog box.

Accepted Answer

The answer of Click the ________ tab and click Remove...

Question 15

What options are available in the Top 10 AutoFilter dialog box?

Accepted Answer

You can select either Top or B

Question 16

Match between columns
                        Premises: Table style controls
Table Style Options group
Sorting Dates oldest to newest
Sorting Text A to Z
Sorting Values smallest to largest

Accepted Answer

The Answer of fill color of the header row,columns,and records is...

Question 17

In Page Break Preview,the print area has a white background with a dotted blue border.

Accepted Answer

A) True 
 B)False

Question 18

Sorting values smallest to largest:

Accepted Answer

A) arranges names in sequential order. 
B) arranges numbers in sequential order. 
C) arranges dates in alphabetical order. 
D) is the process of displaying only records that meet specific conditions. 
A) arranges names in sequential order. 
B) arranges numbers in sequential order. 
C) arranges dates in alphabetical order. 
D) is the process of displaying only records that meet specific conditions.

Question 19

________ displays alternate fill colors for even and odd rows to help distinguish fields.

Accepted Answer

The answer of ________ displays alternate fill colors for even...

Question 20

________ arranges records in a table by the value in the field or fields within a table.

Accepted Answer

The answer of ________ arranges records in a table by...

Exam 21: Excel: Datasets and Tables: Managing Large Volumes of Data

Filtering the Last_Name field to show only records that begin with the letter P is an application of a(n)________ filter.

The ________ Table Style option applies a different format to the first column of a table so that the row headings stand out.

What are two built-in functionality features in tables in Excel 2013 that assist in creating formulas?

To create a(n)________ from an existing range of data,click the Insert tab and then click Table in the Tables group.

The use of field headings without row references in a structured formula is called a(n)________ reference.

In Excel 2013 a dataset:

A structured reference:

Unfreeze Panes only appears on the menu when you have frozen rows and/or columns.

To ________ a table into a range,click within the table,click the Table Tools Design tab,and from the Tools group,select Convert to Range.

A Table style controls:

Banded Rows display alternate fill colors for every five sets of rows to distinguish records.

Click the ________ tab and click Remove Duplicates to open the Remove Duplicates dialog box.

What options are available in the Top 10 AutoFilter dialog box?

In Page Break Preview,the print area has a white background with a dotted blue border.

Sorting values smallest to largest:

________ displays alternate fill colors for even and odd rows to help distinguish fields.

________ arranges records in a table by the value in the field or fields within a table.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters