FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel_Module_1

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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.

Live preview is available on a touch screen.

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

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.

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

Excel can display characters in only three font colors: black, red, and blue.

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

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

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

The ____ button allows you to erase recent cell entries.

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

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

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.

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

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

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.

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

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?