Quiz 2

Question 1

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

Answer 1

Paste Special

Question 2

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

Answer 2

normal distribution

Question 3

The formula =ROUNDDOWN(9.99,1) results in the value_____.

Answer 3

9.9

Question 4

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

Answer 4

24.4

Question 5

To count how many “A” grades there in the range C3:C100, use the formula

Answer 5

COUNTIF(C3:C100,”A”)

Question 6

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

Answer 6

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

Question 7

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

Answer 7

2

Question 8

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

Answer 8

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

Question 9

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

Answer 9

=LARGE(A1:A100,10)

Question 10

_____ is the average of a set of numbers.

Answer 10

Mean

Question 11

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

Answer 11

=AVERAGE(F4:F20)

Question 12

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

Answer 12

5

Question 13

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 _____.

Answer 13

Transpose

Question 14

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

Answer 14

Median

Question 15

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.

Answer 15

False

Question 16

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

Answer 16

2

Question 17

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

Answer 17

True

Question 18

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, _____.

Answer 18

use freeze panes

Question 19

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

Answer 19

True

Question 20

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

Answer 20

mode

Question 21

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

Answer 21

19

Question 22

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.)

Answer 22

Split Window

Question 23

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

Answer 23

Ctrl+Alt+v

Question 24

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

Answer 24

True

Question 25

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

Answer 25

2.01

Question 26

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 _____.

Answer 26

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

Question 27

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

Answer 27

RANK

Question 28

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 _____.

Answer 28

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

Question 29

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

Answer 29

4

Question 30

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

Answer 30

Standard deviation