Exam 12: Creating a Worksheet

You could create a formula that uses both the Sum and the Minimum functions to sum up a series of test scores, but first drop the lowest score._________________________

A rectangle of dashes around the selected cell is called a(n) border._________________________

To select a range of cells for use as arguments in a function, click the ____ that contains data you want to use in the function, then drag down to the bottom-right cell.

To edit a label after you've pressed the Enter key, click the cell, then click in ____.

A(n) value is a number that you intend to use in a calculation and that is entered into a cell of a worksheet._________________________

A(n) property specifies how to add, subtract, multiply, divide, or otherwise calculate the values in worksheet cells._________________________

A(n) ____ reference is a formula that references the cell in which the formula resides.

Excel includes more than ____ functions from which you can choose.

A rectangle of dashes around the selected cell is called a ____.

You can edit a formula after you've pressed the Enter key in the same way you would edit labels or values-in the cell or in the formula bar.

A worksheet can be used for more than simple calculations.You can build complex formulas to calculate statistical, financial, and mathematical equations.

The Payment function, has three required arguments (Rate, Nper, and Pv) and two optional arguments (Fv and Type).

-In the figure above, the active cell is cell ____.

A(n) ____ consists of values or cell references used to calculate the result of the function.

To make a long label wrap, from the Home tab, click the Wrap Text button in the ____ group.

A ____ contains one or more worksheets, each represented by a tab at the bottom of the Excel window.

Values can be entered automatically using the fill handle and a technique called ____.

Any numerical data you do not intend to use in a calculation should be entered as a ____.

The most common arithmetic ____ are - (subtraction), + (addition), * (multiplication), / (division), % (percent), and ^ (exponent).

You can use the ____ button to select a function from a list.