Unit 3- Chapter 8: Key words

Sheet tabs

-3 sheet tabs-default -adding sheet tabs -deleting sheet tabs -renaming sheet tabs -changing tab colors

Cell Alignment

-Text (left aligned) -Numbers (right aligned)

Writing a formula

-begin with equal sign (=) -point and click method...or....use the key method

Operands

-cell addresses -numbers

Column Width

-default -8.43 characters- or 64 pixels -autofit -scaling

Editing values

-recalculates automatically

IF (Logical Function)

-uses comparison operators -< (less than) -> (greater than) -= (equal to) ->= (greater than or equal to) -<= (less than or equal to) -<> (not equal to)

########### symbol

-works with "text values" only

Worksheet Parts

...

-currency format

....

Rotating Text

....

Show Formulas

....

Wrapping Text

....

Enter data by range

.....

Spell Checking

.....

Function arguments

......

Clearing Cell Contents/Format

.......

Insert/Delete Rows

.......

Copy/Cut/Pasting

........

Insert/Delete Columns

........

Printing Multiple Worksheet

........

-COUNT (statistical function)

...........

-select All box

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

-Data bars (works with number values ONLY)

A cell format consisting of a shaded bar that provides a visual cue to the reader about the value of cell relative to other cells; the length of the bar represents the value in the cell- a longer bar represents a higher value and a shorter bar represents a lower value.

-legend

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

~Column chart

A chart in which the data is arranged in columns and is useful for showing data changes over a period of time or for illustrating comparisons among items.

~pie charts

A chart that shows the relationship of each part to a whole.

~line charts

A chart type that displays trends over time; time displays along the bottom axis and the data point values are connected with a line.

-data marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series.

Freezing/Unfreezing pane

A command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes.

Merge & Center

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

Find & Replace feature

A command that searches the cells in a worksheet- or in a selected range- for matches and then replace each match with a replacement value of your choice.

Conditional Format

A format that changes the appearance of a cell- for example, by adding cell shading or font color- based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.

IF (logical function)

A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false.

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.

-value axis (Y-Axis)

A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.

-SUM (Statistical function)

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

SUM (AutoSum) function

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

Functions

A predefined formula- a formula that Excel has already built for you- that performs calculations by using specific values in a particular order or structure.

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.

Footers

A reserved area for text or graphics that displays at the bottom of each page in a document.

Headers

A reserved area for text or graphics that displays at the top of each page in a document.

Number formats

A specific way in which Excel displays numbers in a cell.

COUNT IF (statistical function)

A statistical function that counts the number of cells within a range that meet the given condition; this function has two arguments - the range of cells to check and the criteria.

-sparklines

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

-data points

A value that originates in a worksheet cell and that is represented in a chart by a data marker.

-columns

A vertical group of cells in a worksheet.

Print Preview

A view of a document as it will appear when you print it.

Summary Sheet

A worksheet where totals from other worksheets are displayed and summarized.

Print titles

An Excel command that enables you to specify rows and columns to repeat on each printed page.

-autofit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

Workbook

An Excel file that contains one or more worksheets.

-AVERAGE (statistical function)

An Excel function that adds a group of values, and then divides the result by the number of values in the group.

MAX (statistical function)

An Excel function that determines the largest value in a selected range of values.

MIN (statistical function)

An Excel function that determines the smallest value in a selected range of values.

MEDIAN (statistical function)

An Excel function that finds the middle value that has as many values above it in the group as are below it; it differs from AVERAGE in that the result is not affected as much by a single value that is greatly different from the others.

NOW (date and time function)

An Excel function that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell.

-formula bar

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.

-name box

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

-formula

An equation that performs mathematical calculations on values in a worksheet.

Cell contents

Anything typed into a cell.

Format (appearance)

Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read.

~text values

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

Absolute Cell Reference

In Excel, a cell reference that refers to cells by their fixed position in worksheet; an absolute cell reference remains the same when the formula is copied. Ex. $ symbol

Relative Cell Reference

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

-quick access toolbar

In an Office program, the small row of buttons in the upper left corner of the screen from which you can perform frequently used commands.

Truncated text

Refers to data that is cut off or shortened.

-data series

Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

-accounting number format

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.

-comma style format

The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places; comma style also leaves space at the right to accommodate a parenthesis when negative numbers are present.

-category axis (X-axis)

The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.

-numbered row headings

The area along the left edge of a worksheet that identifies each row with a unique number. (Worksheet=1,048,576 rows)

-lettered column headings

The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters. [16,384 headings (A to XFD)]

-Title bar

The bar across the top of the window that indicates the name of the current file and displays the program name. (Book1-default name)

Active Cell

The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.

Chart

The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers.

Cell Reference (cell address)

The identification of a specific cell by its intersecting column letter and row number.

Cell (Excel)

The intersection of a column and a row.

-sheet tabs

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

-category labels

The labels that display along the bottom of a chart to identify the categories of data; Excel uses the row titles as the category names.

Worksheet/Spreadsheet

The primary document that you use in Excel to work with and store data; it 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.

Fill Handle

The small black square in the lower right corner of a selected cell.

Arithmetic Operators

The symbols +, -, *, /, %, and ^ used to denote addition, subtraction, multiplication, division, percentage, and exponentiation in an Excel formula.

-Default-"General" format

The term that refers to the current selection or setting that is automatically used by a computer program unless you specify otherwise.

-ribbon

The user interface in Office 2010 that groups the commands for performing related tasks on tabs across the upper portion of the program window.

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.

-chart types

Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts.

-value

another name for constant value-numbers, text, dates, or times of day that you type into a cell.

~number value

constant values consisting of only numbers

#DIV/O!

error message

-default

the term that refers to the current selection or setting that is automatically used by a computer program unless you specify otherwise.