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