CIS EXCEL

Function

A ____ is a prewritten formula that is built into Excel.

footer

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

relative

A ____ reference is an adjusted cell reference in a copied and pasted formula. (482522)

false

A cell reference with only one dollar sign before either the column or the row is called an absolute reference. (482688)

exploded

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

true

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. (482687)

true

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. (482544)

false

A thin red border indicates the active cell. (482546)

B:sparkline

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. (482670)

indirect

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.

false

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. (482615)

False

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

15

How many chart types does Excel offer? (482531)

true

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

true

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

true

Point mode allows you to select cells for use in a formula by using your finger or the pointer. (482619)

B:CTRL+A

Press ____ to select the entire worksheet. (482543)

right arrow

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

A:CTRL+HOME

Pressing the ____ keyboard shortcut key(s) selects cell A1. (482530)

true

The <= comparison operator means less than or equal to. (482689)

true

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign. (482634)

True

The Sum button menu allows you to enter one of five often-used functions easily into a cell. (482624)

auto calculate

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. (482536)

auto fill options

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

true

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

B:Displays cell contents with two decimal places that align vertically

What effect does the Accounting Number Format have on the selected cells? (482528)

C:Displays cell contents with two decimal places and commas as thousands separators

What effect does the Comma Style format have on the selected cells? (482529)

26

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

NOW

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. (482665)

operations

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

assumptions

Cell references in a formula are called ____. (482653)

enter

Clicking the ____ box completes an entry. (482516)

merging

Combining two or more selected cells into one cell is called ____ cells. (482526)

recalculates

Every time you enter a value into a cell in the worksheet, Excel ________ all formulas. (50806)

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. (482625)

false

Excel can display characters in only three font colors: black, red, and blue. (482552)

TRUE

Excel has more than 400 functions that perform just about every type of calculation you can imagine. (482622)

print selection

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery. (482608)

insert

Which of the following keys toggles between Insert mode and Overtype mode? (482537)

False

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces. (482633)

false

Worksheet titles and subtitles should be as wordy as possible. (482545)

format

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. (482524)

B:CTRL+B

You can apply the Bold font style by pressing the ____ keyboard shortcut keys. (482525)

:

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. (482520)

false

You can select nonadjacent ranges using the SHIFT key. (482694)

range finder

You can use the ____ to check which cells are referenced in the formula assigned to the active cell. (482599)

false

You cannot format an entire column at once. (482631)

clustered column

You should use a ____ chart to compare values side by side, broken down by category. (482673)

goal

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. (482677)

page layout

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

>

All of the following are valid Excel arithmetic operators EXCEPT ____. (482584)

worksheet

An Excel ____ allows data to be summarized and charted easily. (482511)

false

Best fit means that the width of the column will be increased or decreased by a percentage you specify. (482635)

true

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell. (482547)

true

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

Accounting number format

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

MIN

The ____ function determines the lowest number in a range.

MAX

The ____ function displays the highest value in a range. (482594)

IF

The ____ function is useful when you want to assign a value to a cell based on a logical test. (482667)

Average

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.

relative

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

normal

The default view in Excel is called ____ view. (482606)

true

The equal sign (=) precedes a formula. (482613)

understand what is required

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

true

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

false

The range automatically selected by Excel is always correct. (482626)

destination area

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

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 those adjacent cells contain no data. (482549)

two or four

When working with a large worksheet, you can split the window into ____ panes. (482676)

0

When you decrease the row height to ____, the row is hidden. (482603)

Constant

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values. (482654)

D:<>

Which comparison operator means "not equal to"? (482668)

23%

Which of the following calculations multiplies 23 by 0.01?

C:=$B$4

Which of the following formulas contains an absolute cell reference? (482666)

C:Excel assigns the value in cell G15 to the active cell

Which of the following happens when you enter the formula =G15 into a cell?

B:Thursday, Saturday, Monday

Which of the following is an extension of the fill pattern Sunday, Tuesday? (482658)