COSC 101 Final

Data Marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.

Freeze Panes

A command that enables you to select one or more rows or columns and lock them in place.

Range Finder

A feature that outlines cells in color to indicate which cells are used in a formula is called:

Live Layout

A feature that reflows text as an object is moved or resized so that you can view the placement of surrounding text.

Common Field

A field in one or more tables that stores the same data.

Conditional format

A format that changes the appearance of a cell based on a condition.

Field

A single piece of information that is stored in every record and represented by a column in a table.

Normalization

The process of applying design rules and principles to ensure that a database performs as expected.

Sorting

The process of arranging data in a specific order based on the value in each field is called:

What If Analysis

The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.

Filtering

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:

Fill Handle

The small black square in the lower right corner of a selected cell.

Absolute

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Major Unit

The value in a chart's value axis that determines the spacing between tick marks and between the gridlines in the plot area is the

Arguments

The values that an Excel function uses to perform calculations or operations are the:

Object Window

The window area that displays each open object on its own tab.

Sparklines

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

Append

To add on to the end of an object, such as to add records to the end of an existing table, is to:

Quick Analysis Tool

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:

Spin Box

A small box with an upward- and downward-pointing arrow that enables you to move rapidly through a set of values by clicking.

COUNTIF function

A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria.

Rotation Handle

A symbol with which you can rotate a graphic to any angle; displays above the top center sizing handle.

Record

A table row that contains all of the categories of data pertaining to one person, place, thing, event, or idea.

Navigation Pane

The window area that organizes the database objects and from which you open objects.

Detail Sheet

The worksheets that contain the details of the information summarized on a summary sheet are called:

Graphics

anything written, drawn, or printed

Select All Box

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

Toggle

A button that can be turned on by clicking it once, and then turned off by clicking it again.

Absolute

A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:

Point

A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:

Line Chart

A chart type that displays trends over time is a:

IF Function

A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false.

Logical Functions

A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.

Bulleted List

A list of items with each item introduced by a symbol such as a small circle or check mark, and which is useful when the items in the list can be displayed in any order.

Tab Stop

A mark on the ruler that indicates the location where the insertion point will be placed when you press the Tab key.

Text Box

A movable, resizable container for text or graphics.

An Enterprise Fund

A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services is:

Text Pane

A pane that displays to the left of a SmartArt graphic and is used to type text and edit text in a SmartArt graphic.

Icon

A picture composed of straight and curved lines.

Data Marker

A pie slice is an example of:

Template

A preformatted document that you can use as a starting point and then change to suit your needs.

First Principle of Good Database Design

A principle stating that data is organized in tables so that there is no redundant data.

Second Principle of Good Database Design

A principle stating that techniques are used to ensure the accuracy of data entered into a table.

Dot Leader

A series of dots following a tab that serve to guide the reader's eye.

Data Bar

A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:

Bevel

A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.

Flat Database

A simple database file that is not related or linked to any other collection of data.

Goal Seek

A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.

Chart Sheet

A workbook sheet that contains only a chart.

Summary Sheet

A worksheet where totals from other worksheets are displayed and summarized is a:

Autofit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:

Workbook

An Excel file that contains one or more worksheets.

Justified alignment

An alignment of text in which the text is evenly aligned on both the left and right margins

Data Base

An organized collection of facts about people, events, things, or ideas related to a specific topic.

Logical Test

Any value or expression that can be evaluated as being true or false.

Field Properties

Characteristics of a field that control how the field displays and how data is entered are:

Formatting marks

Characters that display on the screen, but do not print, indicating where the Enter key, the Spacebar, and the Tab key were pressed.

Criteria

Conditions that you specify in a logical function.

Statistical Functions

Excel functions, such as AVERAGE, that are useful to analyze a group of measurements.

Artistic Effects

Formats that make pictures look more like sketches or paintings

Picture Styles

Frames, shapes, shadows, borders, and other special effects that can be added to an image to create an overall visual style for the image.

Color or Pattern

In a chart, each data point—bar, slice, and so on—has a unique:

Relative Cell Reference

In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to in the formula.

Redundant

Information repeated in a database in a manner that indicates poor design is said to be:

Placeholder

Non-printing text that holds a place in a document where you can type.

Constant Value

Numbers, text, dates, or times of day that you type into a cell.

Layout Options

Picture formatting options that control the manner in which text wraps around a picture or other object.

Series

Related data points represented by data markers are referred to as the data:

Comparison operator

Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria.

Datasheet View

The Access view that displays data in columns and rows like an Excel worksheet is:

Print Titles

The Excel command that enables you to specify rows and columns to repeat on each printed page is:

Flash Fill

The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:

Auto Fill

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:

Formula AutoComplete

The Excel feature which, after typing = and the first letter of a function, displays a list of function names.

Explode

The action of pulling out a pie slice from a pie chart for emphasis is called:

Category Axis

The area along the bottom of a chart that identifies the categories of data is the:

Plot Area

The area bounded by the axes of a chart, including all the data series, is the:

Record Selector Box

The box at the left of a record in Datasheet view that you click to select an entire record is the:

Data Type

The characteristic that defines the kind of data you can store in a field is the:

Underlaying Value

The data that displays in the Formula Bar is referred to as the:

Short Text

The data type that describes text, a combination of text and numbers, or numbers that are not used in calculations, such as a ZIP code is:

General Format

The default format that Excel applies to numbers is the:

Nonprinting Characters

The feature that moves text from the right edge of a paragraph to the beginning of the next line as necessary to fit within the margins.

Word Wrap

The feature that moves text from the right edge of a paragraph to the beginning of the next line as necessary to fit within the margins.

Primary Key

The field that uniquely identifies a record in a table is known as the:

Value after increase = base × percent for new value

The formula for calculating the value after an increase by multiplying the original value—the base—by the percent for new value.

Now Function

The function that retrieves and then displays the date and time from your computer is the:

Spreadsheets

The labels along the lower border of the Excel window that identify each worksheet.

Sheet Tabs

The labels along the lower border of the workbook window that identify each worksheet are the:

Text Wrapping

The manner in which text displays around an object.

Rate = amount of increase/base

The mathematical formula to calculate a rate of increase.

Report

The object that displays fields and records from a table or query in a printable format is a:

Query

The object that retrieves specific data and then displays only the data that you specify is a:

Alignment

The placement of paragraph text relative to the left and right margins is referred to as:

Margins

The space between the text and the top, bottom, left, and right edges of the paper.

Base

The starting point when you divide the amount of increase by it to calculate the rate of increase is the:

Anchor

The symbol that indicates to which paragraph an image is attached is a(n):

Operators

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:

Volatile

The term used to describe an Excel function that is subject to change each time the workbook is opened is called:

SmartArt

A designer-quality graphic used to create a visual representation of information.