Excel Chapter 2
The keyboard shortcut for cutting the selection and placing it on the Clipboard is
Ctrl + X
The keyboard shortcut for repeating a command is
Ctrl + Y.
Which cell format is used by default in Excel?
General
On which tab will you find the Insert button?
Home
Which of the following statements describes how the Borders button changes?
It updates to display the most recently selected border style.
To center text between the top and bottom of a cell, click the _____ button in the Alignment group on the Home tab.
Middle Align
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
When you hold down the Ctrl key and drag a selected range of cells, a ____ attached to the pointer indicates that the source contents are being ____.
Plus sign: Copied
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.
Using the keyboard shortcut F7 will start which feature?
Spelling
Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.
Styles
What happens when you click the Increase Indent button?
The contents of the active cell are indented approximately one character width
Selecting which of these formatting options will always change the entire worksheet?
Themes
This Excel feature can be used to replace a word in the worksheet with another word of similar meaning.
Thesaurus
The Freeze Panes button is located in the ____ group on the ____ tab.
Window: View
Inserted rows are placed ____ the selected row(s) and inserted columns are placed to the ____ of the selected column(s).
above; left
Excel's Spelling feature begins spell checking at the
active cell.
What does Excel's Freeze Panes option do?
causes the specified rows and columns to remain fixed while scrolling
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
This action sets the width of a column to fit the longest entry in the column
double-clicking the boundary line
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
Once an image has been inserted, it can be
moved, resized, or deleted
Ctrl + F is the keyboard shortcut for
opening the Find & Replace dialog box with the Find tab active.
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
If you do not want to widen a column, what can you do to fit the text into the column?
Click the Wrap Text button in the Alignment group
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.11: 14.40
When you change the color of the fill in a cell, you are changing its
Background