Test 1 C Flashcards Preview

Excel > Test 1 C > Flashcards

Flashcards in Test 1 C Deck (24):
1

Logical Function

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

2

Financial Function

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

3

IF Function

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

AutoFill

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

5

Fill Handle

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

6

Comparison Operator

A symbol that indicates the relationship between two values.

7

Principle

The amount of money being loaned.

8

Interest

The amount added to the principle by the lender.

9

Simple Interest

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

10

Compound Interest

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

11

Chart or Graph

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

12

Embedded Chart

An object in a worksheet.

13

Data Source

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

14

Series Name

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

15

Data Series

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

16

Category Values

The first column of the data range.

17

Series Values

The data displayed in the chart.

18

Value Axis

Displays the series values from the data series.

19

Category Axis

Displays the category values from each data series.

20

Chart Area

Contains the chart and all of the other chart elements.

21

Chart Title

A descriptive label or name for the chart.

22

Plot Area

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

23

Tick Marks

Identifies the units at regular intervals on the chart axis.

24

Data Marker

the representation of each data series.