# CGS100 Excel

### 91 terms by psshcarly

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

Workbook

Worksheet

Cell

Formula Bar

### The ________ allow(s) the worksheet to be split into two vertical views of the same worksheet.

Vertical Window Split

Name Box

Status Bar

Cell Content

Label

Active Cell

Auto Fill

Auto Complete

Fill Handle

A series

Range

Displayed Value

Underlying Value

Function

=

Underlying Value

Merge & Center

Cell Styles

Comma Style

Chart

Sparklines

Category Labels

Legend

Data Points

Data points

Data Series

Sheet Tabs

Autofit

Normal View

*

/

### Excel uses ________ to perform basic mathematical operations

Arithmetic Operators

^

\$

...

Formattin

Pie Char

...

### A(n) ________ refers to a cell by its fixed position in the worksheet

Absolute Cell Reference

### A cell address used in a formula using a(n) ________ will be adjusted appropriately when the formula is copied to another cell.

Relative Cell Reference

Data Marker

Data Marker

...

Legend

Chart Sheet

...

3-D

Bevel

Explode

### ) Why would you explode a slice on a pie chart?

To emphazise the slice to the person viewing the chart

Chart Area

Text box

Word Art

What-If Analysis

Goal Seek

Base

### The ________ is the percent by which one number increases over another during a specified time frame.

Percentage Rate of increase

### ) The percentage rate of increase is calculated by using this formula: ________.

Base*Amount of increase

### Value after increase is calculated by using this formula: ________.

Base*Percent for new value

...

What-If analysis

Line

axis

Category Axis

Value Axis

Y-Axis

X-Axis

Tick Marks

Major Value Unit

### Excel's ________ allows you to select a chart element so that you can format it.

Chart Element Box

Function

Arguments

Median

Median

...

...

...

...

...

...

...

...

...

...

...

...

Example: