Excel Chapter 1

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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.

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, such as font color, cell borders, and cell shading

Series

A group of things that come one after another in succession

Row

A horizontal group of cells in a worksheet

Normal view

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

Normal format

A specific way in which Excel displays numbers in a cells

Sparkline

A tiny chart in the background of a cell that gives a visual trend summary alongside your data

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.

Formula bar

An element in the excel window

Auto Fit

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

Recommended charts

An excel feature that displays a customized set of charts

Label

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

Spreadhead

Another name for a worksheet

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 a cell

Data

Text or numbers in a cell

Pixel

The abbreviated name for a name for a element

Numbered row headings

The area along the left edge of a worksheet tha identifies each row with a unique numbers

Active cell

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

General format

The default format that Excel applies that Excel has already built for you

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

The intersection of a column and a row

Sheet tabs

The labels along the lower border of the excel window

Column heading

The letter that displays at the top of a vertical group of cells in a worksheet.

Chart style

The overall visual look of chart in terms of its graphic effects, color, and backgrounds

Fill handle

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

Operators

The symbols with which you can specify the types of calculator you want to perform in an Excel formula

Range

Two or more selected cells on a worksheet that are adjacent or nonadjacent

Chart types

Various chart formats used in a way that is meaningful to the reader.

Function

predefined formula

Data series

related data points represented by data markers

Auto fill

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

Row heading

The numbers along the left side of an excel worksheet that designate the row numbers

Accounting number format

The excel number format that applies a thousand comma separator where appropriate

Comma style

The excel numbers format that inserts thousand comma separators where appropriate and applies two decimals places


Ensembles d'études connexes

Розділ 5. Становлення України як незалежної держави

View Set

ASWB Social Work Practice Questions

View Set

Lugares en la ciudad con frases (Quizizz)

View Set

Microbiology Chapter 12: Drugs, Microbes, Host- The Elements of Chemotherapy

View Set

Topic 3: INFORMATION OVERLOAD AND ITS CAUSES

View Set

основные константы крови

View Set