Advertisement Upgrade to remove ads

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


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


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


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


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


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


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


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.


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


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


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


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


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


Statistical functions test for specific conditions.


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


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.


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


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


Specified conditions


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


greater than


equal to


less than


not equal to


On startup, Excel displays a new blank ______.


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.


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


The default number format is the _______ format.


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.


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


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.


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


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


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


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


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


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


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


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


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


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


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.


A unique letter that identifies each column.

column heading

A horizontal group of cells.


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.


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 _______.


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


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.


________ 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.


A ______ chart displays trends over time.


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


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


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


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


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




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


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


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).


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


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


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


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


A line that serves as a frame of reference for measurement


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.


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


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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!



Reload the page to try again!


Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom


Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set