92 terms

A(n) ______ is a predefined formula that performs calculations by using specific values in a particular order or structure.

Function

The _______ function is a predefined formula that adds all the numbers in a selected range of cells.

SUM

The ____ function adds a group of values, and then divides the result by the number of values in the group.

Average

The _____ function finds the middle value that has as many values above it in the group as are below it.

Median

The ____ function is a statistical function that counts the number of cells within a range that meet the given condition.

Countif

When you _____ a formula, the cell references within the formula do not change, no matter what type of cell reference you use.

Move

The _____ function retrieves the date and time from your computer's calendar and clock, and inserts the information into the selected cell.

Now

The ______ command enables you to select one or more rows or columns and then lock them into place.

Freeze Panes

The _______ command enables you to specify rows and columns to repeat on each printed page.

Print Titles

The _______ command enables you to stretch or shrink the width, height, or both, of the printed output to fit a maximum number of pages.

Scale to fit

__________ identify each worksheet in a workbook and are located along the lower eft edge of the workbook window.

Sheet tabs

When you filter a table, only a portion of the data displays based on matching a specific value.

True

When you paste cells, the Cell Styles gallery displays, which includes Live Preview to preview the Paste formatting that you want.

False

Arranging all the data in a specific order- in ascending or descending order- is referred to as filtering a table.

False

Operators are the symbols with which you specify the type of calculation that you want to perform on the elements of a formula.

True

A summary sheet is a worksheet where totals from other worksheets are displayed and summarized.

True

The paste area refers to the target destination for data that has been cut or copied using the Office Clipboard.

True

Statistical functions test for specific conditions.

False

Clearing contents of a cell deletes the value or formula typed there, but it does not clear formatting applied to a cell.

True

You can sort tables- display only a portion of the data based on matching a specific value- to show only the data that meets the criteria that you specify.

False

You can filter tables- arrange all the data in a specific order- in ascending or descending order.

False

The statistical MAX function determines the smallest value in a selected range of values.

False

Specified conditions

Criteria

Changes the appearance of a cell based on a condition

conditional format

Provides a visual cue to the reader about the value of a cell relative to other cells

data bar

When the information inserted from a function will not remain as entered

volatile

greater than

>

equal to

=

less than

<

not equal to

<>

On startup, Excel displays a new blank ______.

Workbook

A time saving technique for entering data is to first ______.

select a range of cells

The Formula Bar displays:

the value or formula contained in the active cell.

A text value or _______ usually provides information about number values in other worksheet cells.

label

Text or numbers in a cell are referred to as ________.

data

The default number format is the _______ format.

General

All formulas begin with the _____ sign.

=

The ______ command joins selected cells into one larger cell and centers the contents of the new cell.

Merge & Center

A cell ______ is a defined set of formatting characteristics.

Style

A _______ chart is useful for illustrating comparisons among related numbers.

Column

In _______ view, you can see the edges of multiple pages, the margins, and the rulers.

Page Layout

________ refers to the process of specifying the appearance of cells.

Formatting

In Excel, the spelling checker performs similarly to those of the other Microsoft Office programs.

???? not sure

Operators are symbols with which you can specify the type of calculation you want to perform in a formula

True

An absolute cell reference refers to a cell by its relative position in the worksheet.

False

A relative cell reference automatically adjusts when a formula is copied.

True

The Comma Style button formats the selected cell as a percentage rounded to the nearest hundredth.

False

The intersection of a column and a row forms a box referred to as a spreadsheet.

False

When you activate the Sum function, Excel first looks below the active cell for a range of cells to sum.

False

AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.

True

Sparklines are tiny charts embedded in a cell and given a visual trend summary alongside your data.

True

If you move formulas by inserting additional rows or columns in your worksheet, Excel automatically adjusts the formulas.

True

A data marker is a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.

True

Displays the value or formula contained in the active cell; also permits entry or editing.

Formula Bar

Displays the name of the selected cell, table, chart, or object.

Name Box

Displays the current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average.

Status bar

identify the worksheets

Sheet tabs

A vertical group of cells in a worksheet.

column

A unique letter that identifies each column.

column heading

A horizontal group of cells.

Row

Displays the columns and rows that intersect to form the worksheet's cells.

Worksheet grid area

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

Pie

To create a pie chart, you must select ________.

two ranges

The order in which the data series in pie charts are plotted in Excel is determined by the order of the data on the _______.

worksheet

You can _______ one or more slices of a pie chart to emphasize a specific slice or slices.

explode

A ________ is a movable, resizable container for text or graphics.

Text box

______ is a gallery of text styles with which you can create decorative effects.

WordArt

________ refers to the process of changing the values in cells to see how those changes affect the outcome of formulas in your worksheet.

What-If Analysis

______ find(s) the input needed in one cell to arrive at the desired result in another cell.

Goal Seek

When writing a formula in Excel, use _____ to communicate the order in which the operations should occur.

Parentheses

A ______ chart displays trends over time.

line

A(n) _______ cell reference refers to a cell by its fixed position in the worksheet.

absolute

_______ is a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.

Bevel

In a pie chart, the size of each pie slice is equal to its value compared to the total value of all the slices.

True

A fund is a sum of money set aside for a specific purpose.

True

2-D refers to an image that appears to have all three spatial dimensions- length, width, and depth.

False

Bevel is a shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.

True

The entire chart and all of its elements comprise the chart area.

True

If you edit the data in your worksheet, the chart data markers will not adjust automatically.

False

Formula autocomplete is an Excel feature which, after typing an equal sign and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s).

True

Formatting marks are the short lines that display on an axis at regular intervals.

False

A plot area is a line that serves as a frame of reference for measurement.

False

The area along the bottom of a chart that identifies the categories of data is referred to as the category axis.

True.

The set of mathematical rules that Excel follows is called the order of operations.

True

A line that serves as a frame of reference for measurement

Axis

The area bounded by the axes, including all the data series.

plot area

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

X-axis

The area along the left side of a chart that shows the range of numbers for data points.

Y-axis

Shows the relationship of each part to a whole.

Pie chart

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

data point

The related data points represented by data markers.

data series

A workbook sheet that contains only a chart.

Chart sheet