Filters
Question type

Study Flashcards

Identify the letter of the choice that best matches the phrase or definition.

Premises
Highlights one or more adjacent characters to the right.
Responses
ARROW
SHIFT+RIGHT ARROW
HOME
CTRL+F
ALT+PAGE DOWN
CTRL+HOME
BACKSPACE
END
SPACEBAR
INSERT

Correct Answer

ARROW
SHIFT+RIGHT ARROW
HOME
CTRL+F
ALT+PAGE DOWN
CTRL+HOME
BACKSPACE
END
SPACEBAR
INSERT

Identify the letter of the choice that best matches the phrase or definition.

Premises
Should not be used to clear a cell.
Responses
ARROW
ALT+PAGE DOWN
HOME
END
CTRL+HOME
BACKSPACE
INSERT
SHIFT+RIGHT ARROW
CTRL+F
SPACEBAR

Correct Answer

ARROW
ALT+PAGE DOWN
HOME
END
CTRL+HOME
BACKSPACE
INSERT
SHIFT+RIGHT ARROW
CTRL+F
SPACEBAR

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


A) merging
B) mixing
C) combining
D) spanning

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

Correct Answer

verifed

verified

Critical Thinking Questions Case 1-2 Anita is new to Microsoft Excel 2013.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) None of the above
F) A) and D)

Correct Answer

verifed

verified

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


A) INSERT
B) ENTER
C) TAB
D) ALT

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

Correct Answer

verifed

verified

The range of cells receiving copied content is called the ____ area.


A) fill
B) range
C) location
D) paste

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

Correct Answer

verifed

verified

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

A) True
B) False

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
Selects the cell at the beginning of the row that contains the active cell.
Responses
END
INSERT
CTRL+F
SPACEBAR
ALT+PAGE DOWN
SHIFT+RIGHT ARROW
CTRL+HOME
ARROW
BACKSPACE
HOME

Correct Answer

END
INSERT
CTRL+F
SPACEBAR
ALT+PAGE DOWN
SHIFT+RIGHT ARROW
CTRL+HOME
ARROW
BACKSPACE
HOME

Identify the letter of the choice that best matches the phrase or definition.

Premises
Selects cell A1.
Responses
ARROW
SHIFT+RIGHT ARROW
END
HOME
SPACEBAR
CTRL+F
BACKSPACE
CTRL+HOME
INSERT
ALT+PAGE DOWN

Correct Answer

ARROW
SHIFT+RIGHT ARROW
END
HOME
SPACEBAR
CTRL+F
BACKSPACE
CTRL+HOME
INSERT
ALT+PAGE DOWN

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.


A) AutoFormat
B) AutoComplete
C) AutoFunction
D) AutoCalculate

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

Correct Answer

verifed

verified

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
Selects the adjacent cell in the direction of the arrow on the key.
Responses
END
CTRL+F
HOME
BACKSPACE
ARROW
SHIFT+RIGHT ARROW
INSERT
ALT+PAGE DOWN
CTRL+HOME
SPACEBAR

Correct Answer

END
CTRL+F
HOME
BACKSPACE
ARROW
SHIFT+RIGHT ARROW
INSERT
ALT+PAGE DOWN
CTRL+HOME
SPACEBAR

A single point is about 1/32 of one inch in height.

A) True
B) False

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 ____ reference is an adjusted cell reference in a copied and pasted formula.


A) revised
B) relative
C) recycled
D) retained

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

Correct Answer

verifed

verified

Critical Thinking Questions Case 1-1 Perry has recently expanded his business and hired two employees.As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks.Perry also decides that he should approve ____ of any proposed worksheet.


A) the font and font size
B) a chart
C) a sketch
D) the title and subtitle text

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

Correct Answer

verifed

verified

The person or persons requesting the worksheet should supply their requirements in a ____ document.


A) blank
B) test issues
C) requirements
D) certified

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

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
Selects the cell one worksheet window to the right.
Responses
END
SHIFT+RIGHT ARROW
BACKSPACE
INSERT
CTRL+HOME
CTRL+F
HOME
ALT+PAGE DOWN
ARROW
SPACEBAR

Correct Answer

END
SHIFT+RIGHT ARROW
BACKSPACE
INSERT
CTRL+HOME
CTRL+F
HOME
ALT+PAGE DOWN
ARROW
SPACEBAR

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Showing 21 - 40 of 112

Related Exams

Show Answer