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


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


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


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.


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


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.


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


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


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.


How countless chart types does Excel offer?


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


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.


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.


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


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


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


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


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


Worksheet titles and subtitles must be together wordy together possible.


A thin red border suggests the energetic cell.


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


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


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.


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


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


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


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


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.


Live preview is available on a touch screen.


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


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


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).