Test 3 - Excel

The values that an excel function uses to perform calculations or operations are the

Arguements

The process of arranging data in a specific order based on the value in each field is called:

Sorting

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

Name Box

The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:

Flash Fill

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

Formula Bar

The action of placing cell contents that have been copied or moved to the clipboard into another location is called:

Paste

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

Underlying Value

The term used to describe am Excel function that is subject to change each time the workbook is opened is called:

Volatile

On startup, Excel displays a new blank:

Workbook

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

category axis

A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:

data bar

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

Select All Box

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

Absolute

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

Active Cell

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

Auto Fill

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

AutoFit

The worksheets that contains the details of the information summarized on a summary sheet are called:

Detail sheets

A series of rows and columns that contains related data and that is managed independently from other data is an Excel:

Excel Table

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:

Filtering

The default format that Excel applies to numbers is the:

General Format

The function that retrieves and then displays the date and time from your computer is the:

NOW Function

The target destination for data that has been cut or copied using the Office Clipboard is the :

Paste Area

The Excel command that enables you to specify rows and columns to repeat on each printed page is:

Print Titles

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel for such as charts, color-coding, and formulas is called:

Quick Analysis Tool

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

Range Finder

The labels along the lower border of the workbook window that identify each worksheet are the:

Sheet Tabs

The command that enables you to select one or more rows or columns and lock them into place is:

freeze panes

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

operators

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

sparklines

A worksheet where totals from other worksheets are displayed and summarized is a:

summary sheet