Shared Flashcard Set

Details

Excel Projet 1 study guide
Study guide
50
Business
01/25/2007

Additional Business Flashcards

 


 

Cards

Term
1.At any point while working with an Excel worksheet, a task pane can be opened or closed by clicking the Task pane command on the _____.
Definition
b.View menu
Term
2.The active cell can be identified in all of the following ways except _____.
Definition
d.a block arrow displays in the center of the cell
Term
3.When both the Standard toolbar and Formatting toolbar display on the same row, all of the buttons on either toolbar can be displayed by _____.
Definition
c.double-clicking the move handle on the left of each toolbar
Term
4.When the Language bar is _____, it means it is displayed on the Windows taskbar.
Definition
c.minimized
Term
4.When the Language bar is _____, it means it is displayed on the Windows taskbar.
Definition
c.minimized
Term
5. The easiest way to select a cell (make it active) is to _____.
Definition
d.use the mouse to move the block plus sign to the cell and then click
Term
6. To complete an entry into a cell, click the _____.
Definition
a. Enter box
Term
7. In Excel, a number can contain the characters _____.
Definition
d. all of the above
Term
8. When proposing a range of cells to sum using the SUM button, Excel first looks for a range of cells with numbers _____.
Definition
b. above the active cell and then to the left
Term
9. The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
Definition
b. fill handle
Term
10. When one range is copied to another, Excel displays the _____ that can be used to choose whether to copy the value with formatting, without formatting, or only copy the format.
Definition
c. Auto Fill Options button
Term
11. The _____ defines the appearance and shape of letters, numbers, and special characters.
Definition
a. font type
Term
12. A character with a point size of 10 is about _____ of an inch in height.
Definition
c. 10/72
Term
13. To display the AutoFormat dialog box shown in the accompanying figure and format a range automatically, use the AutoFormat command on the _____.
Definition
c. Format menu
Term
14. In the AutoFormat dialog box shown in the accompanying figure, the Close button or the _____ terminates the current activity and closes the AutoFormat dialog box.
Definition
a. Cancel button
Term
15. In the AutoFormat dialog box shown in the accompanying figure, the _____ allows additional formats, such as fonts or borders, to be deselected within an autoformat.
Definition
d. Options button
Term
16. The small _____ at the corners and along the sides of the rectangle that encloses an embedded chart indicate the chart is selected.
Definition
a. sizing handles
Term
17. The small box to the right of an embedded column chart contains the legend, which _____.
Definition
b. identifies the colors assigned to each bar in the chart
Term
18. When Excel is installed on a computer, the default chart type is the 2-D (two-dimensional) _____.
Definition
b. Column chart
Term
19. When you click the Tools button in the Save As dialog box, the _____ in the list that displays allows you to save a backup copy of the workbook, create a password to limit access to the workbook to be created, and carry out other functions.
Definition
d. General Options command
Term
20. A password entered in the Save As dialog box is _____ and can be up to 15 characters long.
Definition
c. case-sensitive
Term
21. The _____ can be used to quit Excel.
Definition
c. Close button and Control-menu icon on the title bar
Term
22. Clicking None at the top of the AutoCalculate shortcut menu _____.
Definition
a. turns off the AutoCalculate area
Term
23. When a cell containing an error is double-clicked, Excel switches to _____, the active cell contents display in the formula bar, and a flashing insertion point displays in the active cell.
Definition
b. Edit mode
Term
24. Excel provides the Undo command on the _____ and the Undo button on the Standard toolbar, both of which can be used to erase the most recent cell entries.
Definition
a. Edit menu
Term
25. To clear an entire worksheet, click the _____ and then press the DELETE key.
Definition
d. Select All button on the worksheet or press CTRL+A
Term
1. A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
Definition
True
Term
2. A new workbook opens with three worksheets, but additional worksheets can be added up to a maximum of 255.
Definition
True
Term
3. A number above the worksheet grid, also called the row heading, identifies each column.
Definition
False
Term
4. A letter on the left side of the worksheet grid, also called the column heading, identifies each row.
Definition
False
Term
5. To identify a cell, specify the row number first, followed by the column letter.
Definition
False
Term
6. The mouse pointer appears as a block arrow whenever it is located in a cell on the worksheet.
Definition
False
Term
7. The mouse pointer turns into the block plus sign whenever it is moved outside the worksheet or when cell contents are dragged between rows or columns.
Definition
False
Term
8. Above and to the left of the worksheet window are scroll bars, scroll arrows, and scroll boxes that can be used to move the worksheet window around.
Definition
False
Term
9. To the right of the sheet tabs at the bottom of the screen is the tab split box, which can be dragged to increase or decrease the view of the sheet tabs.
Definition
True
Term
10. The menu bar, Standard toolbar, Formatting toolbar, formula bar, and Ask a Question box display at the bottom of the screen, below the worksheet window and above the Windows taskbar.
Definition
False
Term
11. If a command on a menu with an arrow to its right is pointed to, Excel displays a submenu from which a command can be chosen.
Definition
True
Term
12. When a menu name is clicked on the menu bar, a short menu displays listing all the commands associated with a menu.
Definition
False
Term
13. A full menu lists only the most recently used commands.
Definition
False
Term
14. A dimmed command appears black or bright instead of gray, which indicates it is available for the current selection.
Definition
False
Term
15. A command with a medium blue shading to the left of it on a full menu is called a hidden command because it does not display on a short menu.
Definition
True
Term
16. The menu bar never changes, regardless of the type of work being done in Excel.
Definition
False
Term
17. Mode indicators, such as Enter and Ready, appear on the status bar and specify the current mode of Excel.
Definition
True
Term
18. Keyboard indicators, such as CAPS (Caps Lock), NUM (Num Lock), and SCRL (Scroll) show which keys are engaged.
Definition
True
Term
19. To indicate whether commands will be spoken or cell entries dictated, use the Language bar.
Definition
True
Term
20. Excel positions text right-aligned in a cell, meaning the entry displays to the far right in the cell.
Definition
False
Term
21. When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as these cells contain no data.
Definition
False
Term
22. If an error is noticed before clicking the Enter box or pressing the ENTER key, use the DELETE key to erase all the characters back to and including the one that is wrong.
Definition
False
Term
23. Excel treats any combination of numbers, spaces, and nonnumeric characters as numbers.
Definition
False
Term
24. Text entered in a cell cannot be realigned
Definition
False