Home
Subjects
Create
Search
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Other
Computer Skills
Excel
Excel Chapter 1 Vocabulary
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
GO! Text pg. 268
Terms in this set (43)
Absolute Cell Reference
A cell reference that refers to cells by thier fixed position in a worksheet; and absolute cell reference remains the same when the formula is copied
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
Active Cell
The cell, surrounded by a black border, ready to receive dara or be affected by the next Excel command
Arithmetic Operators
The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula
AutoComplete
A feature that speedsd 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 character for you
Auto Fill
An Excel feature that generates and extends values into adjacent cells based on the values of selected cells
AutoFit
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column
AutoSum
Another name for the SUM function
Category Axis
The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis
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
Cell
The intersection of a column and a row
Cell Address
Another name for a cell reference
Cell Content
Anything typed into a cell
Cell Reference
The identification of a specific cell by its intersecting column letter and row number
Cell Style
A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading
Chart
The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of number
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
Chart Layouts Gallery
A group of predesigned chart layouts that you can apply to an Excel chart
Chart Styles
The overall visual look of a chart in terms of irs graphic effects, colors, and backgrounds; for example, you can have flat or beveled columns, colors that solid or transparent, and backgrounds that are dark or light
Chart Styles Gallery
A group of predesigned chart styles that you can apply to an Excel chart
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
Column
A vertical group of cells in a worksheet
Column Chart
A chart in which the data is arranged in columns and which is useful for showing data changes over a period of time or for illustrating comparisons among items
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 alpabet, a unique letter or combination of letters identifies each column
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
Constant Value
Numbers, text, dates, or times of day that you type into a cell
Context Sensitive
A command associated with activites in which you are engaged; often activated by right-clicking a screen item
Data
Text or numbers in a cell
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
Data Point
A value that originates in a worksheet cell and that is represented in a chart by a data marker
Data Series
Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend
Displayed Value
The data that displays in a cell
Expand Formula Bar Button
An Excel window element with which you can increase the height of the Formula Bar to display lengthy cell content
Expand Horizontal Scroll Bar Button
An Excel window element with which you can increase the width of the horizontal scroll bar
Fill Handle
The small black square in the lower right hand corner of a selected cell
Format
Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read
Formula
An equation that performs mathematical calculations on values in a worksheet
Formula Bar
An element in the Excel window that displays the value or formula contained in the acitve cell; here you can also enter or edit values or formulas
Function
A predefined formula - a formula that Excel has already built for you - that performs calculations by using specific calues in a particular order or structure
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
Horizontal Window Split Box
An Excel window element with which you can split the worksheet into two horizontal views of the same worksheet
Insert Worksheet Button
Located on the row of sheet tabs, a sheet tab that, when clicked, inserts an additional worksheet into the workbook
Label
Another name for a text value, and which usually provides information about number values
This set is often in folders with...
Word Chapter 1 Vocabulary
39 terms
Word Chapter 3 Vocabulary
27 terms
Excel Chapter 2 Vocabulary
34 terms
Excel Chapter 3 Vocabulary
35 terms
You might also like...
Chapter 1: Creating a Worksheet and Charting Data
81 terms
Excel
90 terms
Excel Chapter 1 Vocab
90 terms
Excel
90 terms
Other sets by this creator
Death and Dying Chapter 14
37 terms
Death and Dying Chapter 13
29 terms
Death and Dying Chapter 12
10 terms
Death and Dying Chapter 11
21 terms
Other Quizlet sets
Final Exam Review 2015
113 terms
Viz Com Test #3 Ch. 4 & 5
47 terms
Peds. Post Test Questions
17 terms
HUN1201 Mindtap Assignments
152 terms