A thin red border indicates the active cell.

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

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

A single point is about 1/32 of one inch in height.

Excel can 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 usually is done last because other formatting changes may affect the size of data in the cells in the column.

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

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

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

With Excel in Edit mode, you can edit cell contents directly in the cell.

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

You should press the SPACEBAR to clear a cell

A(n) ____________________ conveys a visual representation of data.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

The active cell reference appears in the ____________________ on the left side of the formula bar.

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Excel’s ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

____________________ indicates how characters are emphasized.

The default font for a new workbook is ____________________ 11-point regular black.

____________________ cells involves creating a single cell by combining two or more selected cells.

Like an area chart, a(n) ____________________ chart often is used to illustrate changes in data over time.

____________________ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

In a worksheet, columns typically contain information that is similar to a list.

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range.

The opposite of merging cells is splitting a merged cell.

Perry has recently expanded his business and hired two employees. As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks.

Perry decides that before either of his employees creates a new workbook he must give them a ____.

Perry also decides that he should approve ____ of any proposed worksheet.

Anita is new to Microsoft Excel 2016. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive.

Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?