Excel Chapter 2

11 September 2022
4.7 (114 reviews)
35 test answers

Unlock all answers in this set

Unlock answers (31)
question
By default, Excel aligns date entries at the ____ of the column.
answer
right edge
question
By default, Excel column widths are set at ____ characters, and row heights at ____ points.
answer
8.11: 14.40
question
Ctrl + F is the keyboard shortcut for
answer
opening the Find & Replace dialog box with the Find tab active.
question
Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.
answer
Styles
question
Excel's Spelling feature begins spell checking at the
answer
active cell.
question
If you do not want to widen a column, what can you do to fit the text into the column?
answer
Click the Wrap Text button in the Alignment group
question
Inserted rows are placed ____ the selected row(s) and inserted columns are placed to the ____ of the selected column(s).
answer
above; left
question
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.
answer
Online Pictures
question
On which tab will you find the Insert button?
answer
Home
question
Once an image has been inserted, it can be
answer
moved, resized, or deleted
question
Selecting which of these formatting options will always change the entire worksheet?
answer
Themes
question
The ____ is the typeface used to display and print data. It is measured in
answer
font: points.
question
The Clear All option in the Clear button removes the ____ from the active cell.
answer
contents, formats, and comments
question
The Find & Replace dialog box can be used to search for and replace
answer
labels, values, and formats
question
The Freeze Panes button is located in the ____ group on the ____ tab.
answer
Window: View
question
The keyboard shortcut for cutting the selection and placing it on the Clipboard is
answer
Ctrl + X
question
The keyboard shortcut for repeating a command is
answer
Ctrl + Y.
question
The Themes group is located on the ____ tab.
answer
Page Layout
question
This action sets the width of a column to fit the longest entry in the column
answer
double-clicking the boundary line
question
This Excel feature can be used to replace a word in the worksheet with another word of similar meaning.
answer
Thesaurus
question
To center text between the top and bottom of a cell, click the _____ button in the Alignment group on the Home tab.
answer
Middle Align
question
Using the keyboard shortcut F7 will start which feature?
answer
Spelling
question
What does Excel's Freeze Panes option do?
answer
causes the specified rows and columns to remain fixed while scrolling
question
What does the Format Painter feature do?
answer
copies formats from a selected cell to another cell
question
What happens when you click the Increase Indent button?
answer
The contents of the active cell are indented approximately one character width
question
When changing a column width by dragging the boundary line to the right or left, a ____ is displayed to indicate the new width.
answer
line
question
When copying or moving cells, if data already exists in the destination cells, Excel
answer
replaces the contents.
question
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.
answer
10%
question
When you change the color of the fill in a cell, you are changing its
answer
Background
question
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 ____.
answer
Plus sign: Copied
question
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
answer
four-headed arrow
question
Which cell format is used by default in Excel?
answer
General
question
Which of the following statements correctly describes the relationship between row height and font size?
answer
Row height is automatically increased to accommodate an increase in font size.
question
Which of the following statements describes how the Borders button changes?
answer
It updates to display the most recently selected border style.
question
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.
answer
Number: Home