Chapter 9 key terms
chart layouts gallery
...
chart styles gallery
...
mini toolbox
...
program-level buttons
...
pt.
...
underlying formula
...
workbook-level buttons
...
select all box
A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet
toggle buttons
A button that can be turned on by clicking it once, and then off by clicking it again.
embedded chart
A chart is inserted in the center of the worksheet.
data marker
A chart symbol (such as a bar, line, dot, slice, and so forth) that represents a single data point or value from the corresponding worksheet cell.
pie chart
A chart that shows the relationship of a part to a whole.
serif
A font that has curved or extended edges.
number format
A format that controls how numerical data is displayed, including the use of commas, dollar signs and number of decimal places
data series
A group of related information in a column or row of a worksheet that is plotted on a chart.
legend
A list that identifies patterns, symbols, or colors used in a chart.
series
A number of similar things laid out or happening in a certain order
landscape orientation
A page layout in which documents are printed across the length of a page, making the page wider than it is tall
portrait orientation
A page layout in which documents are printed across the width of a page, making the page taller than it is wide
footers
A piece of information printed at the bottom of the pages of a multiple page document to tie the document together
spreadsheet
A program that allows you to use rows and columns of data to manage, predict, and present information.
chart sheet
A separate sheet in a workbook that stores a chart.
gallery
A set of thumbnails that show visually the effect of each option.
data point
A single value originating in a worksheet
quick access toolbar
A small toolbar located to the right of the Microsoft Office Button, which provides quick access to tools you need often such as Save, Undo, and Repeat Typing
Arithmetic operator
A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations.
chart
A visual representation of data stored in a worksheet.
contextual tabs
Additional tabs that appear on the Ribbon when you select an object. The tabs contain commands that relate only to the selected object.
point and click method
Allows you to point and click each cell in a formula rather than typing cell references (EX 92).
chart layout
An arrangement that specifies which elements are included in a chart and where they are placed.
workbook
An excel document which contains three worksheets by default but can have more than three
keyboard shortcut
Any combination of keystrokes that can be used to perform a task that would otherwise require a mouse or other pointing device.
relative cell reference
Cell reference which changes according to the location of the cell in which the reference occurs
Absolute cell reference
Cell reference which remains fixed even if the cell in which the reference occurs is moving to a new location
bar chart
Data graphed as a series of bars.
general format
Default number format that automatically displays number, for the most part, the same way you enter them.
left alignment
Default paragraph format where the left edge of the paragraph is straight and the right edge is jagged
name box
Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.
chart style
Formatting applied to a chart based on the colors, fonts, and effects associated with the workbook's theme.
formula bar
Found directly above column headings; shows location in spreadsheet and what was typed in cell
expand horizontal scroll bar button
Increases the width of the horizontal scrool bar.
insert worksheet button
Inserts an additional worksheet into the workbook.
constant value
Numbers, text, dates, or times of day that you type into a cell.
normal view
PowerPoint's default view that displays the Slide pane, the Notes pane, and the Slides/Outline pane
right-click
Pressing the right mouse button to access special features of an application.
help button
Provides assistance with the program
context sensitive
Refering to an on-screen explanation that relates to a user's current software activity.
page orientation
Refers to whether a page is laid out vertically (portrait) or horizontally (landscape).
contextual tools
Sets of commands added to the Ribbon when a specific object is selected and which enable you to perform specific commands related to the selected object. Display only when needed and no longer display after the object is deselected.
horizontal window split box
Splits the worksheet into two horizontal views of the same worksheet.
vertical window split box
Splits the worksheet into two vertical views of the same worksheet.
category labels
Text displayed on the x-axis
title bar
The bar at the top of the screen that displays the name of the current window.
fill color
The color applied to the interior of a shape.
cell reference
The column letter and the row number. Example: B12
theme
The main idea or meaning of a text. Often, this is an insight about human life revealed in a literary work
font
The size, style, and design of text
pixel
The term "pixel" is actually short for "Picture Element." These small little dots are what make up the images on computer displays, whether they are flatscreen (LCD) or tube (CRT) monitors. The screen is divided up into a matrix of thousands or even millions of pixels.
sheet tab
The worksheet identifier that appears at the bottom of the workbook window
range
The y-coordinates of the set of points on a graph. Also, the y-coordinates of a given set of ordered pairs. The range is the output in a function or a relation.
live preview
This feature allows you to see how style formatting affects cells in your worksheet without having to return to the worksheet
Active Cell
This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected.
double-click
This mouse term refers to tapping the left mouse button twice in quick succession
select
To highlight a block of text.
drag
To move text by selecting it, holding down the mouse button, and moving the mouse.
picture element
What "pixel" is short for.
operators
Words or symbols that modify the search string instead of being part of it.
autocorrect
a Word feature that automatically corrects common spelling errors
column chart
a chart that uses bars of varying height to illustrate values in a worksheet
column heading
a column letter above the grid that identifies each column
autosum
a function that automatically adds the values in the cells directly above or to the left of the active cell
row heading
a number at the far-left side of a row that can be clicked to select the entire row of cells
Auto fill
a quick and easy way to copy the contents of one cell (data or formulas) into another cell or range of cells
ribbon
a tab that when opened displays related commands
page layout view
allows you to create or modify a worksheet while viewing how it will look in printed format
formula
an equation that calculates a new value using values currently on a worksheet
point
an exact location in space
dialog box launcher
an icon available in many groups on the ribbon that you can click to open a dialog box or task pane related to the current group
function
an input-output relationship that has exactly one output for each input
row
appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window
column
appears vertically in a worksheet and is identified by letters at the top of the worksheet window
shortcut menu
appears when you right-click an object, is a list of frequently used commands that relate to the right-clicked object
nonadjacent ranges
cells that are not next to each other; can be put into a name box using a comma
view options
contains buttons for viewing the document in Print Layout, Full Screen Reading, Web Layout, OUtline, or Draft views, and also displays controls to Zoom Out and Zoom in
value axis
contains numerical values that help interpret size of chart elements
displayed value
data displayed in a cell ; number of digists or charcters tha appear in a cell; depends on the width of the column
underlying value
data displayed in the Formula Bar
Accounting Number Format
displays numbers with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place)
worksheet grid
displays the columns and rows that intersect to form the worksheet's cells
font style
effects such as bold, italic, and underline
chart types
excel includes 11 chart types; column, line, pie, bar, area, x y, stock, surface, doughnut, bubble, and radar.
data
facts, figures, and other evidence gathered through observations
format painter
feature that allows a user to copy the format of text to other areas in a document
category axis
horizontal axis of a chart, usually containing the names of data groups; in a 2-dimensional chart, also known as the x-axis
expand formula bar button
increases the heigh of the formula bar to display lenghty cell content
screentip
information displayed in a small window when you rest the pointer over a button or window element
comma style
inserts thousand comma separators and applies two decimal places
sheet tab scrolling buttons
let you navigate to additional sheet tabs when available
fill handle
lets you copy cell contents or continue a series of data into a range of selected cells
status bar
located at the bottom of the window and contains information pertaining to the document such as page number, word count page layout, and the zoom slider
edit
make changes to a document
points
measurement of font size
cell address
named using the letter and number where the column and row intersect
value
numeric characters that can be calculated in a spreadsheet
office button
opens a menu of commands related to managing and sharing documents, including opening, printing, and saving a document, creating a new document, and preparing for distribution
formatting
overall look of a document
Adjacent ranges
ranges, or groups of cells, that are next to each other
scroll box
reflects the location of the portion of the document that is displayed in the document window
headers
text such as title, page numbers, and dates printed at the top of a page
x-axis
the horizontal line on a graph
font size
the size of the text measured in points
cell
the space formed by the intersection of a row and a column; the basic unit of a worksheet
y-axis
the vertical line on a graph
sum
the whole amount
cell content
the words, numbers, and symbols that appear inside a cell
worksheet
the workspace made up of columns and rows where you enter data to create an electronic spreadsheet
rounding
to approximate a number by replacing it with a number expressed in tens, hundreds, thousands, and so on
range finder
useful for verifying formulas or quickly positioning the insertion point within the cell to perform editing dierctly in the cell