Filters
Question type

Study Flashcards

A thin red border indicates the active cell.

A) True
B) False

Correct Answer

verifed

verified

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

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) semi-colon (;)
B) colon (:)
C) period (.)
D) none of the above

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A) HOME
B) DELETE
C) END
D) BACKSPACE

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

Correct Answer

verifed

verified

Excel remembers the last ____ actions you have completed.


A) 25
B) 50
C) 75
D) 100

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) RIGHT ARROW
B) LEFT ARROW
C) UP ARROW
D) DOWN ARROW

E) A) and B)
F) C) and D)

Correct Answer

verifed

verified

Worksheet titles and subtitles should be as wordy as possible.

A) True
B) False

Correct Answer

verifed

verified

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


A) automatically updated
B) baseline
C) standard
D) indexed

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Showing 61 - 75 of 75

Related Exams

Show Answer