Question 1

A Table ________ controls the fill color of the header row, columns, and records in a table.

Accepted Answer

The answer of A Table ________ controls the fill color...

Question 2

Highlight Cell Rules

Accepted Answer

A)  formats the condition of the worksheet in preparation for printing. 
B)  calculates an aggregate for values in a range or database. 
C)  tags a table element as a reference in a formula. 
D)  highlight cells meeting specified criteria with a specified color, font, or border. 
A)  formats the condition of the worksheet in preparation for printing. 
B)  calculates an aggregate for values in a range or database. 
C)  tags a table element as a reference in a formula. 
D)  highlight cells meeting specified criteria with a specified color, font, or border.

Question 3

Sorting arranges records in a table only by the due date of the assignment.

Accepted Answer

A) True 
 B)False

Question 4

A total row appears as the last row of a table to

Accepted Answer

A)  highlight or emphasize cells that meet certain conditions. 
B)  format cells based upon their value in reference to the value of other cells. 
C)  tag a table element as a reference in a formula. 
D)  display summary statistics, such as a sum. 
A)  highlight or emphasize cells that meet certain conditions. 
B)  format cells based upon their value in reference to the value of other cells. 
C)  tag a table element as a reference in a formula. 
D)  display summary statistics, such as a sum.

Question 5

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 6

Sorting Text A to Z

Accepted Answer

A)  is the process of displaying only records that meet specific conditions. 
B)  arranges data in alphabetical order. 
C)  displays data in chronological order, oldest to newest. 
D)  arranges values (numbers) in sequential order. 
A)  is the process of displaying only records that meet specific conditions. 
B)  arranges data in alphabetical order. 
C)  displays data in chronological order, oldest to newest. 
D)  arranges values (numbers) in sequential order.

Question 7

A record

Accepted Answer

A)  is an individual piece of data, such as a last name. 
B)  defines the range of data to print. 
C)  is a complete set of data for an entity. 
D)  is the sequence in which pages print. 
A)  is an individual piece of data, such as a last name. 
B)  defines the range of data to print. 
C)  is a complete set of data for an entity. 
D)  is the sequence in which pages print.

Question 8

The Table Style Options Group

Accepted Answer

A)  contains check boxes to select format actions such as Header Row which displays the header row when checked. 
B)  keeps Table Options visible as you scroll through a worksheet. 
C)  is a collection of structured, related data in columns and rows. 
D)  enables you to adjust settings to control how many pages will print. 
A)  contains check boxes to select format actions such as Header Row which displays the header row when checked. 
B)  keeps Table Options visible as you scroll through a worksheet. 
C)  is a collection of structured, related data in columns and rows. 
D)  enables you to adjust settings to control how many pages will print.

Question 9

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, columns, and records in a table. 
D)  arranges data in alphabetical order. 
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, columns, and records in a table. 
D)  arranges data in alphabetical order.

Question 10

A table style controls the fill color of the header row, columns, and records in a table.

Accepted Answer

A) True 
 B)False

Question 11

A table is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.

Accepted Answer

A) True 
 B)False

Question 12

________ Top Row keeps only the top row visible as you scroll through a worksheet.

Accepted Answer

The answer of ________ Top Row keeps only the top...

A Table ________ controls the fill color of the header row, columns, and records in a table.

Highlight Cell Rules

Sorting arranges records in a table only by the due date of the assignment.

A total row appears as the last row of a table to

Sorting Values smallest to largest

Sorting Text A to Z

A record

The Table Style Options Group

A Table Style controls

A table style controls the fill color of the header row, columns, and records in a table.

A table is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.

________ Top Row keeps only the top row visible as you scroll through a worksheet.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

Exam 14: Excel: Creating and Using Professional Forms and Reports

A Table ________ controls the fill color of the header row, columns, and records in a table.

Highlight Cell Rules

Sorting arranges records in a table only by the due date of the assignment.

A total row appears as the last row of a table to

Sorting Values smallest to largest

Sorting Text A to Z

A record

The Table Style Options Group

A Table Style controls

A table style controls the fill color of the header row, columns, and records in a table.

A table is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.

________ Top Row keeps only the top row visible as you scroll through a worksheet.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters