91 terms

An Excel document is called a

Workbook

The individual pages of an Excel document are called

Worksheet

A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.

Spreadsheet

A ________ is created when a row and a column intersect

Cell

The ________ allows the user to enter or edit the value or formula contained in the active cell.

Formula Bar

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

Vertical Window Split

The ________ displays the name of the selected cell, table, chart, or object.

Name Box

The current cell mode, the page number, and the view and zoom buttons are displayed on the?

Status Bar

Anything a user types into a cell is known as

Cell Content

A text value is also known as a

Label

The ________ is outlined in black and is ready to accept data.

Active Cell

________ generates and extends a series of values into adjacent cells based on the values of other cells.

Auto Fill

The ________ feature fills in the remaining characters of a word if what is typed matches an existing entry in the column.

Auto Complete

The small black square in the lower right corner of a selected cell is called the

Fill Handle

A group of items that come one after another in succession is called

A series

Two or more cells that Excel treats as a single unit is called a

Range

The data that the user sees in a cell is called the

Displayed Value

The Formula Bar displays the data known as the

Underlying Value

A prewritten formula known as a(n) ________ looks at one or more values, performs an operation, and returns a value

Function

All Excel formulas begin with which symbol?

=

The result of a formula is displayed in the active cell, and the ________ is displayed in the Formula Bar.

Underlying Value

Excel's ________ command creates one cell out of the selected cells and centers the contents within the new cell.

Merge & Center

________ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Cell Styles

The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parenthese

Comma Style

For data to be more easily understood, it can be presented in a ________ instead of a table of numbers.

Chart

Tiny charts embedded in cells that show a visual trend alongside the data are called

Sparklines

Labels that display along the bottom of a chart to identify the category of the data are called

Category Labels

On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the categories in the chart.

Legend

Values that originate in a worksheet that are to be charted are called

Data Points

A data marker, such as a column, dot, or pie slice on a chart, represents a single

Data points

In an Excel chart, a ________ is made up of related data points.

Data Series

Each worksheet is identified by the ________ found along the lower border of the Excel window

Sheet Tabs

To widen a column to fit the cell content of the widest cell in the column, the user should utilize

Autofit

In ________, Excel maximizes the number of cells visible on the screen.

Normal View

Which is the Excel operator for multiplication?

*

Which is the Excel operator for division?

/

Excel uses ________ to perform basic mathematical operations

Arithmetic Operators

Which is the Excel operator for exponentiation?

^

Absolute cell references are indicated by using what symbol in the cell address?

$

The ________ visually indicates which workbook cells are included in a formula calculation.

...

The process of specifying the appearance of cells and the overall layout of a worksheet is called

Formattin

A ________ shows the relationship of each part of the data to the whole.

Pie Char

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

...

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

A ________ is a value that originates in a worksheet cell and is represented in a chart

Data Marker

Each pie slice displayed on a pie chart is an example of a

Data Marker

On a pie chart, the ________ determines the size of each pie slice.

...

The ________ identifies patterns and colors assigned to categories in the chart.

Legend

A workbook sheet that contains only a chart is called a(n)

Chart Sheet

One way to tell which slice of pie on a pie chart goes with which set of data is to look at the

...

An image that appears to have length, width, and depth is said to be

3-D

Applying the shape effect ________ causes the edges of a shape to appear to be curved or angled.

Bevel

) To ________ one or more slices on a pie chart means to pull the slice(s) away from the rest of the chart.

Explode

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

To emphazise the slice to the person viewing the chart

In Excel, the ________ is made up of the chart and all of its elements

Chart Area

A movable, resizable container where text or graphics can be placed is called a

Text box

A gallery of text styles that can be used to apply decorative effects to text is

Word Art

Goal Seek is an example of a ________ tool.

What-If Analysis

Excel's ________ finds the input needed in one cell for another cell to have a desired value

Goal Seek

When calculating the amount of increase, the ________ is the starting point for the data.

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

Percent for new value is calculated using this formula: ________.

...

Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing a

What-If analysis

If you want to chart trends over time, you should use a ________ chart.

Line

A(n) ________ is a line that borders the chart plot area and serves as a frame of reference for measurement.

axis

On a line chart, the x-axis is also known as the

Category Axis

On a line chart, the y-axis is also known as the

Value Axis

On a line chart, the range of numbers for the data points are displayed on the

Y-Axis

On a line chart, the area that identifies the categories of data is called the

X-Axis

________ are short lines that appear on an axis at regular intervals.

Tick Marks

The spacing between tick marks is determined by the ________.

Major Value Unit

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

Chart Element Box

A predefined formula is called a

Function

The values that an Excel function uses to perform operations are called

Arguments

Excel's ________ function finds the middle value in a range

Median

Which Excel function would be used to find the middle value of a list of test scores?

Median

Which Excel function would be used to calculate the total points a student earned on a series of tests?

...

The Excel function ________ would be used to find the lowest score on a series of student test scores.

...

Excel's ________ function adds all of its arguments then divides the sum by the number of arguments.

...

The ________ function adds all of the numbers in a range of cells.

...

Excel's ________ function finds the largest value in a selected range of cells.

...

The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.

...

MIN and MAX are examples of ________ functions

...

If a cell's width is too narrow to properly display the numeric contents of the cell, Excel displays a series of ________ symbols.

...

Functions that test for a specific condition are called ________ functions.

...

IF is an example of a ________ function

...

The COUNTIF function takes two arguments:

...

The ________ function counts the number of cells within a range that meet a certain criteria.

...