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.