CSCI Final Exam (all terms)

Right click

1 click on the right mouse button

Label

A _____ usually provides information about number values and is another name for data field.

Bubble

A ______ chart is a variation of a scatter chart that shows how sets of things compare according to various factors.

Line

A ______ chart plots data points which are continuously distributed data to compare trends over time.

Database

A ______ is a file that consists of one or more tables and the supporting objects used to get data into and out of the fields

Font

A ______ is a set of characters with the same design and shape.

Form

A ______ is an interface that enables you to enter or modify recorded data.

Doughnut

A _______ chart shows values as percentages to the whole for multiple data series

Row

A _______ has source field that is assigned to a horizontal group of data

Number

A _______ is data that has a value and can be used in a calculation.

Cascade update

A ________ connects a primary key change to the tables that have a foreign key.

Record

A ________ is a complete set of all of the data about one person, place, event, or idea.

One to many

A ________ relationship exists when each record in the first table may match one, more than one, or no records in the second table.

Select query

A ________ searches the underlying tables to retrieve the data that satisfy the query parameters.

Context sensitive

A _________ command is associated with activities in which you are engaged.

Calculated

A ________field derives its value from a formula that references one or more existing fields.

Field

A basic entity, data element, or category, such as a book title or telephone number is called a ______.

Legend

A chart element that identifies the patterns or colors that are assigned to the categories in the chart is the _______.

Pie chart

A chart that shows the proportion of each category to the whole for a single data series

Table

A collection of records is a ______.

Column

A data field that has data grouped vertically is known as a ________.

Foreign key

A field in one table that also is stored in a different table as a primary key is known as the ______.

Gallery

A group of predesigned chart layouts that you can apply to an Excel chart can be found in the chart layout ________.

Series

A group of things that come one after another in succession; for example, January, February, March, and so on is called a ______.

Row

A horizontal group of cells in a worksheet that begins with the number 1 is a _______.

Date arithmetic

A mathematical expression that calculates elapsed time is a ________.

Pixel

A point of light measured in dots per square inch on a screen is a ______.

Report

A printed document that displays information professionally from a database is a _______.

Rounding

A procedure in which you determine which digit at the right of the number will be the last digit displayed and then increase it by one if the next digit to its right is 5, 6, 7, 8, or 9 is known as ________.

Normal

A screen view that maximizes the number of cells visible on your screen and keeps the column letters and row numbers close to the columns and rows is in ________ view.

Row field

A source field that you assign to group data horizontally into rows is also called a ________.

Range finder

An Excel feature that outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula.

Inequity

An _______ examines a mathematical relationship.

Attachment

An ________ is a data type that allows you to attach images, spreadsheet files, charts, and other types of supported files to the records in your database.

Formula

An equation that performs mathematical calculations on values in other cells and then places the result in the cell is a _______.

Value

Another name for a constant value is ______.

Spreadsheet

Another name for a worksheet.

AutoSum

Another name for the SUM function is ______.

Data demographics

Data that describes population segments by age, race, education, and other variables called _____.

Form

Filtering by _____ allows you to select the criteria from a drop down list, or applying multiple criterion.

Selection

Filtering by _______ only uses the records that match the pre-selected criteria.

split box

Horizontal ______ window is an excel window element with which you can split the worksheet into two horizontal views of the same worksheet.

Constant

Numbers, text, dates, or times of day that you type into a cell are all examples of _________ values.

Left click

Pressing and releasing left button on a mouse device once

Editing

Process of making changes to text or graphics in an office file is called _______.

Hyperlink

Stores a Web address (URL). Example: www.lsu.edu

Status bar

The _____ is the area along the lower edge of the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information; on the right side, and when numerical data is selected, common calculations such as Sum and Average display

Currency

The ______ format can be used in calculations for fields that contain monetary values.

Legend

The ______ is the area of the chart that identifies what each color represents the data for each data series

Accounting

The ______ number format applies a thousand comma separator where appropriate, inserts a fixed U.S. Dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.

Gridlines

The _______ are the lines that extend across the plot area of a chart

Calculated total

The _______ field is a data field used to customize aggregated data.

Chart layout

The _______ is the combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.

Information tab

The ________ in backstage view displays info about the current file.

Paragraph symbol

The ________ symbol represents the end of a paragraph.

Text

The ________ values usually provide information about number values; also referred to as labels.

Primary key

The _________ field that makes each record in a table unique.

Drop zone

The _________ is an area in the PivotTable or PivotChart design grid where drop fields organize the data.

Indexed property

The _________ list is a list that relates the field values to the records that contain a field value.

Worksheet grid

The __________ area displays the columns and rows that intersect to form worksheets.

Chart style

The __________ is the overall visual look of a chart in terms of its graphic effects, colors, and backgrounds.

Comma

The __________ style is an excel number format that inserts thousand comma separators where appropriate and applies two decimal places

Access speed

The amount of time it takes for the storage device to make the file content available for use is the ______.

Title

The area of a chart that displays a name describing the data depicted in a chart is the chart ______.

Gallery

The chart style _______ is a group of predesigned chart styles that you can apply to an Excel chart.

Merge and center

The command that joins selected cells in an excel worksheet into one larger cell and centers the contents in the new cell is called _______and________.

Default

The current selection or setting that is automatically used by your computer, unless you specify otherwise is call the ______ setting.

Underlying value

The data that displays in the formula bar is called the ____________.

Underlying formula

The formula entered in a cell and visible only on the Formula Bar is called the ________.

Cell

The intersection of a column and a row.

Non-relation

The kind of data that is contained in a single page or sheet is known as _______-______ data.

Category labels

The labels that display along the bottom of a chart to identify the categories of data are called _______.

Drill button

The plus or minus sign that enables you to show or collapse details in a PivotTable is call the _____.

Filter field

The plus or minus sign that enables you to show or collapse details in a PivotTable is the _____.

Scaling

The process of shrinking the width and/or height of printed outputs to fit a maximum number of pages in excel is called ________.

Design grid

The query's __________ displays when you select the query's design view.

Arithmetic

The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula are called ________ operators.

Data

The text or numbers in a cell are called _______.

Query

What database object enables you to ask questions about the data stored in a database and returns the answers in the order from the records that match your instructions?

Cascade delete

What is the tool that searches the database and deletes all of the related records called?

Portrait

What page orientation makes the page taller than it is wide?

Text

____ is alphanumeric data, such as a student's name or address.

Worksheet

_____ is the primary document that you use in Excel to work with and store data, which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

Column, bar, or stack

_____, ______, or _____ charts display quantitative data and compare data across categories.

Cell content

______ is anything typed into a cell. Can be constant value, value or formula.

Autonumber

______ is what access uses to assign the next consecutive number each time you add a record.

Discrete

_______ data is the classification of data that is measured and quantified in unique increments; categories such as the number of males and females in a class or names of countries

Number

_______ format means that number values align at the right edge of the cell.

Query wizard

_______ is a tool that facilitates new query development through a series of dialog boxes.

Data mining

_______ is the process of analyzing large volumes of data to identify patterns and relationships.

Number

_______ values are constant values consisting of only numbers.

Page layout

_______ view is the screen view in which you can use the rulers to measure the width and height of data, set margins for printing, hide or display the numbered row headings and the lettered column headings, and change the page orientation.

Data redundancy

________ occurs when unnecessary duplicate information exists in a database?

Design

________ view displays the infrastructure of a table, form, or report without displaying the data.

Workbook level

_________ buttons minimize, close, or restore the previous size of the displayed workbook they are located at the far right of the ribbon tabs.

Continuous

_________ data is a classification of data in which values fall on a continuum and are easily scaled such as measurements of time, temperature, money, volume, size, and distance.

Relational database

_________ software is a computer application, such as Microsoft Access, that is used to store data and convert it into information

Datasheet

_________ view displays a grid containing columns and rows where you add, edit, and delete records in a database table.

Point and click

_____and _____ method is the technique of constructing a formula by pointing to and then clicking cells; this method is convenient when the referenced cells are not adjacent to one another.

Compact and repair

_____and_____ database utility reduces the size of the database and eliminates wasted space