BATECH 161/165 - Excel Ch 1B - Creating a Worksheet and Charting Data- Part 2

Select All box

A box in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet.

Switch Row/Column

A charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa.

Show Formulas

A command that displays the formula in each cell instead of the resulting value.

Merge & Center

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell.

Wrap Text

A formatting command that displays the contents of a cell on multiple lines.

series

A group of things that come one after another in succession; for example, January, February, March, and so on.

row

A horizontal group of cells in a worksheet.

worksheet grid area

A part of the Excel window that displays the columns and rows that intersect to form the worksheet's cells.

picture element

A point of light measured in dots per square inch on a screen; 64 pixels equals 8.43 characters, which is the average number if characters that will fit in a cell in an Excel worksheet using the default font.

SUM function

A predefined formula that adds all the numbers in a selected range of cells.

theme

A predefined set of colors, fonts, lines, and fill effects that coordinate with each other.

Rounding

A procedure in which you determine which digit at the right of the number will be the last digit displayed and then increase it by one if the next digit to its right is 5, 6, 7, 8, or 9.

normal view

A screen view that maximizes the number of cells visible on your screen and keeps the column letters and row numbers close to the columns and rows.

number format

A specific way in which Excel displays numbers in a cell. There are 11 to chose from in the drop-down menu.

sparkline

A tiny chart in a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.

Quick Analysis tool

A tool that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas.

Recommended Charts

An Excel feature that displays a customized set of charts that, according to Excel's calculations, will best fit your data based on the range of data that you select.

range finder

An Excel feature that outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula.

workbook

An Excel file that contains one or more worksheets.

Middle Align

An alignment command that centers text between the top and bottom of a cell.

Name Box

An element of the Excel window that displays the name of the selected cell, table, chart or object.

value

Another name for a constant value.

spreadsheet

Another name for a worksheet.

X-axis

Another name for the horizontal (category) axis.

Y-axis

Another name for the vertical (value) axis.

sheet tab scrolling buttons

Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided.

number values

Constant values consisting of only numbers.

text values

Constant values consisting of only text, and which usually provide information about number values; also referred to as labels.

relative cell reference

In a formula, the address of a cell based on the relative positions of the cell that contains the formula and the cell referred to in the formula.

value axis

Numerical scale on the left side of a chart that shows the range of numbers for the data points; also called the Y-axis.

pixel

The abbreviated name for a picture element.

numbered row headings

The area along the left edge of a worksheet that identifies each row with a unique number.

status bar

The area along the lower edge of the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information; on the right side, when numerical data is selected, common calculations such as Sum and Average display.

lettered column headings

The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters.

underlying value

The data that displays in the Formula Bar.

underlying formula

The formula entered in a cell and visible only on the Formula Bar.

sheet tabs

The label along the lower border of the Excel window that identify each worksheet.

row heading

The numbers along the left side of an Excel worksheet that designate the row numbers.

worksheet

The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

scaling

The process of shrinking the width and/or height of printed output to fit a maximum number of pages.

operators

The symbols with which you can specify the type of calculation you want to perform in an Excel formula.

point and click method

The technique of constructing a formula by pointing to and then clicking cells; this method is convenient when the referenced cells are not adjacent to one another.

range

Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.