The ____ function works behind the scenes, fixing common typing or spelling mistakes as soon as you complete a text entry.

You are watching: To erase an entire entry in a cell and then reenter

AutoCorrect

Pressing the ____ an essential to complete an entry activates the surrounding cell come the right.

RIGHT ARROW

The range of cell receiving replicated content is called the ____ area.

paste

You can go into the correct range in a duty by keying the beginning and also ending cell referrals separated by a ____.

colon (:)

Excel remembers the last ____ plot you have completed.

100

A ____ referral is an readjusted cell referral in a copied and also pasted formula.

relative

The ____ button enables you to pick whether you desire to copy the worths from the source area to the destination area through formatting.

Auto to fill Options

You ____ a worksheet come emphasize certain entries and make the worksheet less complicated to read and understand.

format

You can use the bolder font format by pressing the ____ keyboard shortcut keys.

CTRL+B

Combining two or much more selected cells into one cell is referred to as ____ cells.

merging

Which the the adhering to is the Ribbon course to the Cell layouts button?

(HOME tab | styles group)

What effect does the audit Number format have ~ above the selected cells?

Displays cell components with 2 decimal locations that align vertically

What result does the Comma Style format have on the selected cells?

Displays cell components with two decimal places and commas as thousands separators

Pressing the ____ keyboard shortcut key(s) selects cell A1.

CTRL+HOME

How countless chart types does Excel offer?

15

A pie chart through one or an ext slices counter is referred to as a(n) ____ pie chart.

exploded

The date you readjust a file is an example of a(n) ____ property.

automatically updated

____ nature are connected with every Microsoft Office files and include author, title, and also subject.

Standard

You usage ____ to see an XPS file.

XPS Viewer

The ____ area ~ above the condition bar has six commands and the an outcome of the associated calculation on the appropriate side of the menu.

AutoCalculate

Which that the complying with keys toggles between Insert mode and also Overtype mode?

INSERT

To erase an entire entry in a cell and then reenter the data native the beginning, push the ____ key.

ESC

Which of the following keys moves the insertion allude to the beginning of data in a cell?

HOME

Which the the following keys move the insertion suggest to the finish of data in a cell?

END

A requirements document includes a requirements statement, resource of data, an overview of calculations, and any other special demands for a worksheet.

True

Worksheet titles and subtitles must be together wordy together possible.

False

A thin red border suggests the energetic cell.

False

Both the publication button and the go into button show up on the formula bar as soon as you begin typing in a cell.

True

The AutoCorrect function can instantly capitalize the first letter in the name of days.

True

When message is longer than the width of a column, Excel screens the overflow characters in nearby cells to the ideal as long as those surrounding cells save no data.

True

Excel recognizes the adhering to as text: 401AX21, 921-231, 619 321, 883XTY.

True

A solitary point is around 1/32 the one customs in height.

False

Excel have the right to display characters in only three font colors: black, red, and blue.

False

A character with a point size of 10 is about 10/72 of one inch in height.

True

Modifying the column widths generally is done last due to the fact that other formatting alters may influence the dimension of data in the cells in the column.

True

Live preview is available on a touch screen.

True

You can press the RIGHT arrow or LEFT arrowhead keys to place the insertion suggest during in-cell editing.

True

With Excel in modify mode, you can edit cell components directly in the cell.

See more: What Is A Three Dimensional Representation Of The Earth ? Which Is The Three

True

To add a pie chart, very first select the data to be charted and also then insanity or click the Insert Pie or Doughnut Chart switch (INSERT tab | Charts group).