Question 1

Conditional formatting

Accepted Answer

A)   highlights or emphasizes cells that meet certain conditions.
B)   tags a table element as a reference in a formula.
C)   formats the condition of the worksheet in preparation for printing.
D)   calculates an aggregate for values in a range or database.E) B) and C)
F) B) and D)

Question 2

You can apply text, value, and date filters to fields based on the data in a particular field.

Accepted Answer

A) True 
 B)False

Question 3

A ________ is a space for individual piece of data within a record, such as a street name.

Accepted Answer

The answer of A ________ is a space for individual...

Question 4

To Create a new Conditional Formatting Rule,

Accepted Answer

A)   convert the cell to a Range.
B)   select any cell in the table, then click New Rule in the Tools group.
C)   click in a cell and on the Home tab, click the Conditional arrow in the Cells group.
D)   click Conditional Formatting from the Cell Styles group and select New Rule.E) B) and C)
F) All of the above

Question 5

Using Conditional Formatting to draw attention to cells that are blank

Accepted Answer

A)   displays a particular color based on the relative value of the cell contents to other selected cells.
B)   displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
C)   helps locate where data may be missing.
D)   helps locate errors in cells quickly.E) B) and C)
F) B) and D)

Question 6

A page ________ indicates where data starts on a new printed page.

Accepted Answer

The answer of A page ________ indicates where data starts...

Question 7

Filtering the Last_Name column (field)  to show only records that begin with the letter S is an application of

Accepted Answer

A)   use of a table element as a formula.
B)   a Number Filter.
C)   a Text Filter.
D)   a Date Filter.E) None of the above
F) A) and C)

Question 8

If the default conditional format options do not provide what you need, you can create your own rule for formatting.

Accepted Answer

A) True 
 B)False

Question 9

To Create a new Conditional Formatting Rule, click Conditional Formatting from the Cell ________ group and select New Rule.

Accepted Answer

The answer of To Create a new Conditional Formatting Rule,...

Question 10

A page break indicates where the end of all the columns (fields) occurs.

Accepted Answer

A) True 
 B)False

Question 11

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.

Accepted Answer

A) True 
 B)False

Question 12

Sorting ________ from oldest to newest displays data in chronological order.

Accepted Answer

The answer of Sorting ________ from oldest to newest displays...

Question 13

Using Conditional Formatting to draw attention to cells containing errors

Accepted Answer

A)   helps locate errors in cells quickly.
B)   displays a particular color based on the relative value of the cell contents to other selected cells.
C)   calculates an aggregate for values in a range or database.
D)   displays an icon representing a value in the top third based on values in the selected range.E) All of the above
F) A) and D)

Question 14

After you select a table style, you can control what the style formats. The Table Style Options group contains check boxes to select specific format actions in a table.

Accepted Answer

A) True 
 B)False

Question 15

________ is the process of displaying only records that meet specific conditions.

Accepted Answer

The answer of ________ is the process of displaying only...

Question 16

Freezing rows and / or columns

Accepted Answer

A)   collects structured, related data in columns and rows.
B)   keeps them visible as you scroll through a worksheet.
C)   indicates where data starts on a new printed page.
D)   enables you to adjust settings to control how the worksheet will print.E) B) and D)
F) A) and B)

Question 17

A print area

Accepted Answer

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

Question 18

Print order

Accepted Answer

A)   represents a Field which is an individual piece of data.
B)   is the sequence in which pages print.
C)   represents a record.
D)   is the command to print in Excel 2010E) C) and D)
F) A) and B)

Question 19

An icon set

Accepted Answer

A)   is a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
B)   highlights cells meeting specified criteria with a specified color, font, or border.
C)   calculates an aggregate for values in a range or database.
D)   is a conditional format that displays a particular color based on the relative value of the cell contents to other selected cells.E) All of the above
F) A) and B)

Question 20

A data bar

Accepted Answer

A)   highlights cells meeting specified criteria with a specified color, font, or border.
B)   calculates an aggregate for values in a range or database.
C)   formats the bar data in preparation for printing.
D)   is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.E) All of the above
F) C) and D)

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

Conditional formatting

Correct AnswerverifiedShow Answer

Sorting ________ from oldest to newest displays data in chronological order.

Correct AnswerverifiedShow Answer

A page ________ indicates where data starts on a new printed page.

Correct AnswerverifiedShow Answer

A data bar

Correct AnswerverifiedShow Answer

A page break indicates where the end of all the columns (fields) occurs.

Correct AnswerverifiedShow Answer

Freezing rows and / or columns

Correct AnswerverifiedShow Answer

You can apply text, value, and date filters to fields based on the data in a particular field.

Correct AnswerverifiedShow Answer

An icon set

Correct AnswerverifiedShow Answer

To Create a new Conditional Formatting Rule, click Conditional Formatting from the Cell ________ group and select New Rule.

Correct AnswerverifiedShow Answer

Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of

Correct AnswerverifiedShow Answer

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.

Correct AnswerverifiedShow Answer

After you select a table style, you can control what the style formats. The Table Style Options group contains check boxes to select specific format actions in a table.

Correct AnswerverifiedShow Answer

Print order

Correct AnswerverifiedShow Answer

Using Conditional Formatting to draw attention to cells that are blank

Correct AnswerverifiedShow Answer

A print area

Correct AnswerverifiedShow Answer

To Create a new Conditional Formatting Rule,

Correct AnswerverifiedShow Answer

________ is the process of displaying only records that meet specific conditions.

Correct AnswerverifiedShow Answer

If the default conditional format options do not provide what you need, you can create your own rule for formatting.

Correct AnswerverifiedShow Answer

A ________ is a space for individual piece of data within a record, such as a street name.

Correct AnswerverifiedShow Answer

Using Conditional Formatting to draw attention to cells containing errors

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified