Excel Chapter test

The _________ button allows you to choose whether you want to copy the values from the source area to the destination are with formatting. A. Copy Options C. Formatting Options B. Replace Options D. AutoFill Options

Auto Fill Options

You _________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. A. save C. format B. print D. clear

Format

Which of the following keys moves the insertion point to the beginning of data in a cell? A. HOME C. INSERT B. ENTER D. TAB

HOME

Which of the following keys toggles between Insert mode and Overtype mode? A. INSERT C. TAB B. ENTER D. ALT

INSERT

The ______ identifies the colors assigned to each bar in the chart on a worksheet. A. color code C. explanation B. identifier D. legend

Legend

_________________ cells involves creating a singe cell by combining two or more selected cells.

Merging

You can select any cell by entering its cell reference in the ______________.

Name Box

Pressing the __________key to complete an entry activates the adjacent cell to the right. A. RIGHT ARROW C. UP ARROW B. LEFT ARRKOW D. DOWN ARROW

RIGHT ARROW

Excel's _________________ which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

SUM function

The ________ button is located on the Quick Access Toolbar, as shown in the accompanying figure. A. Undo C. Bold B. Cell Style D. Increase Decimal

Undo

To enter a number as text, precede it with a(n) ___________. A. quotation mark (") C. plus (+) B. colon (:) D. apostrophe(')

apostrophe(')

A(n)________ chart is drawn on the same worksheet as the data. A. embedded C. embodied B. emboldened D. empowered

embedded

The ____________ is a blinking vertical line that indicates where the next typed character will appear. A. scroll box C. insertion point B. sheet tab D. split bar

insertion point

The automatically adjusted cell reference in a pasted formula is called a(n) _________________.

relative reference

The person or persons requesting the worksheet should supply their requirements in a _______________. A. blank C. requirements B. test issue D. certified

requirements

T/F: A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

True

T/F: Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

True

T/F: Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

True

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

True

Clicking the _________ box completes an entry. A. Cancel C. Enter B. Formula D. Tab

Enter

How many chart types does Excel offer? A. 5 C. 29 B. 11 D. 50

11

To enter a number such as 6,000,000,000,000 you can type that or you can type__________. A. 6,000T C. 6Q B. 6K000 D. 6E15

6E15

The ______ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet. A. AutoFormat C. AutoFunction B. AutoComplete D. AutoCalculate

AutoCalculate

The __________feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. A. AutoComplete C. AutoFormat B. AutoCorrect D. AutoTyping

AutoCorrect

Pressing the ________ keyboard shortcut key(s) selects A1. A. CRTL+HOME C. HOME B. CRTL+END D. END

CRTL+HOME

What effect does the Comma Style format have on the selected cell? A. Converts decimals to commas within a cell B. Converts decimals to commas within merged cells C. Displays cell contents with two decimal places and commas as thousands separators D. Allows for substitution of selected characters

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

What effect does the Accounting Number Format have on the selected cells? A. Converts alphabetic characters to numbers B. Displays cell contents with two decimal places that align vertically C. Performs tax calculations D. Copies the numbers of one cell to another

Displays cell contents with two decimal places that align vertically

Which of the following keys moves the insertion point to the end of data in a cell? A. HOME C. END B. DELETE D. BACKSPACE

END

To cancel an entire entry before entering it into the cell, press the _________key. A. ALT C. CTRL B. ESC D. TAB

ESC

Which of the following keys is an alternative to double-clicking the cell to edit it? A. F1 C. F3 B. F2 D. F4

F2

A________ reference is an adjusted cell reference in a copied and pasted formula. A. revised C. recycled B. relative D. retained

Relative

________ properties are associated with all Microsoft Office documents and include author, title, and subject. A. Automatic C. Replacement B. Hidden D. Standard

Standard

You can click the _______________ button arrow (Home tab l Editing group) to view a list of often used functions.

Sum

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

True

T/F: If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button in clicked.

True

T/F: To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert Tab l Charts group)

True

T/F: When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

True

T/F:With Excel in Edit mode, you can edit cell contents directly in the cell.

True

The cell into which data is being entered is referred to as the ____________ cell.

active

In Excel, a number can contain the characters___________. A. 0123456789 C. . $%Ee B. + - () , / D. all of the above

all of the above

To enter data in a cell, you must first select or activate the _____________. A. row C. column B. worksheet D. cell

cell

A(n) _________________ conveys a visual representation of data.

chart

To remove an embedded chart, you should _________ it and press the DELETE key. A. move C. hide B. drag D. click

click

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ________. A. semi-colon (;) C. period (.) B. colon (:) D. none of the above

colon (:)

Worksheet ________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

columns

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ________. A. receiver call C. receiving range B. final cell D. destination area (or paste area)

destination area (or paste area)

The _________ is the small black square located in the lower-right corner of the heavy border around the active cell. A. selection handle C. fill handle B. sizing handle D. copy handle

fill handle

As you type, Excel displays the entry in the ______________ and also displays the Cancel box and the Enter box on the formula bar.

formula bar

By default, text is ________in a cell. A. left-aligned C. justified B. centered D. right-aligned

left-aligned

A(n) ________________ chart often is used to illustrate changes in data over time.

line

Combining two or more selected cells into one cell is called _________ cells. A. merging C. combining B. mixing D. spanning

merging

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. A. range C. nearby cell B. bunch D. neighbor

range

You click the ________________ tab of the worksheet you want to view in the Excel window.

sheet

In general, use no more than _______ font types in a worksheet. A. two C. six B. four D. eight

two

An Excel _________ allows data easily to be summarized and charted. A. worksheet C. document B. workbook D. presentation

worksheet