excel 2 exam

The keyboard shortcut for repeating a command is

Ctrl + Y.

On which tab will you find the Insert button?

Home

You can decrease the number of digits displayed after the decimal point in a number by clicking the Decrease Decimal button, which is located in the _____ group on the _____ tab.

Number; Home

Microsoft Office includes a gallery of media images where you can insert clip art, photographs, and illustrations in a document by using the _____ button on the Insert tab.

Online Pictures

The Themes group is located on the _____ tab

Page Layout

Using the keyboard shortcut F7 will start which feature?

Spelling

Inserted rows are placed _____ the selected row(s) and inserted columns are placed to the _____ of the selected column(s).

above; left

When you change the color of the fill in a cell, you are changing its

background.

What does Excel's Freeze Panes option do?

causes the specified rows and columns to remain fixed while scrolling

Once an image has been inserted, it can be

moved, resized, or deleted.

When copying or moving cells, if data already exists in the destination cells, Excel

replaces the contents

By default, Excel aligns date entries at the _____ of the column.

right edge

When the worksheet is set to 100% magnification, clicking the Zoom In or Zoom Out buttons at either side of the Zoom slider bar magnifies or shrinks the display of the worksheet by _____ each time the button is clicked.

10%

By default, Excel column widths are set at _____ characters, and row heights at _____ points.

8.43; 15

The keyboard shortcut for cutting the selection and placing it on the Clipboard is

Ctrl + X.

Which of the following statements correctly describes the relationship between row height and font size?

Row height is automatically increased to accommodate an increase in font size.

What happens when you click the Increase Indent button?

The contents of the active cell are indented approximately one character width.

This Excel feature can be used to replace a word in the worksheet with another word of similar meaning.

Thesaurus

Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.

cell styles

The Clear All option in the Clear button removes the _____ from the active cell.

contents, formats, and comments

What does the Format Painter feature do?

copies formats from a selected cell to another cell

The _____ is the typeface used to display and print data. It is measured in

font; points.

When you point at the border of a selected range of cells, the mouse pointer changes to a white arrow with the move icon attached. The move icon is represented by a

four-headed arrow.

The Find & Replace dialog box can be used to search for and replace

labels, values, and formats.

When changing a column width by dragging the boundary line to the right or left, a _____ is displayed to indicate the new width.

line