Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Excel Chapter 3 > Excel Chapter 3 > Flashcards

Excel Chapter 3 Flashcards

1
Q

3-D

A

The shortened term for three-dimensional, which refers to an image that appears to have all three spatial dimensions - length, width, and depth.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Absolute cell reference

A

A cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Axis

A

A line that serves as a frame of reference for measurement and which borders the chart plot area.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Base

A

The starting point; used in calculating the rate of increase, which is the amount of increase divided by the base.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Bevel

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Category axis

A

The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Chart area

A

The entire chart and all of its elements

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Chart Elements box

A

The box in the Chart Tools tabs from which you can select a chart element so that you can format it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Chart sheet

A

A workbook sheet that contains only a chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Data marker

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Data point

A

A value that originates in a worksheet cell and that is represented in a chart by a data marker.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Data series

A

Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Explode

A

The action of pulling out one or more pie slices from a pie chart for emphasis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Format as you type

A

The excel feature by which a cell takes on the formatting of the number typed into the cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Formula AutoComplete

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Fund

A

A sum of money set aside for a specific purpose

17
Q

General Fund

A

The term used to describe money set aside for the normal operating activities of a government entity such as a city.

18
Q

Goal Seek

A

One of Excel’s What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell - find the right input when you know the result you want.

19
Q

Legend

A

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

20
Q

Line chart

A

A chart type that is useful to display trends over time; time displays along the bottom axis and the data point values are connected with a line.

21
Q

Major unit

A

A number that determines the spacing between tick marks and between the gridlines in the plot area.

22
Q

Order of operations

A

The mathematical rules for performing multiple calculations within a formula

23
Q

Percent for new value = base percent + percent of increase

A

The formula for calculating a percentage by which a value increases by adding the base percentage - usually 100% - to the percent increase

24
Q

Percentage rate of increase

A

The percent by which one number increases over another number

25
Q

Pie Chart

A

A chart that show the relationship of each part to a whole

26
Q

Plot area

A

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

27
Q

Rate = amount of increase/base

A

The mathematical formula to calculate a rate of increase

28
Q

Relative cell reference

A

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

29
Q

Text box

A

A movable resizable container for text or graphics.

30
Q

Tick marks

A

The short lines that display on an axis at regular intervals

31
Q

Value after increase = base x percent for new value

A

The formula for calculating the value after an increase by multiplying the original value - the base - by the percent for new value (see the percent for new value formula)

32
Q

Value axis

A

A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis

33
Q

What-If-analysis

A

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

34
Q

WordArt

A

A feature that transforms text into a stylized image that you can use to create a distinctive logo or heading

35
Q

x-axis

A

Another name for the horizontal (category) axis

36
Q

y-axis

A

Another name for the vertical (value) axis.

Excel Chapter 3 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions