Worksheet Questions

Eleanor wants to repeat the first row of the worksheet on each printed page of a four-page worksheet. Which of the following options should she use in the Page Setup dialog box?

• Row and column headings

• Print area

• Gridlines

• Print titles

Igor wants to set 1-inch margins on the left and right and 0.5-inch margins on the top and bottom of a printed page. Which of the following dialog boxes should he use to change the margins?

• Workbook Setup dialog box

• Footer dialog box

• Custom Margins dialog box

• Page Setup dialog box

If you want to paste values and number formatting only, click the Paste Numbers button that appears below the pasted cell.

• True

• False

The Comma Style format adds a comma and a dollar sign to a cell value.

• True

• False

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

• True

• False

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

• True

• False

To move cell contents one space to the right, you can use the Increase Space button.

• True

• False

After inserting a new worksheet, what should you do to identify the purpose of the worksheet?

• Move the worksheet

• Hide the worksheet

• Protect the worksheet

• Rename the worksheet

A _____ is a named operation that replaces the action of an arithmetic expression.

• formula

• function

• chart

• cell reference

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

• =COUNT(B1:B20)

• =COUNTIF(B1:B20)

• =COUNTA(B1:B20)

• =DCOUNTA(B1:B20)