PowerPoint Excel

Ace your homework & exams now with Quizwiz!

Chart Elements button

A button that enables you to add, remove, or change chart elements such as the title, legend, gridlines, and data labels.

Chart Filters button

A button that enables you to change which data displays in the chart.

Chart styles button

A button that enables you to set a style and color scheme for your chart.

Auto sum

A button that provides quick access to the SUM function.

Absolute Cell reference

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.

Column chart

A chart in which the data is arranged in columns and that is useful for showing how data changes over a period of time or for illustrating comparisons among terms.

Data marker

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.

Context sensitive

A command associated with the currently selected or active object; often activated by right-clicking a screen item.

Cell style

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Auto Calculate

A feature that displays three calculations in the status bar by default--Average, Count, and Sum--when you select a range of numerical data.

Auto Complete

A feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.

Chart styles gallery

A group of predesigned chart styles that you can apply to an excel chart.

Function

A predefined formula--- a formula that Excel has already built for you--- that performs calculations by using specific values in a particular order.

Data point

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

Column

A vertical group of cells in a worksheet

Auto fit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

Excel pointer

An Excel window element with which you can display the location of the pointer.

Expand Formula Bar button

An Excel window element with which you can increase the width of the horizontal scroll bar.

Formula bar

An element in the excel window that displays the value or formula contained in the active cell; here you can also enter or edit values or formulas.

Formula

An equation that performs mathematical calculations on values in a worksheet.

Auto fill

An excel feature that generates and extends values into adjacent cells based on the values of selected cells

Cell address

Another name for a cell reference.

Cell content

Anything typed into a cell.

Format

Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read.

Constant value

Number, text, dates, or times of day that you type into a cell.

Data series

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

Data

Text or numbers in a cell

Accounting Number Format

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.

Comma style

The Excel number format that insects thousand comma separators where appropriate and applies two decimal places; comma style also leaves space at the right to accommodate a parenthesis when negative numbers are present.

Category axis

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

Active cell

The cell surrounded by a black border ready to receive data or be affected by the next Excel command.

Chart layout

The combination of chart elements that can be displayed in a chart such as a title, legend,labels, for the columns, and the table of charted cells.

Displayed value

The data that displays in a cell.

General format

The default format that Excel applies to numbers; this format has no specific characteristics--- whatever you type in the cell will display, with the exception that trailing zeros to the right of a decimal point will not display.

Chart

The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers.

Cell reference

The identification of a specific cell by its intersecting column letter and row number

Cell

The intersection of a column and a row.

Category labels

The labels that display along the bottom of a chart to identify the categories of data; Excel uses the row titles as the category names.

Column heading

The letter that displays at the top of a vertical group of cells in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of letters identifies each column.

Chart style

The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have flat or beveled columns, colors that are solid or transparent, and backgrounds that are dark or light.

Fill handle

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

Arithmetic operators

The symbols +,-,*,%, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.

Chart types

Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts.


Related study sets

Unit 5: Enlightenment and Revolutions

View Set

Vocabulary and Analytical Reasoning V

View Set

Computer Science 105 Chapter 3 Study Guide

View Set

Pharm Exam 3 Study Guide (Benzodiazepines)

View Set

Honors world history study guide

View Set

Pharm Ch 7, prep u + roach vocab

View Set

Paper 1 - Japanese Expansion Events

View Set