Cpsc 215 test 1 Multiple choice

When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.

arrow

A worksheet ____ is a collection of two or more selected worksheets.

group

The range of values or _______, of an axis is based on the values in the data source.

scale

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.

external

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

relative

=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.

nested

The ____ caption indicates a worksheet group.

[Group]

The numbers, text, or cell references used by the function to return a value are called ____.

arguments

Which of the following is a Statistical function? _____

Average

A ____ is a workbook that you can open with the text, formats, and formulas already built into it.

template

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.

!

The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4."

Sheet1:Sheet4

To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.

tab

To resize an embedded chart, ____.

select the chart and drag the corner sizing handle of the selection box

A pie slice is a data marker that represents ____ from a data series.

only one value

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

freezing

You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane.

format data labels

To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab.

convert to range

When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.

dialog box

In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

outlines

A ________ contains the actual values that are plotted on the chart.

data series

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

descending

In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= “NO”? _____

the formula returns the rext “RESTART”

The ____ identifies which data markers are associated with each data series.

legend

Absolute references are marked with a ____.

$