excel

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 columns heading

• 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

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

• Format cells dialog box

• home tab

• insert tab

• mini toolbar

You can use the Find and Replace dialog box to find and replace _____.

• cell references

• cell formatting

• worksheet names

• function names

A theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats.

• true

• false

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