Excel Chapter 2

What is the keyboard shortcut for Flash Fill?

• Alt + E

• Ctrl + E

• Ctrl + F

• Ctrl + F2

The MEDIAN function finds ________.

• the average value in a range of cells

• all numbers that correspond to an argument in the function

• the one number that corresponds to an argument in the function

• the middle value in a range of sorted values

To rotate text in a worksheet, in the Format Cells dialog box, you can click and drag the ________.

• red diamond

• red circle

• blue diamond

• black, bold triangle

The COUNTIF function has two arguments: ________.

• the range of cells to check and the criteria

• a value as the criteria and an average of a range of cells

• the range of cells to check and the sum of the range

• the range of cells to sum and the criteria

Which of the following is not a proper comparison operator?

• =>

• >=

• <>

• <

When using the Freeze Panes feature, what is a pane bounded by?

• The ribbon

• A solid red line

• Vertical or horizontal bars

• The status bar

How do you know if some rows of a table have been hidden from view when a filter is applied?

• Row numbers display in red

• Row numbers display in blue

• Row numbers appear in bold

• The number of hidden rows displays next to the funnel icon.

Which command enables you to stretch or shrink the width, height, or both of printed output to fit a printout on a maximum number of pages?

• Scale to Fit

• Zoom

• Print Titles

• Split

Where do sheet tabs display in a workbook?

• In the lower left area of the workbook window

• On the right side of the workbook window

• On the status bar

• Just below the ribbon

On your keyboard, which two symbols function identically in typed date formats?

• The forward slash key and the period

• The dollar sign and the ampersand

• The hyphen key and the forward slash key

• The comma and the forward slash key