Exam 8: Excel_Module_1

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

Worksheet titles and subtitles should be as wordy as possible.

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

Excel remembers the last ____ actions you have completed.

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

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

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

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

A thin red border indicates the active cell.

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

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?

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

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

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

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