1Test Excel2007_1-9_6-15

1Test Excel2007_1-9_6-15 - Test Excel2007_1-9_6-15 Multiple...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Test Excel2007_1-9_6-15 Multiple Choice Identify the choice that best completes the statement or answers the question. ____ 1. On the Ribbon each __________ surrounds a collection of groups. a. cluster c. aggregate b. tab d. mode ____ 2. The __________ toolbar, which appears automatically based on tasks you perform (such as selecting text), contains commands related to changing the appearance of text in a worksheet. a. Quick c. Mini b. Short d. Long ____ 3. A(n) __________ is a list of additional commands associated with the selected command. a. Alt command c. call-out b. submenu d. Quick command ____ 4. In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered __________. a. text c. empty b. numeric d. incorrect ____ 5. If you prefer using the keyboard, instead of the mouse, you can press the ALT key on the keyboard to display a(n) __________. a. Keyboard picture c. Image mouse b. Key Tip badge d. Mouse image badge ____ 6. When a cell entry is positioned at the far left in the cell, it is considered __________. a. left- and right-aligned c. left-aligned b. center-aligned d. right-aligned ____ 7. In Excel, a number can contain the characters __________. a. 0 1 2 3 4 5 6 7 8 9 c. . $ % E e b. + - ( ) , / d. all of the above ____ 8. To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type __________. a. 6,000T c. 6Q b. 6K000 d. 6E15 ____ 9. A __________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. a. range c. nearby cell b. bunch d. neighbor ____ 10. The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the __________. a. receiver cell c. receiving range b. final cell d. destination area (or paste area) ____ 11. Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas. a. recalculates new c. recalculates old b. recalculates some d. recalculates all ____ 12. When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell. a. Smart Tag Actions c. Trace Error b. AutoCorrect Options d. Auto Fill Options ____ 13. The ____ button lists formatting options following an insertion of cells, row, or columns.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
a. Paste Options c. Auto Fill Options b. Insert Options d. AutoCorrect Options ____ 14. In Excel, functions can be entered using any of the following methods except the ____. a. Function command on the Tools menu c. Insert Function box in the formula bar b. keyboard or mouse d. AutoSum command on the Formulas tab ____ 15. How do you activate Range Finder to verify a formula in a cell? a.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/05/2010 for the course BIS 155 taught by Professor Dunn during the Spring '10 term at Skagit Valley College.

Page1 / 13

1Test Excel2007_1-9_6-15 - Test Excel2007_1-9_6-15 Multiple...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online