Excel 1 & 2

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

A cell reference that refers to a cell by its fixed position in a worksheet and does not change when the formula is copied

Absolute cell reference

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

Active cell

A chart line that contains words as labels

Argument

Symbols that specify mathematical operations such as addition or subtraction

Arithmetic operations

Automatically changing the column width to accomodate the longest column entry

Autofit

The function that adds a group of values and the divides the result by the number of values in the group

Average

The values that determine how a function should be used

Category axis

The column letter and row number that identify a cell

Cell address

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

Cell reference

A predesigned combination of chart elements.

Chart layout

A worksheet that contains only a chart

Chart sheet

A prebuilt chart format that applies an overall visual look to a chart

Chart style

A chart type useful for illustarting comparisons among related numbers

Column chart

The related data points in a chart

Data series

The data displayed in a cell

Displayed value

A green triangle that indicates a possible error in a formula

Error Indicator

The small green square in the lower right corner of the active cell

Fill handle

An equation that performs mathematical calculations on number values

Formula

An excel feature that suggest values as you type a function.

Formula autocomplete

An excel window area that displays the value contained in the active cell

Formula bar

A prewritten Excel Formula

Function

The box that identifies the patterns or colors assigned to the data series

Legend

The excel window area that displays the address of a selected cell

Name box

A view that maximizes the number of cells visible on the screen.

Normal view

Rules that specify the way numbers should display

Number format

Page headers and footers can be changed in this view

Page layout view

The chart type that best displays the relationship of parts to a whole

Pie chart

Tow or more cells on a worksheet

Range

The excel feature that outlines all of the cells referenced in a formula.

Range Finder

The number that displays at left of a row

Row heading

A command with which you can display text on multiple lines within a cell

Text wrap

data in a cell - text or numbers

Value

A chart line that contains numeric data

Value axis

An excel file that contains one or more worksheets

Workbook

The primary document that you use in Excel to store and work with data

Worksheet

A graphical representation of data in a worksheet that shows comparisons, patterns, and trends

chart

A chart placed on a worksheet with the source data

embedded chart

The default format applied to numbers

general format

Data in a cell made up of numbers only

number value

Data in a cell made up of text only

text value


Kaugnay na mga set ng pag-aaral

Cog Psych Exam 2 short term memory

View Set

Section I: Supply Managment Concepts

View Set

MKT - 3350 Chapter 6 Quiz (Harper)

View Set

Sociology - Real World - Ch 11: Globalization Issues

View Set

Chapter 3 Catholic Church in Medieval Europe: 3.2, 3.3, 3.5 The Christian Church Takes Shape

View Set

Supply Chain Management: Key Concepts

View Set