Bpc 110

To end a line before the normal end of the line, without creating a new paragraph, hold down the "Shift" key while pressing the:

"Enter" key

Term that refers to an image that appears to have all three spatial dimensions is

3-D

A pie slice is an example of

A data marker

A research tool that provides a list of words with similar meanings is

A thesaurus

Software, such as Internet Explorer, Firefox, Safari, or Chrome, that displays webpages is called

A web browser

An excel function that adds a group of values and then divides the result by the number of values in the group

AVERAGE function

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

Absolute

Data type that describes a unique sequential or random number assigned by Access as each record is entered is

Auto number

Starting point when you divide the amount of increase by it to calculate the rate of increase is the

Base

The nonprinting symbol that displays where a manual line break is inserted is the:

Bent arrow

To indicate possible grammar errors, word flags text with

Blue wavy underlines

The relative lightness of a picture is its:

Brightness

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

COUNTF

The x-axis is also known as the

Category axis

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

Comparison operator

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

Conditional format

The difference between the darkest and lightest area of a picture is the

Contrast

Conditions that you specify in a logical function

Criteria

The command that removes unwanted or unnecessary areas of a picture is

Crop

data type that describes monetary values and numeric data used in mathematical calculations involving data with one to four decimal places is

Currency

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

Data type

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

Datasheet view

A command with which you can automatically insert the current date and time into a document is

Date & Time

In a Word table, each cell behaves similarly to a

Document

When you create a table, the width of all cells in the table is

Equal

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

Explode

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

Field properties

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

Filtering

To locate specific text in a document quickly, use the

Find command

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

Flash fill

Excel feature which, after typing and = sign and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s).

Formula AutoComplete

Predefined formula that performs calculations by using specific values in a particular order or structure.

Function

Function that uses a logical test to check wether a condition is met and then returns one value of tire and another if false

IF

The percent by which one number increases over another number is the percentage rate of

Increase

Column text that is aligned to both the left and right margins is referred to as:

Justified

A chart type that displays trends over time is

Line chart

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

Logical functions

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

Logical test

Function that determines the largest value in a range

MAX

A function that finds the middle value that has as many values above it in the group as are below it

MEDIAN function

A function that determines the smallest value In a range

MIN

Function that retrieves and then displays the date and time from your computer is the

NOW fuction

Area bounded by the axes of a chart, including all the data series I the

Plot area

Field that uniquely identifies a record in a table is known as the

Primary key

Precise changes to the properties- characteristics- of selected items in a database can be made In the

Property sheet

Object that retrieves specific data and then displays only the data that you specify is a

Query

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

Record selector boz

To indicate words that might be misspelled because they aren't in Word's dictionary, Word flags text with

Red wavy lines

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

Redundant

A more sophisticated type of database that stores multiple collections of data that are related to one another; for example, data about the students, the courses, and the faculty members at a college is a

Relational database

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

Report

A predefined formula that adds all the numbers in a selected range

SUM function

The command that resizes a picture to a percentage of its size is

Scale

Using drag-and-drop to move text is most useful when both the text and the destination are on the same

Screen

A portion of a document that can be formatted differently from the rest of the document is a:

Section

Data type that describes text, a combination of txt and numbers, or numbers that aren't used in calculations such as a zip code is

Short text

A free web-based application from Microsoft with which you can save, store, organize, and share files online is called

SkyDrive

A font effect, commonly used in titles, that changes lowercase text into uppercase letters using a reduced font size iz

Small Caps

Process of arranging data in a specific order based on the value in each field is called

Sorting

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

Statistical functions

The underlying design of a table is referred to as the

Structure

The y-axis is also known as the

Value axis

A feature that enables you to change all colors in the picture to shades of a single color is

recolor

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

Append

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

Arguments