Excel Chapter 1

Ace your homework & exams now with Quizwiz!

Row

A horizontal ground on cells in a worksheet.

Auto Fill

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

General Format

The default format that excel applies to numbers; this format has no specific characteristics.

Accounting Number format

The excel number format that applies to a thousand comma separator when appropriate.

Comma Style

The excel number format that inserts 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.

Chart

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

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.

Worksheet

The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

Operators

The symbols with which you can specify the type of calculations you want to perform in an excel formula.

AutoSum

A button that provides quick access to the SUM function.

Legend

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

Merge & Center

A command that joins selected cells in an excel worksheet into one larger cell and centers the contents in the merged cell.

Cell Style

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

Series

A group of things that come one after another in succession; for example, January, February, March, and so on.

Theme

A predefined set of colors, fonts, lines, and fill effects that coordinate with each other.

Spreadsheet

Another name for a worksheet.

Range

Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.

Chart Types

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

Absolute Cell reference

All 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.

Workbook

An Excel file that contains one or more worksheets.

AutoFit

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

Format

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

Relative cell reference

In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula.

Data

Text or numbers in a cell.

Cell

The intersection of a column and a row.

Data series

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

Sheet Tabs

the labels along the lower border of the Excel window that identify each worksheet.

Function

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

Normal View

A screen view that maximizes the number of cells visible on your screen and keeps the column letters and row numbers close to the columns and rows.

Number format

A specific way in which excel displays numbers in a cell.

Sparkline

A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.

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.

Numbered row headings

The area along the left edge of a worksheet that identifies each row with a unique number.

Status bar

The area along the lower edge of the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information; on the right side, when numerical data is selected, common calculation such as Sum and Average display.

Active cell

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

Row heading

The numbers along the left side on an Excel worksheet that designate the row numbers.

Chart Style

The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have a 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.

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.

Recommended Charts

An excel feature that displays a customized set of charts that, according to the Excel's calculations, will best fit your data based on the range of data that you select.

Label

Another name for a text value, and which usually provides information about number values.

X-axis

Another name for the horizontal (category) axis.

Y-axis

Another name for the vertical (value) axis.

Pixel

The abbreviated name for a picture element.


Related study sets

CFP 3 Unit 5 Alternative Investments and Derivatives

View Set

SAP MM all Practice Questions (books 1-4)

View Set

Urinary Catheterization: 210L Quiz #11

View Set