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

Question 1

A table

A) is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
B) is a complete set of data for an entity.
C) represents a Field which is an individual piece of data.
D) is an individual piece of data, such as a last name.

Answer 1

A

Question 2

Previewing the worksheet in Backstage view

A) autoprints
B) sets the sequence in which pages print.
C) enables you to adjust settings to control how the worksheet will print.
D) defines the range of data to print.

Answer 2

C

Question 3

The Table Style Options Group

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.

Answer 3

A

Question 4

To add a record (row) to a table,

A) select any cell in the table, then click Remove Duplicates in the Tools group.
B) click in a cell and on the Home tab, click the Insert arrow in the Cells group.
C) click within a range, click the Table Tools Design tab, and then select Add Row to Table.
D) click the Insert tab and then click Range in the Range group.

Question 5

The Table Style Options Group

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

Question 6

Freeze Top Row

A) is the sequence in which pages print.
B) enables you to adjust settings to control how the worksheet will print.
C) defines the range of data to print.
D) keeps only the top row visible as you scroll through a worksheet.

Question 7

Print order

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 2010

Question 8

To remove duplicate records (rows),

A) select any cell in the table, then click Remove Duplicates from the Tools group on the Table Tools Design tab.
B) click the Remove tab and then Duplicate in the Records group.
C) click in a cell and on the Home tab, click the Remove arrow in the Cells group.
D) convert it to a Range.

Question 9

A page break

A) freezes only the top row.
B) is the sequence in which pages print.
C) indicates where data starts on a new printed page.
D) stops the printer from printing.

Question 10

To create a table from an existing range of data,

A) click within the range, click the Table Tools Design tab, and then select Convert to Table.
B) select any cell in the worksheet then click Existing Range in the Tools group.
C) click in a cell and on the Home tab, click the Insert arrow in the Cells group.
D) click the Insert tab and then click Table in the Tables group.

Question 11

Freezing rows and / or columns

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.

Question 12

Each column in a table

A) needs to be converted to a Range
B) represents a record.
C) is a complete set of data for an entity.
D) represents a Field which can contain an individual piece of data for a record.

Question 13

A record

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 14

To Freeze Columns and / or rows

A) first indicate where data starts on a new printed page.
B) use the View Tab, Window Group, and click Freeze Panes.
C) scroll through a worksheet and click on the Freeze button.
D) adjust settings to control how the worksheet will print.

Question 15

Each row in an Excel table

A) is an individual piece of data, such as a last name.
B) is the sequence in which pages print.
C) represents a Field which can contain an individual piece of data for a record.
D) represents a record.

Question 16

A print area

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.

Question 17

In Excel 2010, Dataset

A) indicates where data starts on a new printed page.
B) is a collection of structured, related data in columns and rows.
C) is freezing rows to keep them visible.
D) is freezing panes to keep them visible.

Question 18

To convert a table back into a range,

A) click within the table, click the Table Tools Design tab, and then select Convert to Range.
B) click the Insert tab and then click Range in the Range group.
C) select any cell in the worksheet then click Existing Range in the Tools group.
D) click in a cell and on the Home tab, click the Insert arrow in the Cells group.

Question 19

A Table Style controls

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 20

A field

A) is a complete set of data for an entity.
B) indicates where data starts on a new printed page.
C) is an individual piece of data, such as a last name.
D) defines the range of data to print.

Question 21

The Table Style Options Group

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

Question 22

Filtering the Date column (field)to show only records older than January 2001 is an application of

A) a Number Filter.
B) a Date Filter.
C) use of a table element as a formula.
D) a Text Filter.

Question 23

Top Bottom Rules

A) is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
B) moves the data from the top of the workbook to the bottom for analysis.
C) highlight cells meeting specified criteria with a specified color, font, or border.
D) format cells based upon their value in relation to the value of other cells such as the top 10%.

Question 24

A color scale

A) highlights cells meeting specified criteria with a specified color, font, or border.
B) is a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on colors in the selected range.
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.

Question 25

The SUBTOTAL function

A) highlights or emphasizes cells that meet certain conditions.
B) formats cells based upon their value in reference to the value of other cells.
C) calculates an aggregate for values in a range or database.
D) tags a table element as a reference in a formula.

Question 26

Conditional formatting

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.

Question 27

Sorting Values smallest to largest

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 28

An icon set

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.

Question 29

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

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 30

Sorting Dates oldest to newest

A) is the process of displaying only records that meet specific conditions.
B) arranges dates in alphabetical order.
C) is a Text Filter.
D) displays data in chronological order.

Question 31

Highlight Cell Rules

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 32

To Create a new Conditional Formatting Rule,

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.

Question 33

A structured reference

A) is a tag or use of a table element as a reference in a formula.
B) highlights or emphasizes cells that meet certain conditions.
C) is a horizontal gradient or solid fill indicating the cell's structure compared to other selected cells.
D) formats cells based upon their value in reference to the value of other cells.

Question 34

Sorting arranges records in a table

A) by the number of pages in the worksheet.
B) by the number of pages in the workbook.
C) by the value in field(s) within a table.
D) by permanently removing extraneous data.

Question 35

Using Conditional Formatting to draw attention to cells that are blank

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.

Question 36

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

A) use of a table element as a formula.
B) a Number Filter.
C) a Text Filter.
D) a Date Filter.

Question 37

Filtering

A) helps to clean the data before printing in Backstage view
B) displays data in chronological order.
C) is the process of displaying only records that meet specific conditions.
D) arranges dates in alphabetical order.

Question 38

A data bar

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.

Question 39

Sorting Text A to Z

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 40

Filtering the Cost column (field) to show only records Greater than $10,000 is an application of

A) a Date Filter.
B) a Text Filter.
C) use of a table element as a formula.
D) a Number Filter.

Question 41

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

Question 42

Once you set custom page breaks, Excel 2010 freezes the panes so users cannot change the breaks on the current sheet.

Question 43

Each column of a table represents a "Stack" which holds multiple pieces of data, such as first / last name and address of a single customer.

Question 44

Freezing keeps rows and / or columns visible as you scroll through a worksheet.

Question 45

A structured reference uses field names instead of cell references to make it easier to create formulas.

Question 46

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

Question 47

Using Conditional Formatting to draw attention to cells containing errors

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.

Question 48

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

Question 49

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

Question 50

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

Question 51

Filtering is the process of deleting records that meet specific conditions.

Question 52

Plan the fields for a table carefully because after creating, you cannot add new fields.

Question 53

Each row in an Excel table represents a record, which is a collection of data about one entity, such as data for one person.

Question 54

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

Question 55

You can sort data by one or more columns.

Question 56

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.

Question 57

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

Question 58

If the automatic page breaks occur in undesirable locations, you can adjust the page breaks.

Question 59

In addition to sorting and filtering cells by content you can sort and / or filter by

A) Top / Bottom rules
B) conditional formatting.
C) icon sets
D) the data bar

Question 60

Freeze Panes only locks columns above the active cell as you scroll through a worksheet.

Question 61

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

Question 62

In Excel 2010, you can filter data by color just as you might filter it by text or value.

Question 63

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

Question 64

With data arranged in a table, you can display a total row after the last record. Excel sums the values in the last column automatically

Question 65

In Excel 2010, you can create formatting rules based on formulas to set conditions based on content in multiple columns.

Question 66

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

Question 67

The Table Style ________ group contains check boxes to select format actions.

Question 68

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

Question 69

When you no longer need conditional formatting, you can clear it for a selected range or entire worksheet.

Question 70

Previewing the worksheet in ________ view enables you to adjust print settings.

Question 71

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

Question 72

After you apply conditional formatting, you can sort or filter a column based on its formats.

Question 73

A ________ area defines the range of data to print.

Question 74

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

Question 75

Conditional formatting is the process conditioning data to make it more manageable.

Question 76

To Freeze Columns and / or rows use the View Tab, Window Group, and then click ________ Panes.

Question 77

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.

Question 78

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

Question 79

Each ________ in an Excel table represents a record.

Question 80

________ keeps rows and / or columns visible as you scroll through a worksheet.