Exam 1: Excell: Creating a Worksheet and Charting Data

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

A(n)________ is a vertical group of cells in an Excel worksheet.

Free
(Short Answer)
4.9/5
(47)
Correct Answer:
Verified

column

An outlined cell in a worksheet is the active cell.

Free
(True/False)
4.7/5
(36)
Correct Answer:
Verified

True

A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.

Free
(True/False)
4.9/5
(31)
Correct Answer:
Verified

True

Which of the following does not display to the right side of a selected chart?

(Multiple Choice)
4.8/5
(26)

The Sum button resides on both the Home tab and the Formulas tab.

(True/False)
4.7/5
(37)

The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.

(True/False)
4.8/5
(39)

A data series is a collection of related data points.

(True/False)
4.8/5
(40)

To indicate a range,include a dash between the two cell references.

(True/False)
4.7/5
(41)

Which of the following is NOT a way to create a formula?

(Multiple Choice)
4.7/5
(44)

Auto Fill works only with alphabetic values.

(True/False)
4.8/5
(28)

Ctrl + = starts the Sum function in a worksheet.

(True/False)
4.7/5
(42)

You can create a custom footer in Excel.

(True/False)
4.9/5
(28)

The category axis is also known as the y-axis.

(True/False)
4.9/5
(38)

The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.

(True/False)
4.8/5
(29)

Text that is typed in a cell that extends into the next cell only displays if the two cells are merged.

(True/False)
4.9/5
(38)

________ is the keyboard shortcut for the Spelling command.

(Multiple Choice)
4.7/5
(37)

When you select a range of data,the ________ button displays.

(Short Answer)
4.8/5
(35)

If two cells are merged into one,the cell contents are automatically left justified in the new,merged cell.

(True/False)
4.8/5
(37)

AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.

(True/False)
4.9/5
(37)

A(n)________ is a graphic representation of data in a worksheet.

(Short Answer)
4.9/5
(39)
Showing 1 - 20 of 97
close modal

Filters

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