MS Excel - Ch 1B Test Review

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

What kind of data marker does a pie chart use?

When you add/delete rows or columns in a worksheet, Excel automatically adjusts your formulas.

T/F: Scaling allows the user to set a maximum # of pages to be used when printing a worksheet.

Labels that display along the bottom of a chart that identify categories of data are called ?

To prepare a workbook for printing, the user should use the ___ view.

Contents of a cell can be displayed on multiple lines by using the ___ command.

Which is the Excel operator for exponentiation?

Absolute cell references are indicated by using what symbol in the cell address?

Tiny charts that are embedded in cells are called ___.

Excel's formulas ___ whenever a value is changed that is referenced in the formula.

Excel's ___ visually indicates which workbook cells are included in a formula calculation.

Tiny charts embedded in cells that show a visual trend alongside the data are called ___.

T/F: You must delete the current value in a cell before you can begin entering a new value.

T/F: Each data point is represented in a chart by a legend.

Values that originate in a worksheet that are to be charted are called

T/F: Absolute cell references are indicated by the $ symbol.

New rows will be inserted where in conjunction to the selected row?

A data marker, such as a column, dot, or pie slice on a chart, represents a single ___.

T/F: Excel does not provide a spelling checker.

For data to be more easily understood, present it in a ___ instead of a table of numbers.

T/F: When the user changes a value in a cell, Excel automatically recalculates.

Column charts, pie charts, and line charts are examples of common ___.

WYSIWYG stands for:

On a chart, each data point is represented by a(n) ___.

Excel uses ___ to perform basic mathematical operations.

Which is the Excel operator for division?

To widen a column to fit the cell content of the widest cell in the column, use ___.

T/F: You can format multiple rows or columns simultaneously.

The ___ visually indicates which workbook cells are included in a formula calculation.

Keyboard shortcut for showing formulas?

T/F: A chart layout may include chart elements such as title, legend, & labels for the columns.

The process of specifying the appearance of cells and the overall layout of a worksheet

T/F: Scaling adjusts the width of a column to fit the widest cell contents found in the column.

Each worksheet is identified by the ___ found along the lower border of the Excel window.

On an Excel chart, the ___ identifies the patterns & colors assigned to categories in the chart

T/F: Page orientation can be changed either on the Page Layout tab or in Print Preview.

T/F: The first step in entering data by range is to select the desired range.

The symbols used to perform basic mathematical operations are called ___ operators.

Which is the Excel operator for multiplication?

What 2 tabs appear when you select a chart?

True/False: Arithmetic operators are used to perform basic mathematical operations in Excel.

In an Excel chart, a ___ is made up of related data points.

On a chart, the ___ identifies the patterns/colors assigned to the categories in the chart.

In ___, Excel maximizes the number of cells visible on the screen.

By default, new charts are inserted as ___ into the current worksheet.

On a chart, related data points form a(n) ___.

Another name for the x-axis?

T/F: A relative cell reference refers to a cell by its fixed position within the worksheet

On a chart, a value that originates in a worksheet cell is known as a(n) ___.