Excel

Ace your homework & exams now with Quizwiz!

Select all box

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

Absolute

A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:

Active cell

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

Line chart

A chart type that displays trends over time is a:

Shape effects

A gallery of text styles with which you can create decorative effects, such as shadowed or mirrored text is:

Table

A series of rows and columns with related data that is managed independently other data is a:

Data bar

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

Fund

A sum of money set aside for a specific purpose is a:

Point

A value that originates in a worksheet cell and that is represented in a chart by a data mark is a data:

Summary sheet

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

Name box

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

Formula bar

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

Workbook

On startup, Excel displays a new blank:

Series

Related data points represented by data markers are referred to as the data:

Print titles

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

Explode

The action of pulling out a pie slice from a pie chart is called:

Axis area

The area bounded by the axes of a chart, including all the data series is the:

Freeze panes

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

Underlying value

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

General format

The default format that Excel applies to numbers is the:

Auto fill

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

NOW function

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

Sheet tabs

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

Increase

The percent by which one number increases over another number is the percentage rate of:

Sorting

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

Filtering

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:

Absolute

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

Detail sheets

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

Data axis

The x-axis is also known as the:

Sparklines

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


Related study sets

Network+ Ch 5, 6, 7, 9 Sample Quiz/Test

View Set