Home > Flashcards > Business > Excel Projet 1 study guide

Details Title: Excel Projet 1 study guide Description: Study guide Total Flash Cards: 50 Created: 01/25/2007 06:22:03	To study from this set of flash cards, or to create your own your own study flash cards, register HERE. If you are already a registered user, CLICK HERE.
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