Chapter 2: Paste Special,

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 formula =ROUND(10.59%,2) results in the value 0.11 (or 11%, if formatted as a %).

True

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

19

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

2

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

2.01

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

24.4

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

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

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

=LARGE(A1:A100,10)

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

Ctrl+Alt+v

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 median is the arithmetic average of a set of numbers.

False

_____ is the average of a set of numbers.

Mean

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

Median

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.EQ (or RANK)

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

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

mode

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