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