Chap. 10 Key Terms Flashcards
ABSOLUTE CELL REFERENCE
Refers to a cell by its fixed position in the worksheet. ie: the total in cell E10.
ACCOUNTING NUMBER FORMAT
Applies a thousand comma separator where appropriate.
ACTIVE CELL
The cell is outlined in black and ready to accept data
ARTISTIC EFFECTS
Formats applied to images that make pictures resemble sketches or paintings
ARITHMETIC OPERATORS
Symbols used to perform basic mathematical operations in Excel.
AUTOCOMPLETE
Action wherein Excel fills in the remaining alphabetic values(characters) for you.
Auto Fill
________ generates and extends a series of values into adjacent cells based on the values of other cells.
AUTOFIT
To widen a column to fit the cell content of the widest cell in the column.
AUTOSUM
Button found in the editing group on the home tab where a larger version of the button is displayed on the formulas tab in the function library group.
BLACK SLIDE
A slide that displays at the end of every slide show to indicate that the presentation is over.
CATEGORY AXIS
On a line chart, the x-axis is also known as the
CATEGORY LABELS
Labels that display along the bottom of a chart to identify the category of the data are called
CELL
A ________ is created when a row and a column intersect
CELL ADDRESS
Another name for cell reference The intersecting column letter and row number form the cell reference.
CELL CONTENT
Anything a user types into a cell is known as
CELL REFERENCE
The intersecting column letter and row number
CELL STYLES
________ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
CHART
For data to be more easily understood, it can be presented in a ________ instead of a table of numbers.
CHART LAYOUT
A combination of chart elements, which can include a title, legend, labels for the columns, and the table of charted cells.
CHART LAYOUTS GROUP
Located on the design tab, you can select a predesigned chart layout.
CHART STYLES
The overall visual look of the chart in terms of it’s color, backgrounds, and graphic effects such as flat or beveled columns.
CHART STYLES GALLERY
Displays an array of pre-defined chart styles.
CHART TYPES
Column, pie, an line charts.
COLUMN
A vertical group of cells in a worksheet
COMMA STYLES
The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parenthese
COLUMN CHART
Useful for illustrating comparisons among related numbers.
COLUMN HEADING
Beginning with the first letter of the alphabet, A, a unique letter that identifies each column.
CONSTANT VALUE
Value
CONTEXT SENSITIVE
Because options are related to the current task, the button is referred to as being context sensitive.
DATA
Text or numbers in a cell.
DATA SERIES
In an Excel chart, a ________ is made up of related data points.
DATA MARKER
Each pie slice displayed on a pie chart is an example of a
DATA MARKER
A ________ is a value that originates in a worksheet cell and is represented in a chart
DATA POINT
Values that originate in a worksheet that are to be charted are called
DATA POINT
A data marker, such as a column, dot, or pie slice on a chart, represents a single
DISPLAYED VALUE
The data that the user sees in a cell is called the
EDITING
The process of modifying a presentation by adding and deleting slides or by changing the contents of individual slides.
=
All Excel formulas begin with which symbol?
EXPAND FORMULA BAR BUTTON
Increases the height of the formula bar to display lengthy cell content.
EXPAND HORIZONTAL SCROLL BAR BUTTON
Increases the width of the horizontal scroll bar.
FILL HANDLE
The small black square in the lower right corner of a selected cell is called the
FOOTER
Text displayed at the bottom of every slide or that prints at the bottom of a sheet of slide handouts or notes pages.
FORMATTING
The process of changing the appearance of the text, layout, and design of a slide.
FORMULA
An equation that performs mathematical calculations on values in a worksheet.
FORMULA BAR
The ________ allows the user to enter or edit the value or formula contained in the active cell.
FUNCTION
A predefined formula is called a
FUNCTION
A prewritten formula known as a(n) ________ looks at one or more values, performs an operation, and returns a value
GENERAL FORMAT
Whenever you type in cell will display, with the exception of trailing zeros to the right of the decimal point.
GEOTAGS
Tool used to identify places where photos were taken.
HEADER
Text that prints at the top of each sheet of slide handouts or notes pages.
HORIZONTAL WINDOW SPLIT BOX
Splits the worksheet into two horizontal views of the same worksheet.
INSERT WORKSHEET BUTTON
Identify the worksheets in a workbook and inserts an additional worksheet.
LABEL
A text value is also known as a label
LAYOUT
The arrangement of elements, such as title and subtitle texts, lists, pictures, tables, charts, shapes, and movies, on a slide.
LEFT ALIGNMENT
The text characters that’s typed align at the left edge of the cell & is also default for text values.
LEGEND
The ________ identifies patterns and colors assigned to categories in the chart.
LEGEND
On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the categories in the chart.
LETTERED COLUMN HEADIND
Indicate the column letter.
LIST LEVELS
An outline level in a presentation represented by a bullet symbol and identified in a slide by the indentation and the size of the text.
MERGE & CENTER
Excel’s ________ command creates one cell out of the selected cells and centers the contents within the new cell.
NAME BOX
The ________ displays the name of the selected cell, table, chart, or object.
NOTEBOOK
A collection of files organized by major divisions called sections.
NORMAL VEIW
Maximizes the number of cells visible on your screen and keeps the column letters and row numbers closer.
NORMAL VIEW
The PowerPoint view in which the window is divided into three panes–the Slide pane, the Slides/Outline pane, and the Notes pane.
NOTES PAGE
A printout that contains the slide image on the top half of the page and notes that you have created in the Notes pane on the lower half of the page.
NOTES PANE
Displays below the Slide pane and provides space for you to type notes regarding the active slide.
NUMBER FORMAT
A specific way in which Excel displays numbers
NUMBERED ROW HEADINGS
Indicate the row number
NUMBER VALUES
Numerical figures entered into a spreadsheet.
ONENOTE
Microsoft application with which you can create a digit notebook that gives you a single location where you can gather and organize information in the form of notes.
OPERATORS
Symbols with which you can specify the type of calculation you want to perform in a formula.
PAGE LAYOUT VIEW
You can see the edges of the paper of multiple pages, margins, and rulers
PICTURE ELEMENT
A point of light measured in dots and is also more popularly known as pixels
PIXEL
Picture element; point of light measured in dots per square inch.
PLACEHOLDER
A box on a slide with dotted or dashed borders that holds title and body text or other content such as charts, tables, and pictures.
POINT AND CLICK METHOD
Adding + at the insertion point and then clicking another cell in order to allow Excel to use previous formula to calculate cells.
RANGE
Two or more cells that Excel treats as a single unit is called a
RANGE FINDER
Formula , with two referenced cells displayed in color and bordered with the same color, displays in the cell.
ROTATION HANDLE
A green circle located above a selected picture with which you can rotate the selected image.
READING VIEW
Displays a presentation in a manner similar to a slide show but the taskbar, title bar, and status bar remain available in the presentation window.
RELATIVE CELL REFERENCE
A cell address used in a formula using a(n) ________ will be adjusted appropriately when the formula is copied to another cell.
ROUNDING
Procedure that determines which digit at the right of the number will be the last digit and then increases it by one if the next digit is between 5 and 9
ROW
Horizontal group of a cell.
ROW HEADING
Unique number that identifies each row.
SCALING
Shrinks the width (or height) of the printed worksheet to fit a maximum number of pages, and is convenient for printing pages
SECTIONS
Major divisions that organizes a collection of notebook files.
SELECT ALL BOX
Selects all the cells in a workbook.
SERIES
A group of items that come one after another in succession is called
SHEET TABS
Each worksheet is identified by the ________ found along the lower border of the Excel window
SHEET TAB SCROLLING BUTTONS
Displays sheet tabs that are not in view when there are numerous sheet tabs.
SPARKLINES
Tiny charts embedded in cells that show a visual trend alongside the data are called
SPREADSHEET
A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns. Another name for worksheet
SIZING HANDLES
Small circles and squares that indicate that a picture is selected.
SUM FUNCTION
Frequently used and is also has its own button in the editing group on the home tab.
SLIDE
A presentation page that can contain text, pictures, tables, charts, and other multimedia or graphic objects.
SLIDE PANE
Displays a large image of the active slide.
SLIDE HANDOUTS
Printed images of slides on a sheet of paper.
SLIDE SORTER VIEW
Displays thumbnails of all of the slides and apply formatting to multiple slides.
SLIDES/OUTLINE PANE
Displays either the presentation in the form of miniature images called thumbnails (Slides tab) or the presentation outline (Outline tab)
SLIDE TRANSITIONS
Motion effects that occur in Slide Show view when you move from one slide to the next during a presentation.
STATUS BAR
The current cell mode, the page number, and the view and zoom buttons are displayed on the?
STYLE
A collection of formatting options that can be applied to a picture, text, or object.
TAGS
Descriptive words that make photos and videos easier to organize and find
TEXT ALIGNMENT
The term that refers to the horizontal placement of text within a placeholder.
TEXT VALUE
Provides information about number values in other worksheet cells.
THEME
A set of unified design elements that provides a look for your presentation by applying colors, fonts, and effects.
THUMBNAILS
Miniature images
TITLE SLIDE
The first slide in a presentation, the purpose of which is to provide an introduction to the presentation topic.
UNDERLYING VALUE
The result of a formula is displayed in the active cell, and the ________ is displayed in the Formula Bar.
UNDERLYING VALUE
The Formula Bar displays the data known as the
UNDERLYING FORMULA
Formula that adds the values of numerous columns and display the the results in the next cell for that column.
VALUE
Anything that’s typed in a cell.
VALUES AXIS
On a line chart, the y-axis is also known as the
VERTICAL WINDOW SPLIT BOX
The ________ allow(s) the worksheet to be split into two vertical views of the same worksheet.
WINDOWS LIVE PHOTO GALLERY
Is a Windows Live Essential photo organizing tool to view, manage, share, and edit digital photos and videos.
WORKBOOK
An Excel document is called a
WORKSHEET
The individual pages of an Excel document are called.
another name for spreadsheet
WORKSHEET-LEVEL BUTTONS
Minimize, close, or restore the previous size of the displayed workbook.
X-AXIS
On a line chart, the area that identifies the categories of data is called the
Y-AXIS
On a line chart, the range of numbers for the data points are displayed on the
GOOD
Being of positive in nature.
