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 41

True/False

Review LaterAdd Note

Review Later

A thin red border indicates the active cell.

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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 features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

A) AutoComplete
B) AutoCalculate
C) AutoCorrect
D) Auto Fill

E) A) and B)
F) All of the above

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

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

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

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

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

Excel remembers the last ____ actions you have completed.

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

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

Worksheet titles and subtitles should be as wordy as possible.

The date you change a file is an example of a(n) ____ property.

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