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