Excel Ch.1, Ch.2

The ______ preceding a formula alerts Excel that you are entering a formula or function and not text.

equal sign (=)

A pie chart with one or more slices offset is referred to as a(n) _____ pie chart.

exploded

Clicking the ___ box completes an entry.

Enter

Live preview is available on a touch screen

False

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

False

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area.

False

To clear the entire worksheet, tap or click the Clear All button on the worksheet.

False

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Insert

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Operations

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

Page Layout

______is /are used to place worksheet , column, and row titles on a worksheet.

Text

A character with a point size of 10 is about 10/72 of one inch in height.

True

Cooler colors tend to pull away from the reader.

True

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

True

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

True

If a major error is made when typing data into a cell, tap or click the Cancel box in the formula bar or press the ECS key to erase the entire entry, and then reenter the data from the beginning.

True

If you accidentally undo an action , you can use the Redo button to redo it..

True

Moving from left to right, the first calculation in the order of operations is negation (-).

True

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

20xx

Which of the following calculations multiplies 23 by 0.01?

23%

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

(HOME tab | Styles group)

Which of the following is the Ribbon path to the Cell Styles button?

(HOME tab I Styles group)

Which of the following is the path to the Sum arrow?

(HOME tab | Editing group)

How many chart types does Excel offer?

10

Excel remembers the last _______ actions you have completed.

100

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

AVERAGE

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Auto Fill Options

Which of the following Option buttons gives options for filling cells following a fill operation?

Auto Fill Options

The ____ area on the status bar includes six commands as well as the results of the associated calculation on the right side of the menu.

AutoCalculate

The _____ features works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

AutoCorrect

The data you change a file is an example on a(n)_______ property.

Automatically updated

You can apply the Bold font style by pressing the ____keyboard shortcut keys.

Cntrl + B

You can open the Format Cells dialog box by pressing the ____ keys

Ctrl + 1

Press____ to select the entire worksheet

Ctrl + A

To paste copied cell contents, you can press the ____ keys.

Ctrl + V

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

Destination Area

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

ESC

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

False

A thin red border indicates the active cell

False

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

False

In a worksheet, columns typically contain information that is similar to a list.

False

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

False

When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.

False

Worksheet titles and subtitles should be as wordy as possible.

False

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab I Font group).

False

You can use the arrow keys to complete an entry in Point mode.

False

You should press the SPACEBAR to clear a cell.

False

A ____ is text and graphics that print at the bottom of every page.

Footer

You______a worksheet to emphasize certain entries an make the worksheet easier to read and understand.

Format

A ____ is text and graphics that print at the top of each page.

Header

Which of the following keys over the insertion point to the beginning of data in a cell?

Home

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Indirect

Clicking the ____ opens the Insert Function dialog box.

Insert function box in the formula bar

The ____ function determines the lowest number in a range.

MIN

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

RIGHT ARROW

A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.

Range

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

Relative

The adjusted cell references in a copied and pasted formula are called ____ cell references.

Relative

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key

Right parenthesis

______properties are associated with all Microsoft Office files and include author, title, and subject.

Standard

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

True

The most common error when entering a formula is to reference the wrong cell in the formula.

True

The opposite of merging cells is splitting a merged cell.

True

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab I Charts group).

True

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

True

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as this adjacent cells contain no data. True

True

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

True

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

True

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

True

The first step in creating an effective worksheet is to make sure you ____.

Understand what is required

The ______ button allows yo to erase recent cell entries.

Undo

You use _____ to view as XPS file.

XPS Viewer

An Excel_____ allows data to be summarized and charted easily.

Worksheet

By default, text is ______ in a cell

left-aligned