Exam 9: Excel: Creating a Worksheet and a Chart

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

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

(Multiple Choice)
4.8/5
(31)

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.

(Multiple Choice)
4.8/5
(30)

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?

(Multiple Choice)
4.8/5
(41)

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

(Multiple Choice)
4.8/5
(28)

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

(True/False)
4.9/5
(41)
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Selects cell A1.
Responses:
ARROW
SHIFT+RIGHT ARROW
END
Correct Answer:
Verified
Premises:
Responses:
Selects cell A1.
ARROW
(Matching)
4.9/5
(34)

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

(Multiple Choice)
4.8/5
(35)
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
Correct Answer:
Verified
Premises:
Responses:
Should not be used to clear a cell.
ARROW
(Matching)
4.8/5
(30)

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

(Multiple Choice)
4.9/5
(37)
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
Correct Answer:
Verified
Premises:
Responses:
Selects the adjacent cell in the direction of the arrow on the key.
END
(Matching)
4.9/5
(35)

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.

(Multiple Choice)
4.9/5
(40)

A ____ reference is an adjusted cell reference in a copied and pasted formula.

(Multiple Choice)
4.8/5
(34)
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
Correct Answer:
Verified
Premises:
Responses:
Selects the cell at the beginning of the row that contains the active cell.
END
(Matching)
4.7/5
(25)

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

(True/False)
4.9/5
(32)

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

(True/False)
4.8/5
(40)

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

(Short Answer)
4.8/5
(37)

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

(Short Answer)
4.9/5
(36)
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
Correct Answer:
Verified
Premises:
Responses:
Selects the cell one worksheet window to the right.
END
(Matching)
4.8/5
(39)
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
Correct Answer:
Verified
Premises:
Responses:
Highlights one or more adjacent characters to the right.
ARROW
(Matching)
4.8/5
(41)

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

(True/False)
4.7/5
(28)
Showing 21 - 40 of 112
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)