## 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

### 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

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

data bar

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

label

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

Merge & Center

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

Page Layout

### 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

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

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 current cell mode, page number, worksheet information, view and zoom buttons, and for numerical data, common calculations such as Sum and Average.

Status bar

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

Worksheet grid area

### 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

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

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

### 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

### 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

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

True.

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

Y-axis

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

data point