Test 1 C Flashcards Preview

Excel > Test 1 C > Flashcards

Flashcards in Test 1 C Deck (24)
Loading flashcards...
1
Q

Logical Function

A

A function that works with statements that are either true or false.

2
Q

Financial Function

A

A function related to monetary calculations, such as loans and payments.

3
Q

IF Function

A

A logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false.

4
Q

AutoFill

A

Copies content and formats from a cell or range into and adjacent cell or range.

5
Q

Fill Handle

A

Appears in the lower-right corner of a selected cell or range.

6
Q

Comparison Operator

A

A symbol that indicates the relationship between two values.

7
Q

Principle

A

The amount of money being loaned.

8
Q

Interest

A

The amount added to the principle by the lender.

9
Q

Simple Interest

A

The interest is equal to the percentage of principle for each period that the money has been lent.

10
Q

Compound Interest

A

The interest i applied not only to the principle but also to any accused interest.

11
Q

Chart or Graph

A

A visual representation of a set of a set of data values.

12
Q

Embedded Chart

A

An object in a worksheet.

13
Q

Data Source

A

The range that contains the data to display in the chart.

14
Q

Series Name

A

The first row of the data range identifies the data series.

15
Q

Data Series

A

A range of values that i plotted as a single unit on the chart.

16
Q

Category Values

A

The first column of the data range.

17
Q

Series Values

A

The data displayed in the chart.

18
Q

Value Axis

A

Displays the series values from the data series.

19
Q

Category Axis

A

Displays the category values from each data series.

20
Q

Chart Area

A

Contains the chart and all of the other chart elements.

21
Q

Chart Title

A

A descriptive label or name for the chart.

22
Q

Plot Area

A

The part of the chart that contains the graphical representation of the data series.

23
Q

Tick Marks

A

Identifies the units at regular intervals on the chart axis.

24
Q

Data Marker

A

the representation of each data series.