Excel Chapter test

Created by trosclairkatie 

Upgrade to
remove ads

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

worksheet

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

requirements

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

cell

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

ESC

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

Enter

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 __________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 __________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

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

left-aligned

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

all of the above

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

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 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 (:)

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

apostrophe(')

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)

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

Relative

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

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

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

two

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

merging

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

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

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

CRTL+HOME

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

11

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

embedded

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

Legend

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

Standard

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

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

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

INSERT

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 moves the insertion point to the end of data in a cell?
A. HOME C. END
B. DELETE D. BACKSPACE

END

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 remove an embedded chart, you should _________ it and press the DELETE key.
A. move C. hide
B. drag D. click

click

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: When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

True

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

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: 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: 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: 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:With Excel in Edit mode, you can edit cell contents directly in the cell.

True

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

chart

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

columns

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

Name Box

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

active

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

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

SUM function

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

Sum

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

relative reference

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

Merging

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

line

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

sheet

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set