BUSI 520 Chapter 2

The option of _____ displays a dialog box that provides all the different paste options.

Paste Special

To find the relative position of values within a data set, use the _____ function.

RANK

The formula =ROUND(SUM(9.33,9.55),0) results in

19

The formula =ODD(3.23) results in the value _____.

5

_____ is the formula that returns the arithmetic mean for the range F4:F20.

=AVERAGE(F4:F20)

To count how many "A" grades there in the range C3:C100, use the formula _____.

=COUNTIF(C3:C100,"A")

The correct formula for counting values in the range D5:D25 that are greater than 90 is _____.

=COUNTIF(D5:D25,">90")

The correct formula to count all items in the range E4:E20 that end with a "d" in the third to last position in the text value is _____.

=COUNTIF(E4:E20,"*d??")

The formula _____ counts all product codes in the range H4:H25 with only a single character followed by 715.

=COUNTIF(H4:H25,"?715")

To find the 10th largest value from a list of values in cells A1:A100, use _____.

=LARGE(A1:A100,10)

A professor is interested in making certain parts of his gradebook remain visible even if he has lots of students or lots of test, making it necessary to scroll. He wants to always be able to see the student names, student id's, and the column headings (containing the test #'s, etc.). What cell or cells should be selected prior to freezing panes?

C4

If you entered 5.09 into a cell with a custom number format of #.###, the number will be displayed in the cell as 5.090.

False

The formula =ROUNDDOWN(9.99) results in the value of 10.

False

The formula =TRUNC(4.6) results in the integer value of 5.

False

The median is the arithmetic average of a set of numbers.

False

The mode of the numbers 2, 2, 6, 7, 8 is 5.

False

The quickest way to invoke the Paste Special dialog box is by pressing _______.

Ctrl+Alt+v

To change the rows of the original cell range to become the columns in the pasted cell range, use the Paste (or Paste Special) Option of _____.

Transpose

The equation (New_Value - Old_Value)/Old_Value can be used to calculate the percent difference.

True

The formula =ROUND(10.59%,2) results in the value 0.11 (or 11%, if formatted as a %).

True

To round the number 4.43 to next highest even integer, use the formula =EVEN(4.43).

True

A professor is interested in comparing the grades for several pairs of students, so he wants to view their grades side-by-side, to see if the grades are similar. What Excel feature is best to use? (You should be able to scroll in both the top window and the bottom window, in order to easily view different pairs of students.)

Split window

_____ is a measure of how widely the data values are dispersed from the arithmetic mean.

Standard deviation

When numbers containing zeros are entered in a cell, if 0 is used as one of the digits in the cell's custom formatting code, that digit displays _____.

any digit, regardless of whether it affects the value of the number

To fix the rows so that a number of rows are displayed in the top pane (and cannot be scrolled) while the bottom pane can be scrolled, _____.

use freeze panes

The arithmetic value that occurs most frequently in the set is the _____.

mode

A _____ exhibits an equal number of occurrences of data values both above and below the arithmetic mean.

normal distribution

_____ is the arithmetic value that occurs in the middle of a data set when organized from lowest to highest.

Median

The formula =ROUND(24.449,1) results in _____.

24.4

In the set of numbers 2, 2, 4, 5, 9, the mode is _____

2

The formula =ROUND(2.49,0) results in _____.

2

The formula =ROUNDUP(2.003,2) results in _____.

2.01

_____ is the average of a set of numbers.

Mean