Exam 11: Excel : Formulas, Functions, and Formatting

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

The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

(Multiple Choice)
4.8/5
(40)

_____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

(Multiple Choice)
4.8/5
(38)

Which of the following is the path to the Copy and Paste buttons?

(Multiple Choice)
4.7/5
(34)

To copy cell contents, you can select the cell and then press the _____ keys.

(Multiple Choice)
4.9/5
(29)

Typing =av in a cell displays the _________________________.

(Short Answer)
4.8/5
(33)

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as _________________________.

(Short Answer)
4.8/5
(25)

If you have a long text entry, such as a paragraph, you can instruct Excel to _________________________ text in the cell.

(Short Answer)
4.9/5
(33)

Point mode allows you to select cells for use in a formula by using the keyboard.

(True/False)
4.8/5
(37)

You should _____ a function name in the Formula AutoComplete list to select the function.

(Multiple Choice)
4.9/5
(39)

Which of the following is the path to the Conditional Formatting button?

(Multiple Choice)
4.8/5
(32)

Which of the following is the path to the Spelling button?

(Multiple Choice)
5.0/5
(30)
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Spell-checking a worksheet.
Responses:
CTRL+V
F9
CTRL+ACCENT MARK (`)
Correct Answer:
Verified
Premises:
Responses:
Spell-checking a worksheet.
CTRL+V
(Matching)
4.7/5
(31)
Showing 101 - 112 of 112
close modal

Filters

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