BTS 165 Ch 1, Part 2 - Creating a Worksheet and Charting Data

Select All box

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

legend

A chart element that identifies the patterns or colors that are assigned to the categories int he chart.

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.

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.

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 digit to its right is 5 or above.

Page Layout view

A screen view in which you can use the rulers to measure the width and height of data, set margins for printing, hide or display the numbered row headings and the lettered column headings, and change the page orientation; this view is useful for preparing your worksheet for printing.

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 Excl displays numbers in a cell.

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 loser 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.

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.

label

Another name for a text value, and which usually provides information about number values.

spreadsheet

Another name for a worksheet.

X-axis

Another name for the horizontal (category) axis.

Y-axis

Another name for the vertical (value) axis.

workbook-level buttons

Buttons at the far right of the ribbon tabs that minimize or restore a displayed workbook.

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.

left alignment

The cell format in which characters align at the left edge of the cell; this is the default for text entries and is an example of formatting information stored in a cell.

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.