Exam 8: Excel_Module_1

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

Which of the following keys toggles between Insert mode and Overtype mode?

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.

The ____ button allows you to erase recent cell entries.

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.

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

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 can display characters in only three font colors: black, red, and blue.

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

Combining two or more selected cells into one cell is called ____ cells.

Which of the following is the Ribbon path to the Cell Styles button?

Live preview is available on a touch screen.

Case 1-2 ​ 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 Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?

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

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

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

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

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

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

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