Excel Final

As you type in a cell, ____ displays any existing entry in the column that matches the characters you typed.

AutoComplete

Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

3-D

____ is a program that searches for the optimal solution of a problem involving several variables.

Solver

Contains the information when two files are linked

Source

A table name can include all of the following except ____.

Spaces

Contains text, formats, and formulas already built into it for your use

Template

When a worksheet group is selected, the ____ includes text to indicate the sheets are in fact grouped.

Title bar

If you delete a value from one cell, the content is also deleted from the same cell in all the worksheets in the group.

True

Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.

True

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.

True

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

True

When you create a table, if your data does not contain column headers, Excel adds headers with default names.

True

You can use a table s sizing handle to add columns or rows to a table.

True

Each worksheet functions independently again

Ungroup

To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

Ungroup sheets

In two-variable tables, you must always place a reference to the result cell in the ____ corner of the table at the intersection of the row values and the column values.

Upper-left

The general format of a 3-D cell reference is ____.

WorksheetRange!CellRange

When defining a scenario, you must include which of the following parts?

input cells values of the input cells

You are tutoring a fellow student who is new to the more advanced features of Excel. Your tutee has a lot of familiarity with ranges from an earlier Excel class, but he knows that there is an alternative that will give him access to additional features that he does not have with a cell range. What is that option?

Convert the range to a table.

You use ____ filters to find all objects with a value greater than X or acquired after a certain date.

Criteria

You can display or hide an Excel table's filter arrows using the Filter button in the Sort & Filter group on the ____ tab.

Data

A data ____ table describes the fields you plan to maintain in a table.

Defintion

To delete a sort field in the Sort dialog box, click the ____ button.

Delete level

____ order arranges labels in reverse alphabetical order, from Z to A.

Descending

Receives the information when two files are linked

Destination

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.

Editing

Once a scenario is created in Excel's Scenario Manager, it cannot be edited or deleted.

False

To select nonadjacent worksheets, you click a sheet tab of one of the worksheets, and then press and hold down the Shift key as you click the sheet tabs of other worksheets you want included in the group.

False

When creating an array formula within an Excel data table, you must enclose the formula in parentheses to obtain a result.

False

When you delete a record from a table, a dialog box displays to confirm the delete operation.

False

You can insert subtotals into an Excel table to summarize subgroups of data without converting the table to a range.

False

A link is a connection between two ____ allowing information to be transferred from one to the other.

Files

A business must pay insurance and rent; these are examples of ____ expenses.

Fixed

____ rows and columns allows you keep headings on the screen as you work with the data in a large Excel worksheet.

Freezing

The ____ caption indicates a worksheet group.

Group

Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.

Ranges

Using Excel s Goal Seek feature, you specify the ____ values you want.

Result

If you orient a one-variable table so that the input values are in the first row, you would use the ____ input cell option.

Row

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

Rows and columns

The ____ arrangement option layers the open workbooks on the screen.

Cascade

____ analysis expresses the relationship between a company's expenses, its volume of business, and the resulting profit.

CVP

After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records

Clear

If a sheet range includes more than one sheet, you specify the first and last sheet in the range separated by a ____.

Colon

In laying out the PivotTable on the worksheet, you can drag the Condition field button from the Row Labels box to the Column Labels box. The PivotTable is rearranged so that the Condition field is a ____ label.

Column

A structured table is a workbook with labels, formats, and formulas already built into it with data removed.

False

As in traditional what-if analysis, Goal Seek starts with the end result and determines what value you should use to reach a desired answer.

False

Microsoft Excel s Goal Seek changes the ____ values to produce the resulting values you seek to determine.

Input

To create a table in Microsoft Excel 2013, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.

Insert

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box, and checking the ____ check box.

Match entire cell contents