Exam 8: Formats, Functions, and Formulas

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

The keyboard shortcut for the Time format is ________.

(Multiple Choice)
4.8/5
(26)

The currency symbol is aligned to the left side of the cell in the ________ format.

(Multiple Choice)
4.8/5
(25)

To hide gridlines,uncheck the Gridlines box in the ________ tab.

(Multiple Choice)
4.9/5
(30)

To make rapid and accurate changes to the appearance of a workbook with very little effort,you can use built-in cell styles.

(True/False)
4.8/5
(37)

The order of operations that is used in Excel spells ________.

(Multiple Choice)
4.8/5
(31)

If multiple mathematical operands are included in a function or formula,Excel processes the calculations based on the ________.

(Short Answer)
4.8/5
(41)

A ________ cell is the cell that contains the data supplied to a function.

(Multiple Choice)
4.8/5
(38)

Which of the following is NOT true about the banding format of an Excel table?

(Multiple Choice)
4.8/5
(30)

To have a better sense of how the worksheet is structured,you can ________.

(Multiple Choice)
4.7/5
(36)

C12 is an example of a cell ________.

(Short Answer)
4.9/5
(29)

Excel uses the ________ presentation of information via charts and graphs.

(Multiple Choice)
4.9/5
(31)

A useful feature of a(n)________ style is the ability to "band" rows and columns.

(Short Answer)
4.9/5
(34)

Each table column in Excel must have a unique name.

(True/False)
4.9/5
(30)

One of the useful features of a ________ is the ability to "band" rows and columns.

(Multiple Choice)
4.8/5
(41)

Cell ________ allows cell content to be arranged horizontally as well as vertically.

(Short Answer)
4.7/5
(37)

The values inside a function's parentheses are called ________.

(Short Answer)
4.8/5
(36)

To hide gridlines,check the Gridlines box in the Show group on the View tab.

(True/False)
4.8/5
(26)

If you want to total a specified range,list of numbers,list of cells,or any combination,you would use the ________ function.

(Multiple Choice)
4.8/5
(44)

The keyboard shortcut for the Short Date format is ________.

(Multiple Choice)
4.9/5
(37)

You should use at most ________ fonts in a worksheet.

(Multiple Choice)
4.9/5
(37)
Showing 61 - 80 of 100
close modal

Filters

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