Question 1

Match between columns
                        Premises: Equal to 1/72 of an inch.
Has a default value of 8.43 characters, a little less than one inch.
A type of conditional formatting that visually illustrates differences among values.
A predefined set of attributes that gives your Excel worksheet a professional look.
The name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design.

Accepted Answer

The Answer of data bar and point and column width is...

Question 2

Deleting a field from a query also deletes it from the underlying table.

Accepted Answer

Deleting a field from a query only removes it from the view of the query result, but it does not affect the underlying table. The field will still be present in the table and can be included in other queries.

Question 3

Match between columns
                        Premises: Allows the user to move or copy data from one cell to another without using the Clipboard.
The Excel function that returns the number of cells in a range containing numeric data.
Mixed cell reference.
Absolute cell reference.
Predesigned workbook files that contain labels, values, formulas, and formatting.
The type of cell reference used to preserve the relationship to the formula location.
The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only."
The Excel function that returns the arithmetic mean of its arguments.

Accepted Answer

The Answer of AVERAGE and Paste Preview and template and is...

Question 4

Match between columns
                        Premises: A dark rectangle that outlines the cell in which you are working
Identified by the coordinates of the intersecting column and row
Displays the active cell address
Work done in a virtual environment
Provides a brief description of the active command or task in progress

Accepted Answer

The Answer of status bar and cell address and Name is...

Question 5

Match between columns
                        Premises: Used to visually separate information on a form
Best choice to create a three-dimensional aspect to a form
Used to run a macro
Best choice to display a field such as Veteran that has only two options, Yes or No
Used to provide a list of options for a field plus the ability for the user to enter a new value
Best choice to provide choices for a field in an option group
Used to provide a list of options for a field with no ability for the user to enter a new value
Best choice to describe information on a form

Accepted Answer

The Answer of Command button and Line and Option button is...

Question 6

Match between columns
                        Premises: Rules that determine how criteria is entered
Criterion that finds all records where no entry has been made in the field
Putting records in ascending or descending order based on a field's values
Creates a temporary subset of records
Limiting conditions used to narrow the number of records on a datasheet
Used to search for a pattern
Creates a datasheet of selected fields and records from one or more tables
The lower pane in Query Design View

Accepted Answer

The Answer of Query grid and Wildcard and Sorting and is...

Question 7

Match between columns
                        Premises: Last field of the current record
Current field of the next record
Queries evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary sort field.
Current field of the previous record
First field of the current record
Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc.Her crew manager will also be using the system. Hannah is considering whether to use Excel or Access.Which one of the following is NOT a benefit of using Access?
Last field of the last record
Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?
Previous field of the current record
Lauren wants to create an Access database of the musical instruments she owns. She has written a paragraph describing the use for each inventory item.Which data type should she use to define the field that will store this information?
First field of the first record
A query allows the selection of several fields and records from one or more tables, then presents the selected data as a single datasheet.
Next field of the current record

Accepted Answer

The Answer of It's easier to set up a relational is...

Question 8

Discuss the guidelines that you should use for planning a chart.

Accepted Answer

The answer of Discuss the guidelines that you should use...

Question 9

Filters are used to select a subset of records in a datasheet.

Accepted Answer

Filters can be applied to a datasheet in order to display a subset of records based on specific criteria. This allows for easier data analysis and manipulation.

Question 10

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Accepted Answer

The answer of The easiest way to filter the records...

Question 11

Describe some of the changes that you can make to a chart using the Chart Tools Design tab.

Accepted Answer

The answer of Describe some of the changes that you...

Question 12

The question mark (?) is the wildcard character which stands for any single character in criteria.

Accepted Answer

The statement is true. The question mark symbol (?) is used as a single character wildcard in criteria.

Question 13

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

Accepted Answer

The answer of The asterisk (*) is the wildcard used...

Question 14

To add, delete, or change fields in a query, you use Query Design View.

Accepted Answer

Query Design View allows you to modify fields in a query by adding, deleting, or changing them.

Question 15

Describe four commonly used Excel chart types.

Accepted Answer

The answer of Describe four commonly used Excel chart types....

Question 16

A query is commonly used as the source of data for a form or report.

Accepted Answer

A query is often used as the underlying source of data for a form or report in order to retrieve and display specific information based on specific criteria.

Question 17

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

Accepted Answer

SmartArt is a feature in Microsoft Office that allows users to create various types of diagrams, including lists, processes, cycles, hierarchies, relationships, matrices, and pyramids.

Question 18

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

Accepted Answer

The answer of A chart that is inserted directly in...

Question 19

You can add a text box using the Chart Tools ____ tab.

Accepted Answer

The answer of You can add a text box using...

Question 20

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.

Accepted Answer

The answer of To filter for comparative data and to...

Quiz 2: Getting Started With Access 2.0

Identify the letter of the choice that best matches the phrase or definition.

Deleting a field from a query also deletes it from the underlying table.

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

Match each term below with the statement that best defines it.

Match each term with the statement that best describes it.

Match the shortcut keystrokes to the correct action.

Discuss the guidelines that you should use for planning a chart.

Filters are used to select a subset of records in a datasheet.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

Describe some of the changes that you can make to a chart using the Chart Tools Design tab.

The question mark (?) is the wildcard character which stands for any single character in criteria.

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

To add, delete, or change fields in a query, you use Query Design View.

Describe four commonly used Excel chart types.

A query is commonly used as the source of data for a form or report.

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

You can add a text box using the Chart Tools ____ tab.

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.