Excel

¡Supera tus tareas y exámenes ahora con Quizwiz!

Which tab/group combination contains the tool to have text appear at an angle within the cell?

Home/alignment

Sort

To arrange a list of words or numbers in ascending or descending order

File Tab

explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.

worksheet

A 'page' of an Excel workbook, accessible by the tabs at the bottom

Cell range

A group of worksheet cells, which can be adjacent or nonadjacent. (Example - A2:G19)

Border

A line or box that frames a cell.

Input message

A message that appears when the cell becomes active; can be used to specify the type of data the user should enter in that cell.

Excel table

A range of data you can treat as a distinct object in a worksheet.

Accounting Number Format button

Adds dollar signs and two decimal places to selected data

Fill Months

Auto Fill option that fills destination area with series of months

source area

Cell being copied

Merge & Center button

Centers cell contents over multiple cells

Conditional formatting

Changes formatting of a cell that meets a certain rule

chart

Conveys a visual representation of data

Text or numbers in a cell.

Data

Normal View

Default view in Excel

Formula Bar

Displays the contents stored in the active cell

Paste Options button

Immediately displays when you click the Paste button

Banded rows

In an Excel table, rows of alternating colors that make data easier to read.

font style

Indicates how the characters are emphasized

Drag-and-Drop method

Lets you move or copy data from one cell to another without using the Clipboard

Another name for a worksheet.

Spreadsheet

Data label

Text associated with a data value.

Primary sort field

The first sort field

Title Bar

The title bar text changes to display the name of the active document. Located at the top of the document

Chart Title

The title or name of chart usually identifying what data depicts, most often found at center top of chart area

zoom in

To magnify the appearance of a worksheet or chart

select

To make a cell active

Whenever you format data as a table, it will automatically include

filters

text

includes letters, numbers, symbols, and spaces

COUNTBLANK function

tallies the number of blank cells in a range

cell

the intersection of column and row

Cells a1:c5 in sheet 1 are created and named sales; how would a cell on sheet 2 reference the range?

(sales)

Unhide Row Tool

-ll-

What text qualifier tells Excel that the cell contains a formula

=

Zoom Slider

A bar in the lower-right corner of an Office program window that you can use to increase or decrease the size of the document on screen.

Selection box

A box surrounding an object that lets you move or resize the object.

Format painter

A button on the Ribbon that, when selected, copies a format from one cell range to another.

AutoSum

A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic - SUM, AVERAGE, COUNT, MIN or MAX

Financial function

A category of Excel functions that calculate values from loans and investments.

Date function

A category of Excel functions that store and calculate dates as numeric values, representing the number of days since January 1, 1900.

Combination chart

A chart that combines two or more chart types in a single graph.

Embedded chart

A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart.

Text data

A combination of letter, numbers and some symbols.

Link

A connection between the files that allows data to be transferred from one file to the other.

Theme

A designed collection of formatting options that include color, graphics, and background images.

Click and Type

A feature that allows you to double-click a blank area of a document to position the cursor in that location, with the appropriate paragraph alignment already in place.

Scrollbar

A feature that allows you to scroll up and down or left and right in order to view portions of your work area

Spelling checker

A feature that check the words in a document against the program's built-in dictionary and helps you avoid typographical errors.

Category field

A field used to group the values in a PivotTable.

Sort field

A field you use to order data.

Average

A function that identifies the numeric average of a set of values in a column or a row

Autosum

A function to add a set of values in a column or a row

PivotChart

A graphical representation of the data in a PivotTable in which you can interactively add, remove, filter, and refresh data fields.

Range

A group of worksheet cells, which can be adjacent or nonadjacent. (AKA a cell range)

Personal Macro Workbook

A hidden workbook named Personal. xlsb that opens

row

A horizontal arrangement of cells, organised by number

HTML (Hypertext Markup Language)

A language used to write Web pages.

Gridlines

A line that extends across the plot area indicating the location of tick marks on the chart's horizontal or vertical axis.

Border

A line that prints along the side of a table cell or around the outside of selected text.

Formula

A mathematical function that contains cell addresses and mathematical operators

Error alert

A message that appears if a user tries to enter a value in the cell that does

Chart sheet

A new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart.

Manual page break

A page break that you insert anywhere on a page.

Exploded pie chart

A pie chart with one slice moved away from the pie as if someone were taking the piece out of the pie.

Function

A predefined formula that performs calculations using specific values called arguments.

Plot area

A rectangular area containing a graphical representation of the values in the data series.

Cell Range

A rectangular group of adjacent cells

External reference

A reference to a cell or range in a worksheet in another workbook.

Total row

A row at the end of an Excel table that is used to calculate summary statistics for the columns in the table.

Status Bar

A row of information related to the current program. It is usually located at the bottom of a window. Not all windows will have one.

Chart Sheet

A separate sheet in a workbook that stores a chart.

Data validation

A set of rules that determine what users can enter in a specific cell or range.

Conditional format

A setting that applies formatting only when a cell's value meets a specified condition.

Adjacent range

A single rectangular block that includes a group of contiguous cells.

Fill handle

A small black square in the lower-right corner of a selected cell or cell range that you drag to copy the contents of the selected cells to adjacent cells.

Microsoft Excel 2007

A spreadsheet program you use to display, organize, and analyze numerical data.

Resizing handle

A square or dot on a selection box that lets you change and object's width and height.

Arithmetic operator

A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations.

Default template

A template that creates the blank Book1 workbook that opens when you start Excel, The default template contains no text or formulas, but it includes all the formatting available in every new workbook

Insert Function

A toolbar button that displays functions by category that will assist you in writing the formula.

Landscape orientation

A type of page orientation in which the page is wider than it is tall, so that text spans the widest part of the page.

Macro virus

A type of virus that uses a program's own macro programming language to distribute the virus.

Field name

A unique label that describes the contents of the data in a column, also called a column header.

Diagram

A visual representation of data to help readers better understand relationships among data

Defined name

A word or string of characters associated with a single cell or a range; also called a range name.

The correct way to display the range from A1 through C5 and formulas is

A1:C5

The correct syntax to make the contents of cell f23 always match the contents of cell d5 is to

Add the function "=d5" in cell f23

SUM function

Adds all the numbers in a range of cells

worksheet

Allows data easily to be summarized and charted

Cell Format

Allows someone to change a cell's appearance; alignment, font, border, patterns, etc. as well as its numerical type; number, text, currency, percentage, etc.

Collapse Arguments

Allows you to shrink the function dialogue box in order to choose cells for your function.

Workspace

An Excel file that saves information about all of the currently opened workbooks, such as their locations, window sizes, zoom magnifications, and other settings.

Table style

An Excel setting that applies styles to four table elements (header row, first column, last column, and totals row).

Relative Reference

An adjustable/changeable cell reference

Compound interest

An amount for which the interest paid is calculated on the principal and any previous interest payments that have been added to that principal.

Field

An attribute or characteristic of a person, place, or thing (such as a last name, address, city, or state); in Excel, each column represents a field.

Spreadsheet

An electronic file used to organize data and perform calculations

standard properties

Associated with all Microsoft Office files and include author, title, subject

insertion point

Blinking vertical line that indicates where next character typed will display

Auto Fill Options

Button that allows you to copy values with/without formatting or the format only

Anything typed into a cell.

Cell Content

Nonadjacent range

Cell range that is comprised of two or more separate adjacent ranges.

Radar Chart

Compares a collection of values through several data sets.

Criteria filter

Conditions you specify for a filter.

font

Defines appearance and shape of letters and numbers

relative reference

Each adjusted cell reference

The keyboard shortcut to define a cell as absolute is

F4

After reviewing tracked changes, they will no longer appear in your workbook.

False

Workbook

File consisting of one or more worksheets

underline

Format that underlines only the characters in a cell, not the entire cell

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

Formula

NOW function

Function that will display the current system date and time

The default format that Excel applies to numbers is the:

General Formet

Chart

Graph that provides a visual representation of the workbook data.

Select Column

Highlight an entire column

Select Row

Highlight an entire row

format

How you make a worksheet easier to read and understand

relative cell reference

Instructs Excel to adjust cell references as it copies to destination area

[Ctrl][Home]

Moves cell pointer to cell A1

ScreenTip

Onscreen text that appears when you position the mouse pointer over certain objects, such as the objects on the taskbar or a toolbar button. ScreenTips tell you the purpose or function of the object to which you are pointing.

Clicking on the zoom indicator will

Open the zoom dialog box

Arguments

Parameters added to a function that help in evaluating data, or performing calculations

Insert Row/Column

Placing a new, blank row or column in the spreadsheet.

destination area

Range of cells receiving the copy

Which toolbar contains most of the commands that you'll need in Excel 2013?

Ribbon

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

Sheet Tabs

Bubble Chart

Shows patterns between two or more sets of data. The size of the data marker is determined by the 3rd value.

Doughnut Chart

Shows relative values of different categories to the whole. Displast multiple sets of data.

fill handle

Small black square located in the lower-right corner of the active cell

Comparison operator

Symbol that indicates the relationship between two values.

Series values

The actual data displayed in a chart.

Cell reference

The address of a cell indicating its column and row location.

Principal

The amount of money being loaned.

Sheet tab

The area at the bottom of a worksheet that identifies the worksheet; clicking a sheet tab makes the worksheet active.

Cell reference

The column letter and the row number. Ex: B12

Find

The command to locate specific letters and numbers in a workbook.

Replace

The command to overwrite letters and numbers in a workbook with another entry.

Median

The middle value in data.

y-axis

The vertical line on a graph

The data that displays in the Formula Bar is referred to as the:

Underlying Value

splitting

Unmerging a cell

Letters

Used to identify columns in a spreadsheet

Numbers

Used to identify rows in a spreadsheet

fill color

a background color appearing behind the data in a cell

Column Heading

a column letter above the grid that identifies each column

workbook

a file containing related worksheets

AutoSum

a function that automatically adds selected cells

data series

a group of related data points

Series

a predictable list of sequential numbers, dates, times, or text

table array

a range containing a lookup table

Cell Label

ability to use name box to name a range of cells/cell

table

an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis

trendline

an object used to depict trends and forecast future data

subordinate

belonging to a lower or inferior class or rank; secondary

SUBTOTAL function

calculates an aggregate for values in a range or a database

surreptitious

clandestine; furtive, secretive

Text Color

color that the text appears in in a cell

If you want to put your data into alphabetical order by last name, you could use the

command.

MAX function

displays the highest value in a range

Page Break

displays the location of the different page breaks within the worksheet

autofill

enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells

Xlsx

file extension used for Microsoft Excel 2013 documents-identifying the type of program used to create it

conditional formatting

highlights or emphasizes cells that meet certain conditions

cell address

identifies a cell by column letter and row number

subtle

not immediately obvious; abstruse

vertical alignment

positions data between the top and bottom cell margins

=AVERAGE(range)

returns the average (mean) of a range

=SUM(range)

returns the sum total of (adds up) a range

stimulation

something that arouses or causes something to happen

column index number

the argument in a VLOOKUP function that identifies which lookup table column from which to return a value

filtering

the process of displaying only records that meet specific conditions

semi selection (pointing)

the process of using the mouse pointer to select cells while building a formula

data label

the value or name of a data point

synthesize

to join, to integrate

Ascending order

to sort data in A>Z order

Move Tool

used to place a selection in a new location

Column

vertical group of cells named with a letter

strenuous

very remanding; requiring great exertion

When making an absolute cell reference, you'll need to include at least one

$ (dollar sign)

point

1/72 of an inch

Pie chart

A chart in the shape of a circle (like a pie) that shows data values as percentage of the whole.

Line chart

A chart that compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.

Worksheet protection

A setting that limits users' ability to modify the worksheet's contents, structure, or formatting.

Custom template

A workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting.

A cell surrounded by a black border and ready to receive data is the:

Active Cell

active cell

Area in which you can enter data, surrounded by a heavy border

When you create a formula, you'll always start by typing the ________ sign.

B. = (equals)

horizontal split bar

Bar going across the middle of a split screen

Increase Indent

Button used to move the contents of a cell to the right two spaces

mixed cell reference

Cell with only one dollar sign before the column or row

Font size

Determined by point size, which is a unit of measurement equal approximately to 1/72 of an inch.

Orientation

Direction in which contents of page will print

Formula AutoComplete

Displays an alphabetical list of functions from which you can choose

Cell

Intersection of a column and a row

Dialog box launcher

Item of the Ribbon that opens a dialog box or task pane

absolute cell reference

Keeps the same cell reference as it copies a formula from one cell to another

Print area

Selected portion of a worksheet to be printed.

range

Series of two or more adjacent cells in a column or row

Descending order

Sorts text in reverse alphabetically from Z to A, numbers from largest to smallest, and dates from newest to oldest.

Sheets Tab

Tabs that appear at the bottom of the workbook window,which displays the name of each worksheet

Drilling Technique

Taking the content from one sheet and pasting it to multiple sheets at one time.

Data

Text or numbers in a cell

Drag and drop

To move an item (either text or a graphic) by selecting it and dragging it with the mouse.

Clear

To remove

Delete

To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook.

Descending order

To sort data in Z>A order

gridline

a horiztonal or vertical line that extends from the horizontal or vertical axis through the plot area

legend

a key that identifies color, gradient, picture, texture, or pattern fill assigned to each series in a chart

MEDIAN function

calculates the midpoint value in a set of values

Resize

change the size of

value axis

displays incremental values to identify the values of the data series

Status Bar

displays information about the current document

Name Box

displays the active cell address

formula bar

displays the content in the active cell

TODAY function

displays the current date

NOW function

displays the current date and time

sheet tab

displays the name of a worksheet within a workbook

name box

identifies the address of the current cell

HLOOKUP function

looks up a value in a horiztonal lookup table where the first row contains the values to compare with the lookup table

pie chart

shows each data point in proportion to the whole data series as a slice in a circular pie

bubble chart

shows relationships among three values by using bubbles

stock chart

shows the high, low, and close prices for individual stocks over time

Equal Sign

Used to indicate the start a formula

column chart

displays data comparisons vertically in a chart

surface chart

displays trends using two dimensions on a continuous curve

area chart

emphasizes magnitude of changes over time by filling in the space between the lines with a color

wrap text

enables a label to appear on multiple lines within the current cell

sparkline chart

Shows trends and variations in a range of data within a single cell

The steps to build a function in a cell are

Click on formula tab, chose insert function, enter required elements

Formula prefix

Equal sign preceding a formula

Worksheet

the workspace made up of columns and rows where you enter data to create an electronic spreadsheet

Mixed reference

Cell reference that contains both relative and absolute references, for example B$4.

To create a new worksheet

Click the Insert Worksheet tab, or Right-click on a worksheet tab and select Insert

A vertical group of cells in a worksheet

Column

Surface Chart

Compares three sets of values in a 3-D chart.

Area Chart

Compares values from different categories. Similar to a line chart except the areas under the line contain a fill color.

When printing pages, to keep the top 2 rows of data on every page

Page layout tab, print titles, and select rows to repeat

Ctrl

The key presses to select non adjacent cells of data to create a chart

Cell Address

The name of a cell; contains both the column and row reference

Series name

The name of the data series.

Scroll Bars

The navigation buttons are located on the bottom of the vertical and horizontal scroll bar to move up, down, left or right in the typing area

Portrait

The orientation of a document where the page is taller than it is wide.

Landscape

The orientation of a document where the width is greater than the height.

cell

The place data is entered; the intersection between a row and a column

Freeze

The process of keeping rows and/or columns you select visible in the workbook window as you scroll the worksheet.

Sort

The process of rearranging data in a certain order, such as ascending or descending.

Filter

The process of temporarily hiding records that do not meet the specific criteria.

Scale (n)

The range of values that spans along an axis.

Active cell

The selected cell in the worksheet; indicated with a dark border.

Custom list

The sequence you specify to sort data.

Alignment

When data is entered into a cell, the default alignment is labels to the left and values to the right

PMT function

calculates the periodic payment for a loan with a fixed interest rate and fixed term

SUM function

calculates the total of values contained in two or more cells

Absolute Reference

cell reference that points to a specific cell and does not change when copied ($B$4)

radar chart

compares aggregate values of three or more variables represented on axes starting from the same point

multiple data series

compares two or more sets of data in one chart

bar chart

compares values across categories using horiztontal bars

single data series

compares values for one set of data

superficial

concerned with or comprehending only what is apparent or obvious shallow

plot area

contains a graphical representation of values in a data series

Header

content appearing at the top of each printed page

table style

controls the fill color of the header row, columns, and records in a table

order of precedence

controls the sequence in which Excel performs arithmetic operations

print area

defines the range of data to print

Orientation

describes the direction of the page or the paper you will print on (landscape or portrait)

IIF function

evaluates a condition and returns one value if the condition is true and another value if the condition is false

To continue a series of dates, you can click and drag the

fill handle

Freeze Panes

allows the user to select specific rows or columns that remain visible when scrolling in the worksheet

Conditional formatting

allows you to automatically apply formatting to cells based on their values

field

an individual piece of data, such as a last name

formula autocomplete

displays a list of functions and defined names as you enter a function

stringent

imposing rigorous standards of performance; severe

Conditions Statements

in a formula that can be evaluated as true or false, and then return an appropriate value if true, and another value if false.

sizing handle

indicated by faint dots on the outside border of the selected chart, enables you to adjust the size of the chart

relative cell reference

indicates a cell's relative location from the cell containing the formula; changes when the formula is copied

To select the contents of the entire worksheet

Click on the heading box above row 1 and left of column A, OR Ctrl + A

font color

Defines the color of characters

enter

Key that can be used in place of the Paste button

HOME

Key that selects the cell at the beginning of a row with the active cell

Ascending order

Sorts text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

Sparklines

Argument

Specifies the numbers, text, or cell references used by a function to calculate a value.

font size

Specifies the size of characters

Report filter

Filters the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.

number sign

Formula error messages always begin with this

nested IF

IF function within an IF function

Range reference

Identification of a cell range using the upper-left and lower-right corners of the rectangular selection of cells.

Rows

Identified by numbers on the left side of the spreadsheet. (Horizontal)

Active Cell

Highlighted worksheet cell that is ready for data entry

Insert mode

Excel inserts the character and moves all characters to the right

Overtype mode

Excel replaces the character to the right of the insertion point

name box

Next to the formula bar, the place a cell's name or cell reference is specified

formula bar

Next to the name box, a cell's data or formula is displayed here when you select the cell

Constant values consisting of only numbers.

Number Values

volatile function

Number that the function returns is not constant

Horizontal (category) axis

On the horizontal axis, or x-axis, are the data series' category values, or x values.

Name box

Part of the Excel program window that displays the active cell address

When copying and pasting data, which paste option should be used to insert the data but not the original style

Paste special, paste

You can use the

Print Selection option to print a specific range in a worksheet.

If you are printing a worksheet and want the headings to appear on every page, click the

Print Titles command.

Graph

Provides a visual representation of the workbook data.

Quick Access Toolbar

Provides access to commonly used tasks like saving or printing a document, undo,redo, and new

Major tick mark

The indication of the major units of increment on the x- or y-axis.

Minor tick mark

The indication of the minor units of increment on the x- or y-axis.

Cell

The intersection of a column or row in a worksheet.

Cell

The intersection of a row and a column

Simple interest

The type of interest in which the interest paid is equal to a percentage of principal for each period that the money had been lent.

Point

The unit used to measure the size of the characters in a font.

Points

The unit used to measure the size of the characters in a font.

Column

The vertical reference in a spreadsheet

x axis

a horiztonal line that borders the plot area to provide a frame of reference for measurement

input area

a range of cells containing values for variables used in formulas

3-D chart

adds a third dimension to each data series, creating a distorted perspective of the data

A predesigned workbook you can use to create a new project quickly is called a(n)

template

Fill Color

the background of the cell

active cell

the current cell, indicated by a dark border

column width

the horiztonal measurement of a column

breakpoint

the lowest value for a series or specific category of the lookup table

Fill Handle

this is the name of the small black square that displays in the bottom right corner of the active cell

surpass

to be or go beyond, as in degree or quality; exceed

stigmatized

to characterize or brand as disgraceful or ignominious

Select

to choose or highlight a row, column, cell or range

stymie

to hinder or obstruct

You can use Document Inspector

to remove personal information from a workbook.

Bar chart

A column chart turned on its side, so each length is based on its value.

Validation rule

A statement that defines criteria for the data that can be stored in a cell or range.

Formula

Equations with symbols for math operations. Example =B6+B7+B8+B9

What character can be placed in front of data to force excel to treat it as text?

'

Record

A collection of related fields that are grouped together, in Excel, each row represents a record.

Automatic color

A color option that uses the Windows default text and background color values.

Worksheet

A blank page in a spreadsheet file

XY scatter chart

A chart that shows the patterns or relationship between two or more sets of values.

Workbook

A file containing multiple spreadsheets

Workbook

A file that contains one or more spreadsheets

Theme font

A font associated with a particular design theme and used for headings and body text.

Sans serif font

A font that does not have the small horizontal lines (called serifs) at the tops and bottoms of letters.

Serif font

A font that includes small horizontal lines (called serifs) at the tops and bottoms of letters.

Hyperlink

A link in a file, such as a workbook, to information within that file or another file that, when clicked, switches to the file referenced by the hyperlink.

Editing mode

A mode in which you can edit part of an entry rather than the entire contents of a cell.

Number data

A numerical value that can be used in a mathematical calculation.

Cursor

A representation on the screen of the mouse pointer location

Style

A saved collection of formatting options - number formats, text alignment, font size and colors, borders, and background fills - that can be applied to cells in a worksheet.

Font

A set of characters that uses the same typeface, style, and size.

Order of precedence

A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second and so forth.

Comment

A text box that is attached to a specific cell in a worksheet in which you can enter notes.

Mini toolbar

A tool bar that appears next to the pointer whenever you select text and contains buttons for the most commonly used formatting commands, such as font, font size, styles, color, alignment, and indents that may appear in different groups or tabs on the Ribbon.

fill

A tool in Excel that allows you to copy down or across from an existing cell to enter formulas or data into other cells

Spreadsheet

A tool used in business for budgeting, inventory management, and decision making fir analyzing and reporting information.

View short-cuts toolbar

A toolbar located at the right end of the status bar that contains tools for switching between views of document content and changes the display magnification

Quick Access Toolbar

A toolbar located in the upper-left corner of the program window, which displays the Save, Undo, and Repeat buttons by default but can be customized to include any command.

Portrait orientation

A type of page orientation in which the page is taller than it is wide (like a typical business letter.)

column

A vertical arrangement of cells, organised by letter

Template

A workbook that you can open with labels, formats, and formulas already built into it from which you create new workbooks.

Planning analysis sheet

A worksheet that includes questions to help you define the purpose and objective of a workbook.

Expand Arguments

Allows you to expand the function dialogue box in order to adjust the arguments in your function.

PivotTable

An interactive table that enables you to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis.

text

Any set of characters containing letters, hyphens, or spaces

Formula Bar

Appears directly below the toolbar in the worksheet; displays a formula when the cell of a worksheet contains a calculated value.

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is

Auto Fill

Copy Cells

Auto Fill option that fills destination area but does not create a series

Fill Formatting Only

Auto Fill option that fills destination area using format of source area

Fill Without Formatting

Auto Fill option that fills destination area with contents without formatting

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

AutoFit

vertical split bar

Bar going up and down the middle of a split screen

formula

Beginning with an 'equals sign', a calculation or function that can be entered into a cell

splitting

Breaking the Excel window into four panes

Copy button

Button used to copy contents and format of a source area to the Office Clipboard

Decrease Indent

Button used to move the contents of a cell to the left two spaces

Paste button

Button used to paste a copy of the Office Clipboard contents

The intersection of a column and a row.

Cell

Another name for a cell reference.

Cell Address

merging cells

Creating a single cell by combining two or more cells

What answer would Excel give if you typed =3+6*2 into a cell?

D. 15

Fill Series

Default Auto Fill option that Excel uses to fill an area

General number format

Default number format that automatically displays number, for the most part, the same way you enter them.

Fill color list arrow

Displays background color options for a cell

Non-theme font

In Excel, a font that can be used no matter what theme the workbook has.

Leader line

In a pie chart, a line that connects a data label outside of a pie slice to its corresponding label when space limitations force Excel to place a data label far from its slice.

Fill handle

Lets you copy cell contents or continue a series of data into a range of selected cells

Page break

Location in a worksheet that determines where a new page begins.

Active cell

Location in the worksheet that will displays typed data that will be affected by a command

* (Shift 8)

Multiplication symbol used in an Excel formula

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

Name Box

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

Operators

A feature 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 is called:

Quick Analysis Tool

sensitivity analysis

Scrutinizing the impact of changing values referenced by a formula in a cell

Margo would like to have the contents of cell F12 turn red if the value falls below 12, what steps should she take?

Select Cell F12, choose home tab/cells/conditional formatting

What is the sequence to use to change the format of data in a cell

Select cell, choose home tab, cells grouping, format

format symbol

Symbols that assign a format to numbers as they are entered

Chart title

Term that appears above the plot area and describes the contents of the plot area and the data series.

Footer

Text that appears at the bottom of every page in a document or at the bottom of every slide in a presentation.

Header

Text that appears at the top of every page in a document or every slide in a presentation.

bold

Text that has a darker appearance than normal text

Label

Text, symbols, dates, or numbers not used in calculations

Theme color

The 12 colors that belong to a workbook's theme.

Data series

The Chart Wizard organizes data sources into a collection, where each data series is a range of data values that is plotted as a unit on the chart.

workbook

The Excel document that holds all the worksheets

Perspective

The illusion that some parts of the 3-D chart are farther away from you than others.

Primary value axis

The axis in a column chart that displays the primary values associated with the heights of each column.

Secondary value axis

The axis in a column chart that displays the secondary values associated with the heights of each column.

Formula bar

The bar located above the workbook window in which the contents of a cell are displayed.

Name box

The box located on the far left of the Formula bar in which the cell reference to the active cell is also displayed.

Name Box

The box that contains the cell address

Excel Help Button

The button located at the right end of the ribbon and labeled with a question mark (?), that provides access to the Excel Help system

Cell Reference

The column letter and the row number. Example: B12

Workbook

The file in which Excel stores an electronic spreadsheet.

PMT function

The financial function to calculate the amount paid into an investment or loan during each payment period.

When a cell that contains a function is selected the formula bar will display

The formula

Data marker

The graphical representation of the values in the data series of a chart, including items such as each column in a column chart, the pie slices in the pie charts, and the points used in XY (scatter) charts.

Category values

The group or category to which a series value belongs.

x-axis

The horizontal line on a graph

Row

The horizontal reference in a spreadsheet

Mode

The most common value in data.

Header row

The row of field names.

Secondary sort field

The second sort field.

arithmetic operations

The simple mathematical functions: plus, minus, multiplied by, and divided by

Margin

The space between the page content and the edges of the page.

Source file

The workbook that contains the data when two files are linked.

Destination file

The workbook that receives the data when two files are linked; sometimes referred to as the dependent file.

Active workbook

The workbook you are currently using.

Active sheet

The worksheet currently displayed in the workbook window.

Sort

To arrange data in alphabetical or numerical order.

Formatting

To change the appearance, not the data, of your workbook.

Truncate

To cut off, or hide, the part of an entry that does not fit in a cell.

goal seeking

To determine the value of a cell on which the formula depends

Autofit

To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry.

Autofit

To make a column or row as it needs to be to fit the data contained in the cell, Determines the best width for a column or the best height for a row, based on its contents.

Merge and Center

To make one cell out of several highlighted cells and then center the content of that cell

Cut

To remove data from a cell and place it on the Office Clipboard.

zoom out

To shrink the appearance of a worksheet or chart

Chart

a graphic representation of values used to identify trends and contrasts in data

formula

a combination of cell references, operators, values, and/or functions used to perform a calculation

record

a complete set of data for an entity

spreadsheet program

a computer application used to create a modify spreadsheets

category label

a text that describes a collection of data points in a chart

Slicers

are basically just filters

mixed cell reference

contains a relative and an absolute cell reference; the absolute part does not change but the relative part does change

nonadjacent range

contains multiple ranges of cells

chart area

contains the entire chart and all of its elements

Footer

content appearing at the bottom of each printed page

MIN function

displays the lowest value in a range

absolute cell reference

indicates a cell's specific location; does not change when the formula is copied

How does a user define a cell name (A1) as an absolute reference

$A$1

How do you change the order of the worksheets in a workbook?

Click on a worksheet and drag-and-drop it to the position that you want it in

Tabs

Demonstrate the access to the various groups of commands on the ribbons, Excel includes 8 tabs on the Ribbon.

When the data in a workbook is larger than can be printed on a single page, excel prints:

Depends on the user preference

Row

Horizontal groups of cells named with a number

What layout is similar to the print review

Page layout

A mouse pointer shaped like a hand when on a cell means

You can grab and move the cell contents

Function

special formulas that do not use operators to calculate results. A shortcut formula Ex: sum(B6:B9)

logical test

an expression that evaluates true or false

argument

an input, such as a cell reference or value, that i neededto complete a function

Page layout view

In Excel, a view that shows how the worksheet will be laid out on the pages sent to the printer.

Column heading

In Excel, the part of the worksheet that identifies each column by a different letter.

sparkline

a miniature chart contained in a single cell

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

Fill Handle

Formula view

Excel view in which cell formulas are displayed rather than the values returned by the formulas.

lookup table

a range that contains data for the basis of the lookup and data to be retreived

range

a rectangular group of cells

format painter

Used to quickly copy a cell's format to another cell

syntax

a set of rules that governs the structure and components for entering a function properly

fill handle

a small black square at the bottom-right corner of a cell

function screen tip

a small popup description that displays the arguments for a function as you enter it

structured reference

a tag or use of a table element as a reference in a formula

y axis

a vertical line that borders the plot area to provide a frame of reference for measurement

To open a new Excel workbook

Click on file (Backstage) tab, select new, choose blank workbook

To select the contents of columns A through C

Click on the column header for A and drag to the column header for C

The steps to create a new file based on a template are

Double-click a template file, and Open Excel, click File, click New, select template to use

Mary has three worksheets that she would like to label as summary, detail and look up. She should

Double-click each tab and type over the highlighted text, or Right-click each one and choose rename, then enter the appropriate name

When copying cells that have formulas with relative references, the formula will work

If the data for the new location is in the same relative location

Ctrl+c

Keyboard shortcut for copy

Ctrl+v

Keyboard shortcut for paste

Ranges can be defined by

Naming the upper left cell : lower right cell

What group of tools on the home tab allow a user to switch the format of numbers

Number

Landscape and portrait are

Orientations

Cell address

The intersection of a row and column

function

a predefined formular that performs a calculation

output area

a range of cells containing results based on manipulating the variables

worksheet

a spread sheet that contains formulas, functions, values, text, and visual aids

chart

a visual representation of numerical data

If you wanted to filter data to exclude a certain word or phrase, you could use a(n)

advanced text filter

Goal Seek

allows you to work backward to find the desired input value

spreadsheet

an electronic file that containsa grid of columns and rows containing related data

Workbook

an excel file with one or more worksheets

total row

appears as the last row of a table to display summary statistics, such as a sum

Row

appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window

Column

appears vertically in a worksheet and is identified by letters at the top of the worksheet window

sorting

arranges records in a table by the value in fields within a table

stilted

artificially formal; contrived

subjective

based on or influenced by personal feelings, tastes, or opinions.

AVERAGE function

calculates the arithmetic mean or average of the values contained in two or more cells

stacked column chart

places stacks of data in segments on top of each other in one coloumn, with each category in the data series represented by a different color

horizontal alignment

positions data between the right and left cell margins

pv

present value of the loan

category axis

provides descriptive group names for subdividing the data series

In order to share a workbook online, you must first

save it to your OneDrive

exploded pie chart

separates one or more pie slices from the rest of the pie chart

XY scatter chart

shows a relationship between two variables

doughnut chart

shows values as percentages of the whole but may contain more than one data series

supplement

something added to complete a thing, make up for a deficiency, or extend or strengthen the whole

100% stacked column chart

stacks data in one column per category, with each column having the same height (100%)

COUNTA function

tallies the number of cells in a range that are not empty

COUNT function

tallies the numbers of cells in a range that contain values

Pie Chart

A chart used to visually display the parts of a whole as percentages, a circular chart divided into triangular areas proportional to the percentages of the whole

relative cell reference

A code that points to a particular cell, which changes depending where that code is entered; for example, it may point to a cell that is one column to the left and one row above the cell where the formula is entered

absolute cell reference

A code that points to a unique cell, independently of where that code is entered; dollar signs are used to 'lock' the column and row

Group

A collection of buttons for related commands on the Ribbon.

A range of cells is

A collection of individual cells

Worksheet group

A collection of two or more selected worksheets in which everything you do to the active worksheet also affects the other worksheets in the group.

Standard color

A color that is always available regardless of the workbook's theme.

Custom color

A color you specify as a mixture of red, blue, and green color values, which makes available 16.7 million custom colors - more colors than the human eye can distinguish.

Pixel

A colored dot that, when combined with other pixels, forms a picture or graphics display; stands for picture element.

A small red triangle in a cell indicates

A comment associated to the cell

Data bar

A horizontal bar added to the background of a cell whose length reflects the cell's value.

IF function

A logical function that returns one value if the statement is true and returns a different value if the statement is false.

Formula

A mathematical expression that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression that describes the calculation to be done.

Operator

A mathematical symbol that you use to combine values and then return a single value.

Screen Tip

A note that appears on the screen to provide information about a button, tracked change, or comment, or to display footnote or endnote. Also displays the text that will appear if you choose to insert a date or AutoText entry.

Value

A number entered into a spreadsheet cell that will be used for calculations

Thumbnail

A small representation of an item, such as an image, a page of content, or a set of formatting, obtained by scaling a snapshot of it. They are typically used to provide visual identifiers for related items.

Template

A spreadsheet already set up for a specific purpose

Excel application

A spreadsheet written or tailored to meet the user's specific needs; typically includes reports and charts, a data entry area, a custom interface, as well as instructions and documentation.

Spreadsheet

A program that allows you to use rows and columns of data to manage, predict, and present information.

Macro

A series of stored commands that can be run whenever you need to perform that task.

Locked property

A setting that determines whether changes can be made to a cell.

Workbook protection

A setting that limits users' ability to make changes to the

Column chart

A type of chart that displays values in different categories as columns; the height of each column is based on its value.

Column header

A unique label that describes the contents of the data in a column.

Ribbon

A user interface design that organizes commands into logical groups, which appear on separate tabs. The Ribbon includes tabs that have access to various groups and commands according to the task being performed.

Date data

A value in a recognized date format.

Time data

A value in a recognized time format.

Accent

A variation on an Excel theme color.

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Absolute

Insert Tab

Allows you to add various items into a document; such as pages, tables, charts, illustrations, links to Internet sites or other documents, headers, footers,text and symbols

AutoFill

An Excel tool that enables you to copy the contents of the selected cells by dragging the fill handle over another adjacent cell or range of cells rather than using the copy and past commands.

Live preview

An Office feature that shows the results you would achieve in your file, such as the effects of formatting options on a document's appearance, if you click the option to which you are pointing.

What-if analysis

An approach using an electronic spreadsheet in which you change one or more of the values in the worksheet and then examine the recalculated values to determine the effect of the change.

Ribbon

An area at the top of the Excel 2010 window where almost all the capabilities of Word are available to help you use the program efficiently.

Optional argument

An argument that is not necessary for the function to calculate a value (if an optional argument is not included, Excel assumes a default value for it.)

Digital signature

An electronic version of a signature that provides a way to authenticate a workbook; also called a digital certificate.

Column Chart

An image used to compare different groups of data to each other through the use of vertical columns of different lengths

Spelling button

Checks for apparent misspellings in a worksheet

[Delete]:

Clears the contents of selected cells

Data source

Any file that contains the data you want to retrieve.

Cancel box

Cancels an entry by tapping or clicking

The area along the bottom of a chart that identifies the categories of data is the:

Category Axis

Absolute reference

Cell reference that points to a specific cell and does not change when copied; appears with a dollar sign ($) before each column and row designation.

The graphic representation of data in a worksheet.

Chart

surface chart

Chart used to compare data from three columns in a three-dimensional manner

line chart

Chart used to illustrate changes in data over time

pie chart

Chart used to show the contribution of each piece of data to the whole

Numbers, text, dates, or times of day that you type into a cell.

Constant Value

When using fill down, which is NOT an option

Copy without formatting

AutoCorrect feature

Corrects common mistakes when you complete a text entry in a cell

According to the order of operations, which operation is performed first in the following equation: =D1/5+1*D3/(D3-D2)?

D3-D2

document properties

Details about a file such as the project author, title, and subject

Data definition table

Documentation that lists the fields to be maintained for each record and a description of the information each field will include.

Worksheet

Each workbook is made up of individual worksheets, or sheets, containing formulas, functions, values, text, and graphics.

When a chart is selected, what tabs will appear in the chart tools contextual menu

Format, layout, design

An element in the Excel window that displays the value or formula contained in the active cell is the:

Formula Bar

Tom would like to show only some rows in his worksheet and would like to choose the row using the data in a column

He should filter the data using the criteria

Which options are not available in the page layout tools

Header and Footer

Frank would like to fill a list with the days of the week but wants to leave a blank column between each day. He should

Highlight the first day and a blank cell to the right, use the fill handle to the right

Page break preview

In Excel, a view that displays the worksheet as it is divided up into pages. Anything outside of the print area is grayed out.

Print title

In Excel, information that prints on each page.

Row heading

In Excel, the part of a worksheet that identifies each row by a different number.

Module

In VBA, a collection of sub procedures.

Sub procedure

In VBA, all of the actions performed in a macro.

Value field

In a PivotTable, a field that contains summary data.

Relative reference

In a formula, the address of a cell range based on the relative position of the cell that contains the formula and the cell the formula refers to. If you copy the formula, the relative reference is adjusted to reflect the new location of the cell containing the formula.

requirements document

Includes a needs statement, source of data, and summary of calculations

Cell

Individual locations on a spreadsheet

hard copy

Information that exists on a physical medium such as paper

PAGE DOWN

Key that selects the cell down one worksheet window from the active cell

PAGE UP

Key that selects the cell up one worksheet window from the active cell

Legend

Labels that identify the different data series in a chart.

automatically updated properties

Properties that include system file properties

A feature that outlines cells in color to indicate which cells are used in a formula is called:

Range Finder

F4 key

Rather than retyping a formula, you can switch reference in editing mode by selecting the cell reference and pressing the F4 key.

3-D Reference

Refers to the same cell or range in multiple worksheets in the same workbook. The reference specifies not only the range of rows and columns, but also the range of worksheet names in which the cells appear. (Example: WorksheetRange!CellRange )

To insert a comment into a cell

Right-click in the cell select insert comment

What tab/group combination is used to change the type of chart used

Right-click on the chart and select change chart type, OR Chart tool tab

To change the color of a worksheet tab

Right-click on the tab and choose tab color, or Click on the worksheet tab, click Home, click Format, choose Tab Color

A horizontal group of cells in a worksheet

Row

Which function would you use to add the values of several cells?

SUM

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

Select All Box

To move the contents of cell B4 to F10

Select B4, roll over the edge of the cell and drag the cell to F10, OR Select B4, right-click and select Cut, click on F10, right-click Paste

Frank would like to move the contents of column F in between the A and B columns he should

Select column F, choose cut, click on the column header for B and choose insert cut cells

Creating a chart follows these basic steps

Select data, choose chart, adjust format

Juan is creating a worksheet that has each week in the month of January in cells B2-B5. How can he put the Label "January" above the cells and center it

Select the cells above the weeks choose merge and center

To resize a column to fit the data automatically

Select the column and choose home/cells/ format autofit, OR Go between the column to be sized and the next column and double click

Julia would like to rearrange her data so that it is in order by the first column

Select the data, choose sort, select first column

To reference the data from cell b5 on sheet 1, a different sheet in the same workbook the syntax is

Sheet1!(b5)

Stock Chart

Shows stock market data like highs, lows, opening price and closing price.

Name Box

Shows the address of the active cell Ex: A1

date stamp

Shows the date a workbook was created or the time period it represents

Insertion Point

Shows various forms based on the function being performed and the location to which the mouse is pointing. When you are inserting text, it is an I-beam.

The fill data handle looks like

Small black plus sign

Merge Cells

Takes two or more cells and combines them into one.

File Tab

The File Tab explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.

Active Cell

The cell ready for data entry

Chart area

The entire chart and all the elements contained in the chart or graph, such as the title and legend.

AutoComplete

The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed.

Fill handle

The small black square in the bottom right corner of as cell that allows you to fill adjacent cells with a repeated formula

Typeface

The specific design of a set of printed characters, including letters, numbers, punctuation marks, and symbols.

Normal view

The view that renders the workbook and worksheets for the computer screen.

Vertical (value) axis

The y-axis where, for example, data values, such as sales values, are plotted.

When the mouse pointer turns into 2 parallel lines with arrows in opposite directions it means:

There is a hidden row/column

Scale (v)

To change the size of a graphic to make it fit into a document.

Merge

To combine the main document with a data source.

Rename sheet

To rename a sheet in a workbook. Right click the sheet tab ,click rename.

Refresh

To update

Text string

Two or more text characters.

Custom margins

Used to center the spreadsheet both horizontally and vertically on a printed page.

Legend

Used to identify the format of the data marker used for each series in a chart. Used if the chart contains more than one data series.

Insert Function dialog box

Used to search for a particular function.

IF function

Used when you want to assign a value to a cell based on a logical test

drag and drop

Using touch or the mouse to move or copy cells

Another name for a constant value.

Value

Data label

Value or name assigned to individual data points.

assumptions

Values in cells that you can change to determine new values for formulas

Font style

Various ways that fonts can be displayed, such as regular, italic, bold, or bold italic; a special attribute applied to the characters of a font.

Workbook window

Window in which a workbook is displayed; also called worksheet window.

An Excel file that contains one or more worksheets

Workbook

On startup, Excel displays a new blank:

Workbook

What is the correct hierarchy?

Workbook, worksheet, cell

Filter

a condition that data must meet to be included in a selection - a way of limiting data in a list

color scale

a conditional format that displays a particular color based on the relative value of a cell's contents to other selected cells

icon set

a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range

nested function

a function that contains another function embedded inside one or more of its arguments

chart title

a label that describes a chart

axis title

a label that describes either the category axis or the value axis

Border

a line that indicates a boundary of a cell or range

border

a line that surrounds a cell or range

Row Heading

a number at the far-left side of a row that can be clicked to select the entire row of cells

value

a number that represents a quantity or amount

data point

a numerical value that describes a single value on a chart

The Subtotal command will automatically

group, outline, and summarize your data.

clustered column chart

groups or clusters similar data in columns to compare data across categories

page break

indicates where data starts on a new printed page

synergy

interaction of two or more agents or forces so that their combined effect is greater than any individual part

symbiosis

interdependent relationship

lookup value

is a reference to a cell containing a value to look up

freezing

keeps rows and/or columns visible as your scroll through a sheet

When reading a chart, you should refer to the

legend to see which color is used to represent each data series.

Freezing panes allows you to

lock row(s) or column(s) in place

VLOOKUP function

looks up a value in a vertical lookup table and returns a related result from the lookup table

strident

loud, harsh, grating, or shrill; discordant

supine

lying on the back or having the face upward

Grouping worksheets allows you to

make changes to multiple worksheets at once

To combine several adjacent cells into one large cell, you will need to

merge cells

If you want to display a date in a certain way (such as Friday, March 1, 2013), you can adjust the

number format

range

numbers and/or cell references, separated by commas (discrete) or by a colon (continuous)

circular reference

occurs when a formula directly or indirectly refers to itself

suspension of disbelief

temporarily and willingly setting aside our beliefs about reality in order to enjoy a story

rate

the periodic interest rate (ex. monthly)

Cell Alignment

the position in which text is placed within a cell

print order

the sequence in which pages print

nper

the total number of payment periods

row height

the vertical measurement of a row

Selection Tool

thick white cross

succumb

to submit to an overpowering force or yield to an overwhelming desire; give up or give in

substantiate

to support with proof or evidence; verify

Cell Value

what is typed into a cell-contained with in

range name

word or string of characters that represents one or more cells

One advantage of sparklines is that

you can keep them very close to their source data


Conjuntos de estudio relacionados

L'écologie 2.5 - les gestes écologiques

View Set

Chapter 53: Assessment and Management of Patients with Male Reproductive Disorders

View Set

From Inquiry to Academic Writing, Ch 3, "From Writing Summaries and Paraphrases to Writing Yourself Into Academic Conversations"

View Set

Lecture: 6 Social Stratification and Global Stratification

View Set

MedSurg Exam 1: Perioperative Care, GI, Diabetes

View Set