Upgrade to remove ads
BTS 161/165 - Excel Ch 1A - Creating a Worksheet and Charting Data - Part 1
Terms in this set (44)
in a worksheet, these are the vertical spaces; these are headed with letters
The small black square in the lower-right corner of a selected cell.
(v) Changing the appearance of cells and worksheet elements to make a worksheet more attractive and easy to read.
Absolute cell reference
This refers to cells by their fixed position in a worksheet; this remains the same when the formula is copied (Ex: $A$1)
Accounting Number Format
the Excel number format that applies a thousand comma separator, inserts a U.S. dollar sign aligned left, and applies two decimal places
the cell, surrounded by a green border, ready to receive data or a command
the symbols + , - , * , / , % , and ^ used to show addition, subtraction, multiplication, division, percent, and exponents in an Excel formula
A feature that displays three calculations in the status bar by default - Average, Count, and Sum - when you select a range of numerical data.
an Excel feature that generates and extends values into adjacent cells based on the values of selected cells
a feature that displays three calculations in the status bar by default - Average, Count, and Sum - when you select a range of data
Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column
A button that provides quick access to the SUM function
the area along the bottom of a chart that identifies the categories of data; also known as the x-axis
the labels that display along the bottom of a chart to identify the categories of data
the intersection of a column and a row
the identification of a specific cell by its intersecting column letter and row number
a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading
Another name for a cell reference.
Anything typed into a cell.
The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers.
Chart Elements button
A button that enables you to add, remove, or change chart elements such as the title, legend, gridlines, and data labels.
Chart Filters button
A button that enables you to change which data displays in the chart.
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.
The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have flat or beveled columns, colors that are solid or transparent, and backgrounds that are dark or light.
Chart Styles button
A button that enables you to set a style and color scheme for your chart.
Chart Styles gallery
A group of predesigned chart styles that you can apply to an Excel chart.
Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts.
A chart in which the data is arranged in columns and that is useful for showing how data changes over a period of time or for illustrating comparisons among items.
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.
The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places; it also leaves space at the right to accommodate a parenthesis when negative numbers are present.
Numbers, text, dates, or times of day that you type into a cell.
A command associated with the currently selected or active object; often activated by right-clicking a screen item.
text or numbers in a cell.
A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points from a data series.
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.
The data that displays in a cell.
An Excel window element with which you can display the location of the pointer.
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.
An equation that performs mathematical calculations on values in a worksheet.
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.
A predefined formula - a formula that Excel has already built for you - that performs calculations by using specific values in a particular order.
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.
This set is often in folders with...
BTS 161/147 - PowerPoint Ch 1 - Getting…
BTS 161 - Go! with Windows 10, Getting S…
BTS 161 - Introduction to Microsoft Offi…
BTS 161 Word Ch 1 - Creating Documents w…
Other sets by this creator
BTS 161/165 - Excel Ch 2 - Using Functio…
BTS 161/165 - Excel Ch 1B - Creating a W…
BTS 161 Word Ch. 2 - Creating Cover Lett…
BTS 161 Word Ch. 2 - Creating Cover Lett…
Other Quizlet sets
MAORI 130G MULTICHOICE/SHORT ANSWER
Jackson - Bio 102 - Exam #1
Unit 8 Quiz Biology
Diabetes Crises Lecture