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

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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 default font for a new workbook is ____________________ 11-point regular black.

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.

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

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

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.

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 choose whether you want to copy the values from the source area to the destination area with formatting.

Live preview is available on a touch screen.

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

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

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

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.

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