Excel Chapter 2

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

Hypertonic/Hypotonic/Isotonic Solutions

View Set

Chapter 8 Classes and Objects: A Deeper Look

View Set

English Language Arts (11-B) Unit 1 Test Review

View Set

Ch 9 Maternal and Fetal Nutrition

View Set