BITM 215 exam #1 (import from Quizlet)

Workbook

An Excel file with one or more worksheets.

cell

The intersection of a column and a row in a worksheet.

cell reference

The column letter and the row number. Example: B12

range

a rectangular group of cells such as A1:B3

label

text data in a worksheet that is not used in calculations

value

numerical data in a worksheet

Active Cell

a selected worksheet cell that is ready for data entry

series

list of labels or values that follow a pattern

fill handle

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

formula

A calculation entered by the user for the data in the spreadsheet. e.g. =(A6+A7)-A5

function

built in formula

Syntax

required elements and the order of those function to work

Name Box

Area in the formula bar that displays the cell address of the active cell

Alignment

the position of data within a cell

indent

command that moves data away from the left edge of the cell

Office Clipboard

a storage area for storing cut and copied items that can hold up to 24 items at once, and which is accessible from any Office program.

function

built in formula

SUM

Function that adds the values in a range of cells.

argument

cell reference, value or other element required for a function

Range Finder

feature that highlights and color-codes a formula cell range in edit mode

Mini toolbar

A small toolbar with popular commands that appears when you point to selected text.

Format Painter

A tool that enables you to copy formatting from a cell and apply it to another cell or range.

border

outline of a cell range

Gradient

a blend of two or more colors used as fill

Wrap Text

formatting tool that allows you to display the contents of a cell on multiple lines

line break

Start of a new line in a cell made by pressing Alt+Enter

Formula AutoComplete

A feature that speeds up the manual entry of functions.

relative cell reference

A cell address such as B2

absolute cell reference

A cell reference with dollar signs such as $B$2

mixed cell reference

a cell reference that contains both relative and absolute references

3D cell reference

To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:

Range name

An identifying label assigned to a group of cells.

scope

a worksheet set as the location for a range name

circular reference

An error that occurs when a formula references the cell it is stored in.

AutoCalculate

status bar area that displays calculations for selected cells

chart

A graphical representation of data

Chart object

an item or element in a worksheet

chart sheet

A separate sheet in a workbook that stores a chart.

source data

the cells with values and labels used to build a chart

chart layout

a set of elements and the location of those elements

Chart style

a predefined set of chart colors and fills that you can apply to any chart

Shape styles

A predesigned set of fill colors, borders and effects

WordArt

A text box with a preset design, often used to format a chart title.

sunburst chart

Displays a hierarchical view of data with concentric rings. The top hierarchy is the inner ring and each outer ring is related to its adjacent inner ring

waterfall chart

depicts a running total for positive and negative values

Sparkline

a mini chart you can insert into a cell

table

excel data formatted with a header row followed by data rows

header row

The first row of the table that is formatted differently and should be repeated for tables that continue beyond one page.