Excel Vocabulary

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

Cell Style

A defined combination of formatting characteristics—such as number, alignment, font, border, and fill.

Data Marker

A dot, a bar, or a symbol used to represent one number from the worksheet.

Auto Fill

A feature that can be used to automatically fill in worksheet data in any direction

Range

A group of cells

Fill Handle

A little black square in the lower-right corner of the selected cell

Embedded Chart

A newly created chart that is saved as a graphic object and is saved as part of the worksheet

Workbook Window

Area of the program window displaying the worksheets

Fill

Background color or pattern

Functions

Built-in formulas that enable you to perform complex calculations easily.

Columns

Cells that display vertically and are labeled from left to right beginning with A through Z, then AA through AZ, and so on.

Workbook

Collection of related worksheets

Chart Area

Complete chart and all its elements

Mixed Reference

Contains both relative and absolute cell references

Sheet Tab

Displays the name of each sheet in the workbook

Chart

Graphic representation of worksheet data

Worksheet

Grid with columns and rows where you enter and summarize data.

Error Value

Indicates when a formula you have entered results in an error

Vertical Axis

Line on chart used for plotting values, also called Y-axis

Horizontal Axis

Line on chart used for showing categories, also called X-axis.

Gridlines

Lines extending from the vertical or horizontal axes across the plot area of a chart

Legend

List that identifies the patterns or colors of the data series or categories in a chart

Name Box

Located below the ribbon and displays the call reference of the active cell

Formula Bar

Located next to the Name box and displays the value or formula of the active cell

Drag-and-Drop Method

Method to move or copy a selection to a new location in your worksheet

Constants

Numbers entered directly into formulas that do not change

Absolute Reference

Permanent reference to a cell; does not change in relation to the location of the formula.

Data Source

Range of cells that contain the data for the chart

Sheet

See worksheet

Chart Sheet

Separate sheet in a workbook containing a chart

Data Series

Series of related values from the worksheet graphically represented by a unique color or pattern

Formula

Set of instructions used to preform calculations on values in a worksheet

Drawing Objects

Shapes, curves, or lines that are part of your worksheet

Order of Operations

Specific sequence used to calculate the value of a formula

Active Cell

The cell that is selected in a worksheet.

Cell Refrence

The column letter followed by the row number that identifies a cell, such as B5

Font

The design of a set of letters and numbers

Cell

The rectangle where a column and row intersect

Relative Reference

The reference to a cell that changes in relation to the location of the formula

Spreadsheet Software

Used to calculate, analyze, and visually represent numerical data.

Font Style

Variations in the shape or weight of a font's characters.


Kaugnay na mga set ng pag-aaral

Micro Exam 1 (CH. 1-6 Quick Quizzes)

View Set

Chapter 8: Communications and Networks

View Set